How to analyze statistics on a table/ partition
From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 3 Apr 2003 13:42:32 -0800
Message-ID: <25c1993e.0304031342.15683fbd_at_posting.google.com>
Date: 3 Apr 2003 13:42:32 -0800
Message-ID: <25c1993e.0304031342.15683fbd_at_posting.google.com>
Dear Oracle Gurus,
Suppose i want to know statistics on a particular table like 'how many
insertions happened for the last one hour " and like that over a
period of one day, how can i do that ?? I dont want to do select
count(*) at time t1 and do another select count(*) at t1 + 1 hr and do
a diff. Are there any data dictionaries that can be queried to get
some metrics.
Similarly, how can i get information like How much space a record in
the table holds and total space occupied by the table..available free
space or percent growth in the table size...
-thx,