Table acess and growth
From: Amit Kaushal <amit_at_billdesk.com>
Date: 2 May 2003 02:37:32 -0700
Message-ID: <4c63c8fc.0305020137.ad0e3f1_at_posting.google.com>
Hi,
Date: 2 May 2003 02:37:32 -0700
Message-ID: <4c63c8fc.0305020137.ad0e3f1_at_posting.google.com>
Hi,
[Quoted] [Quoted] I have oracle 8.0.6 running on solaris 2.6.
The database has been up and performing for the last two years. What i want to do is as follows:
- I want to find and list the tables that get accessed the maximum number of times.
- I want to be able to find/ figure out a pattern in which the tables are growing so that i can re organise the storage parameters.
- I want to draw a graph of as to how the database has been doing.
- I also want to make a list of queries that are used regularly so that they can be tuned.
First is it possible to do this. Second how and where do i start. Please pont me towards some scripts or reading material for the above mentioned issues.
You may reply to amit_at_billdesk.com also.
TIA,
Amit Kaushal
amit_at_billdesk.com
919820422993
Received on Fri May 02 2003 - 11:37:32 CEST