Home » RDBMS Server » Security » Table load in oracle 9i
Table load in oracle 9i [message #352408] Tue, 07 October 2008 08:45 Go to next message
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
Re: Table load in oracle 9i [message #352409 is a reply to message #352408] Tue, 07 October 2008 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 Go to previous messageGo to next message
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
Re: Table load in oracle 9i [message #352495 is a reply to message #352431] Wed, 08 October 2008 01:19 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Can I move AUD$ table to another tablespace
Next Topic: problem log in wiht SYS
Goto Forum:
  


Current Time: Sat Dec 03 01:35:25 CST 2016

Total time taken to generate the page: 0.07866 seconds