OraFAQ Forum: Security » Table load in oracle 9i

Home » RDBMS Server » Security » Table load in oracle 9i

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

Table load in oracle 9i [message #352408]

Tue, 07 October 2008 08:45

gunbol
Messages: 4
Registered: September 2007

Junior Member

Hello,

I have an Oracle 9i Rac database cluster. I have an application running on this server, and I want to find out the number of select, insert, update, delete on a specific table in a specific tablespace.

Do you know if i can find out this information ?

Thank you for your help.

Gunther

Report message to a moderator

Re: Table load in oracle 9i [message #352409 is a reply to message #352408]

Tue, 07 October 2008 08:51

Michel Cadot
Messages: 68499
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Activate AUDIT.

Regards
Michel

[Updated on: Tue, 07 October 2008 08:51]

Report message to a moderator

Re: Table load in oracle 9i [message #352431 is a reply to message #352409]

Tue, 07 October 2008 10:41

gunbol
Messages: 4
Registered: September 2007

Junior Member

Hello,

Unfortunately I am in a production system, and the audit trail is not activated.

Any other Idea ?

Best regards,

Gunther

Report message to a moderator

Re: Table load in oracle 9i [message #352495 is a reply to message #352431]

Wed, 08 October 2008 01:19

Michel Cadot
Messages: 68499
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Activate a SQL or net trace or put a sniffer on your network.

Regards
Michel

Report message to a moderator

Previous Topic:	Can I move AUD$ table to another tablespace
Next Topic:	problem log in wiht SYS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 03:24:23 CDT 2023