Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Creating an Oracle SQL trace file (Read 3602 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Creating an Oracle SQL trace file
01.12.07 at 13:40:06
 
Creating an Oracle SQL trace file
 
To get runtime information for a session you can turn on the Oracle SQL trace facility.
 
To turn SQL trace on for the current session execute:
alter session set sql_trace=true;
 
You can also turn on the SQL trace for another session using:
sys.dbms_system.set_sql_trace_in_session(session's id,serial number, true)
 
You can use this query to find out the session´s id and serial number:
select sid,serial#,action,v.* from v$session v
 
Using the sid and serial# from the previous query you could run e.g.:
begin sys.dbms_system.set_sql_trace_in_session(305,6726, true); end;
 
The SQL trace files are created in the user_dump_dest directory. You can find out where this is on your database by running the following query:
 
select value from v$parameter  where name = 'user_dump_dest'.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1