Home » RDBMS Server » Performance Tuning » dbms_session.set_sql_trace_in_session('12,25')
dbms_session.set_sql_trace_in_session('12,25') [message #196765] Sat, 07 October 2006 02:21 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Sir we are using 8i on windows
when i execute the following to enable sql tracing
dbms_session.set_sql_trace_in_session('12,25')
i got the following error

*
ERROR at line 1:
ORA-06550: line 1, column 20:
PLS-00302: component 'SET_SQL_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

can u please helpp me in this regard?
thanx in advance
Re: dbms_session.set_sql_trace_in_session('12,25') [message #196767 is a reply to message #196765] Sat, 07 October 2006 03:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Do you have EXECUTE right on DBMS_SYSTEM package?

select object_type, owner from dba_objects
where object_name='DBMS_SYSTEM'
Re: dbms_session.set_sql_trace_in_session('12,25') [message #196779 is a reply to message #196767] Sat, 07 October 2006 04:56 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
thanx for ur reply it was really helpful for me
Re: dbms_session.set_sql_trace_in_session('12,25') [message #196802 is a reply to message #196779] Sat, 07 October 2006 10:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're welcome.
Previous Topic: Converting Non-Partitioned table to Partition table
Next Topic: Hint Index
Goto Forum:
  


Current Time: Sat Dec 03 01:14:29 CST 2016

Total time taken to generate the page: 0.07657 seconds