Gary
I had this problem recently
You need timed stats to true to get meaningful info.
However - I I could not resolve why DBMS_SYSTEM would not work
I used DBMS_SUPPORT instead - and it gave me what I wanted and worked
fine.
Regards
John Fak
Oracle DBA
_____________________
Accenture Workforce Solutions
mobile: +44 (0)778 655 1214
landline: +44 (0)207 844 6981
Octel : (46981)
mailto:john.[Email address protected]
-----Original Message-----
From: Gary Colbran (GJ)
[mailto:oracledba-ezmlmshield-x73720270.[Email address protected]
Sent: 30 September 2004 13:14
To: LazyDBA Discussion
Subject: Unable to start trace
Hi,
dbms_system.set_sql_trace_in_session should output to the
user_dump_dest directory. Mine gives procedure completed sucessfully,
but no trace file on the session. Why would this occur ? I checked all
the rights to the directory, and they are fine, I can read/write to
the directory, but oracle is not starting a trace.
sid and serial# are from v$session. Is there anyway to check
whether the trace is on in as session ?
neither dbms_system.set_sql_trace_in_session or
dbms_session.set_sql_trace work, and
dbms_system.set_ev(sid,serialno#,10046,12,'') also gives no output.
Do I require time_statistics set true, or another system
parameter ?
Cheers
GJC
==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Oracle LazyDBA home page