Home » RDBMS Server » Server Administration » how to use the statistical information from analyze command?
how to use the statistical information from analyze command? [message #370895] Thu, 02 March 2000 11:48 Go to next message
Jessica
Messages: 3
Registered: March 2000
Junior Member
I am trying to use ANALYZE INDEX index_name VALIDATE
STRUCTURE COMPUTE
STATISTIC command to monitor the space usage. The
book said I can collect
the statistics from USER_TABLES, USER_INDEXES and
USER_CLUSTERS. Do you know what are the column names that will contains the useful information?
Re: how to use the statistical information from analyze command? [message #370920 is a reply to message #370895] Tue, 07 March 2000 08:22 Go to previous message
Atavur Rahaman S.A
Messages: 23
Registered: January 2000
Junior Member
Hello,

Good Day!

When you'll use ANALYSE INDEX WITH Optional Parameters then in Oracle Version 7.x we will get a message saying that "Refer to Data Dictionary"
At this moment better to check USER_TABLES instead of USER_CLUSTERS/INDEXES & ANALYZE COMMAND. There are some columns which are present in all the three tables so it could be better to go for USER_TABLES.

In USER_TABLES, there is a lot of information regarding the blocks/Tables, Clusters & Indexes.

For Example:- These are the columns which we can check and get the status regarding the tables/clusters/tablespace/Database/Leaf Blocks/Time_Calculation/../..etc

SQL> Desc USER_TABLES
-----------------------------------------
TABLE_NAME
TABLESPACE_NAME
CLUSTER_NAME
TOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
AVG_BLOCKS_PER_KEY
PCT_THRESHOLD
LOGGING
CLUSTER_TYPE
INCLUDE_COLUMN
...........
...........
.........
....
.......
BUFFER_POOL

Regards

Atavur Rahaman S.A
Previous Topic: NOT IN operator - very slow
Next Topic: Nested data types
Goto Forum:
  


Current Time: Wed Oct 21 10:37:47 CDT 2020