Home » RDBMS Server » Performance Tuning » Trace files not getting generated
Trace files not getting generated [message #127132] Fri, 08 July 2005 19:11 Go to next message
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
Re: Trace files not getting generated [message #127149 is a reply to message #127132] Sat, 09 July 2005 03:44 Go to previous messageGo to next message
Frank Naude
Messages: 4560
Registered: April 1998
Senior Member
Hi,

Views like USER_ROLE_PRIVS and USER_SYNONYMS are using SYS objects to which you may not have access.

Do you get the same error when you select from tables you own?

Best regards.

Frank
Re: Trace files not getting generated [message #127448 is a reply to message #127149] Mon, 11 July 2005 14:19 Go to previous message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Hi Frank,
Appreciate your response! I'm getting the trace files now (I haven't made changes on the system though!). But still not able to autotrace.

Thanks,
Sri
Previous Topic: how to find out where oracle is using paging and swapping (merged)
Next Topic: Regarding CPU utilization
Goto Forum:
  


Current Time: Mon Jun 17 12:41:24 CDT 2019