Home » RDBMS Server » Server Administration » how we can track daily inserted record in tables
how we can track daily inserted record in tables [message #287468] Wed, 12 December 2007 05:39 Go to next message
ynpatil
Messages: 1
Registered: December 2007
Location: mumbai
Junior Member
hi
i have following query
i want track on tables.so can we check that how many record inserted daily. is it any information oracle that can be used in my application

Thanks
Waiting for your reply
Re: how we can track daily inserted record in tables [message #287471 is a reply to message #287468] Wed, 12 December 2007 05:46 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can:
- activate auditing (see AUDIT_TRAIL parameter and AUDIT statement)
- activate table monitoring (just for statistics purpose, see ALTER TABLE statement and DBA_TAB_MODIFICATIONS view)

Regards
Michel
Previous Topic: connect / as sysdba fails with ORA-09925 error
Next Topic: Assigning privilege
Goto Forum:
  


Current Time: Mon Dec 05 09:13:56 CST 2016

Total time taken to generate the page: 0.27249 seconds