Home » SQL & PL/SQL » SQL & PL/SQL » V$ tables???
V$ tables??? [message #1604] Wed, 15 May 2002 12:40 Go to next message
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

Report message to a moderator

Re: V$ tables??? [message #1609 is a reply to message #1604] Wed, 15 May 2002 21:54 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You should AUDIT the DML for a reasonable amount of time in order to get an idea of what is the usage of this table.

Oracle provides several ways to do that.

MHE

Report message to a moderator

Re: V$ tables??? [message #1625 is a reply to message #1609] Thu, 16 May 2002 10:15 Go to previous message
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.

Report message to a moderator

Previous Topic: list of tables
Next Topic: HELP! variable in global temporary table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:25:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.