OraFAQ Forum: Server Administration » How to query for the executed statement?

Home » RDBMS Server » Server Administration » How to query for the executed statement? (Orale 10g R2)

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

How to query for the executed statement? [message #325137]

Thu, 05 June 2008 02:13

since
Messages: 18
Registered: May 2008

Junior Member

Hi everybody!

Can I get the follwing information during a certain time?

What SQL statement had executed?

What PL/SQL pakage and procedure had called and use what parameter values to call the procedure?

My database is running in ARCHIVELOG mode.

Thanks!

Report message to a moderator