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

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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 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.

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 Go to previous message
Michel Cadot
Messages: 68718
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 06:28:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.