OraFAQ Forum: Server Administration » How to monitor the SQL statements as they come

Home » RDBMS Server » Server Administration » How to monitor the SQL statements as they come

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

How to monitor the SQL statements as they come [message #62264]

Thu, 08 July 2004 05:52

Sameh Meligy
Messages: 4
Registered: July 2004

Junior Member

I need to monitor an instance of Oracle and see the SQL statements being received, in real-time, to help me out in troubeshooting an application.

Please, help.

Report message to a moderator

Re: How to monitor the SQL statements as they come [message #62266 is a reply to message #62264]

Thu, 08 July 2004 06:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please have a look here
you can change the scriot easily to fit your need.

u may want to write a simple wrapper around this sql
to schedule this in cron or anysceduler or dbms_job
to run between a start_time and end_time and spool the output, so that it can be mailed to u.

http://www.dbasupport.com/oracle/scripts/Detailed/42.shtml

Report message to a moderator

Re: How to monitor the SQL statements as they come [message #62267 is a reply to message #62266]

Thu, 08 July 2004 06:50

Sameh Meligy
Messages: 4
Registered: July 2004

Junior Member

Thank you Mahesh

Report message to a moderator

Previous Topic:	Please help me to drop online redo log file! and Thank Crok and Frank
Next Topic:	Datafiles on different disks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:31:31 CDT 2024