| Most often used tables?? [message #55106] |
Fri, 03 January 2003 09:15  |
raman
Messages: 66
Registered: February 2000
|
Member |
|
|
Hi
I would like to see most often used tables by the users so that I can keep them in buffer cache! Please give me a suggestion regarding this.
thankyou,
Raman
mrrj@hotmail.com
|
|
|
|
| Re: Most often used tables?? [message #55114 is a reply to message #55106] |
Fri, 03 January 2003 16:59  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
In Oracle 9i, you have an option to monitor the tables DML activity. To enable it do:
ALTER TABLE table_name MONITORING;
Then query the USER_TAB_MODIFICATIONS table:
SQL> desc user_tab_modifications
Name Null? Type
----------------------------------------- -------- --------------
TABLE_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_NAME VARCHAR2(30)
INSERTS NUMBER
UPDATES NUMBER
DELETES NUMBER
TIMESTAMP DATE
TRUNCATED VARCHAR2(3)
The same approach is used to determine when to analyze schema objects in this script
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Most often used tables?? [message #55212 is a reply to message #55106] |
Fri, 10 January 2003 15:49 |
raman
Messages: 66
Registered: February 2000
|
Member |
|
|
My database is 8.1.7.4.1..
There are 500 tables and if I start monitoring every table, would I have to face any performance issues...or any other dis-advantages...??
thanks,
-raman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
