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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:41:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.