V$ tables??? [message #1604] |
Wed, 15 May 2002 12:40 |
Darren
Messages: 13 Registered: February 2002
|
Junior Member |
|
|
Does Oracle have a system V$ table that would provide information as to how many times a DML (inserts & updates) is executed against a table? Or possibly how many users execute DML against a particular table?
I'm trying to find out if our INITRANS parameter is set correctly on a particular table & it's associated indices. I've read where the INITRANS parameter should be left at it's default UNLESS it's accessed by many users at the same time. This table is accessed by many users.
Thanks,Darren Meyers
|
|
|
|
Re: V$ tables??? [message #1625 is a reply to message #1609] |
Thu, 16 May 2002 10:15 |
Darren
Messages: 13 Registered: February 2002
|
Junior Member |
|
|
Thanks for the suggestion. I hadn't even thought about auditing. The event I want to audit would be an insert or update to one specific table.
Thanks again for the suggestion.
|
|
|