| how to use the statistical information from analyze command? [message #370895] |
Thu, 02 March 2000 11:48  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
