| Trace files not getting generated [message #127132] |
Fri, 08 July 2005 19:11  |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
I'm running Oracle9.2.0.4.0 on Linux 9. (this is a test box)
(fyi -
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production)
1.Am not able to use autotrace facility (The plustrace role is showing up in the user session).
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
PUBLIC PLUSTRACE NO YES NO
SCOTT CONNECT NO YES NO
SCOTT RESOURCE NO YES NO
Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view
SP2-0612: Error generating AUTOTRACE EXPLAIN report
SQL> select * from user_synonyms;
no rows selected
Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view
SP2-0612: Error generating AUTOTRACE EXPLAIN report
SQL> set autotrace off
SQL>
2. Am not able to generate any trace files either (using sql_trace parameter).
Can anyone tell me what could be the peoblem.
Thanks,
Sri
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
