Users Online
· Guests Online: 139
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
Articles Hierarchy
How to Trace SQL in the Current Session
How to Trace SQL in the Current Session
Trace SQL in the current session:
alter session set timed_statistics=true;
alter session set max_dump_file_size=unlimited;
alter session set tracefile_identifier='20Jul2012_special_trace_1';
alter session set events '10046 TRACE NAME CONTEXT FOREVER,level 12';
..Run some things..
select 'close cursor' from dual; --to dump the rowsource information
alter session set events '10046 trace name context off';
Trace file will be in diag/admin/db_name/instance_name/trace
Trace SQL in the current session:
alter session set timed_statistics=true;
alter session set max_dump_file_size=unlimited;
alter session set tracefile_identifier='20Jul2012_special_trace_1';
alter session set events '10046 TRACE NAME CONTEXT FOREVER,level 12';
..Run some things..
select 'close cursor' from dual; --to dump the rowsource information
alter session set events '10046 trace name context off';
Trace file will be in diag/admin/db_name/instance_name/trace
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.