Home » RDBMS Server » Server Administration » How to track all "selects" thrown against a table ?
How to track all "selects" thrown against a table ? [message #248339] Thu, 28 June 2007 12:32 Go to next message
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
Re: How to track all "selects" thrown against a table ? [message #248341 is a reply to message #248339] Thu, 28 June 2007 12:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
audit select on ...

Regards
Michel
Re: How to track all "selects" thrown against a table ? [message #248343 is a reply to message #248341] Thu, 28 June 2007 12:41 Go to previous messageGo to next message
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.
Re: How to track all "selects" thrown against a table ? [message #248344 is a reply to message #248343] Thu, 28 June 2007 12:51 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there is another way: FGA, Fine-Grained Auditing.

Regards
Michel
Previous Topic: multiplexing the controlfile
Next Topic: Background process to read data from data files to memory
Goto Forum:
  


Current Time: Thu Dec 08 14:10:16 CST 2016

Total time taken to generate the page: 0.10136 seconds