OraFAQ Forum: Server Administration » How to track all "selects" thrown against a table ?

Home » RDBMS Server » Server Administration » How to track all "selects" thrown against a table ?

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

How to track all "selects" thrown against a table ? [message #248339]

Thu, 28 June 2007 12:32

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

How to track all "selects" thrown against a table ? Only using auditing ? Any other way ?

Thanks in advance

Report message to a moderator

Re: How to track all "selects" thrown against a table ? [message #248341 is a reply to message #248339]

Thu, 28 June 2007 12:37

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

audit select on ...

Regards
Michel

Report message to a moderator

Re: How to track all "selects" thrown against a table ? [message #248343 is a reply to message #248341]

Thu, 28 June 2007 12:41

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I guess only AUIDTING

Also check Syntax for trigger

Create or replace trigger <trigger_name>

before/after insert/update/delete

This shows only after insert, update or delete trigger will get fire not on select statement.

Report message to a moderator

Re: How to track all "selects" thrown against a table ? [message #248344 is a reply to message #248343]

Thu, 28 June 2007 12:51

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes there is another way: FGA, Fine-Grained Auditing.

Regards
Michel

Report message to a moderator

Previous Topic:	multiplexing the controlfile
Next Topic:	Background process to read data from data files to memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 17 22:10:28 CDT 2026