| How to Measure Database Usage [message #59729] |
Thu, 18 December 2003 11:21  |
N.A. Jam
Messages: 23
Registered: January 2003
|
Junior Member |
|
|
Hi all.
I am looking for a way to count the number of selects, inserts and updates done in a day.
Is there a way of doing this?
Thanks in advance.
|
|
|
|
| Re: How to Measure Database Usage [message #59732 is a reply to message #59729] |
Thu, 18 December 2003 21:01  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Session level info can be captured by using user level tracing, u can check each command issued by the user using trace files in user_dump_destination in ur init.ora and you can check command column in v$session view to check the command currently running in diff connected sessions only. And to get the info abt whole day's activities u can use oracle's audit feature. You can use triggers also but upto some extends.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
