OraFAQ Forum: Reports & Discoverer » SQL statements monitoring

Home » Developer & Programmer » Reports & Discoverer » SQL statements monitoring

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

SQL statements monitoring [message #89625]

Mon, 07 June 2004 23:11

scope5
Messages: 2
Registered: June 2004

Junior Member

Hello,

Anybody know how I can monitor which SQL statements are executed on my table? I need something like a SQL history for my table.

Perhaps with the Oracle Enterprise Manager?

�

Scope5

Report message to a moderator

Re: SQL statements monitoring [message #89626 is a reply to message #89625]

Tue, 08 June 2004 00:29

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
Make use of Audit Trails to capture specific operations on a table.

Regards
Himanshu

Report message to a moderator

Re: SQL statements monitoring [message #89630 is a reply to message #89626]

Tue, 08 June 2004 02:55

scope5
Messages: 2
Registered: June 2004

Junior Member

I have activated in the init file audit trial.
Then I have entered the command audit all by [[user]];
But in which table can I now see the SQL statements which are executed on the related table?

scope5

Report message to a moderator

Re: SQL statements monitoring [message #89652 is a reply to message #89630]

Sun, 13 June 2004 23:13

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
Its DBA_AUDIT_SESSION.Its owner is SYS.

HTH
Regards
Himanshu

Report message to a moderator

Previous Topic:	Bitmap reports
Next Topic:	call report from report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 02:28:09 CDT 2024