Re: How to analyze statistics on a table/ partition

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<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,
> avsrk

Hi Subrahmanyam

How about DBA_TABLES there is a column on this dictionary table which shows the rows existing in the table, the column is called NUM_ROWS, you have to run the ANALYZE TABLE command first to collect the statistic for the table you are interested though.

regards

koumpilai Received on Mon Apr 07 2003 - 18:25:23 CEST