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

Report message to a moderator

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'

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Converting Non-Partitioned table to Partition table
Next Topic: Hint Index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 06 13:21:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.