OraFAQ Forum: Server Administration » how to trace the history of sql excute

Home » RDBMS Server » Server Administration » how to trace the history of sql excute

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to trace the history of sql excute [message #50104]

Thu, 28 February 2002 17:35

Linde
Messages: 1
Registered: February 2002

Junior Member

how to trace the history of sql excute? i want to know how to get the message about the all sql command excute by oracle.
Thanks.

Report message to a moderator

Re: how to trace the history of sql excute [message #50126 is a reply to message #50104]

Fri, 01 March 2002 13:01

andrew again
Messages: 2577
Registered: March 2000

Senior Member

You'd be very unlikely to want every sql statement on the entire server. For a specific session to start tracing (with timing) you would:
alter session set time_statistics=true;
alter session set sql_trace=true;
-- run statements
alter session set sql_trace=false;

then get the latest *.trc file from user_dump_dest (select from v$parameter).

Report message to a moderator

Previous Topic:	Re: certification guide -8/8i/9i
Next Topic:	i want to select the last record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 20:23:45 CST 2024