| Top 10 most active tables [message #57555] |
Mon, 23 June 2003 02:46 |
defic
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
May I know is there any way to check which tables/indexes in an Oracle8i DB that are most frequently accessed?
I have a huge database, about 100++ tables with a combined total rows of about 1 million. DB Server memory is 2 giga, which is always ~99% utilised... and CPU usage ~90% utilised all the time.
Will appreciate if anyone can help me pinpoint which tables are causing the resource drain. Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
