how to view results after analyze database

[hoctro]

I ran exec dbms_utility.analyze_database('COMPUTE');
How do I view the results ?
Thanks

[pando]

well after analyze dba_tables, dba_indexes are populated, you can then see the statistics from these views

[hoctro]

I tried viewing those two tables
I am not sure what to query and look for from this analyze. What sort of info should I query for ?

If I run the analyze database again, date from these two views will change rite ?

[pando]

well basically when analyze table is to update the statistics so the optimizer can elaborate the execution plans more accurately, so I dont know what do you mean any query to get the info...
The columns we might be interested are num_rows, blocks, empty_blocks, chain_cnt, avg_row_len etc Is this what you are saying you want to know?

[hoctro]

right on,Pando.
I was referring to the num_rows and etc

[marist89]

You can also look at dba_tables.last_analyzed for the timestamp of when the object was last analyzed.

[padmam]

Hi, 4th May 2001 19:53 hrs chennai

what you have done is OK but look the reason at the bottom of the first reason.

Reason1
=====
To update statistics on the table and all its indexes, issue the following command from SQLPlus:

ANALYZE TABLE COMPUTE STATISTICS;

To update statistics only on the table without indexes, issue the following command from SQLPlus:

ANALYZE TABLE COMPUTE STATISTICS FOR TABLE;

To update statistics only for indexes on the table without indexes, issue the following command from SQLPlus:

ANALYZE TABLE COMPUTE STATISTICS FOR ALL INDEXES;

To recalculate statistics Oracle may require big amount of temporary space, up to four times of the table. So you may need to increase a SORT_AREA_SIZE for that .Otherwise yo may use ESTIMATE STATISTICS. (1064 rows ...?)

==========
Reason 2
======

The reason that you are getting a different number in the NUM_ROWS column in the USER_TABLES (or ALL_TABLES or DBA_TABLES) views than the actual value
is that NUM_ROWS is updated only when you analyze the table.

For example, if your table has 1000 records and you issue:

ANALYZE TABLE table_name COMPUTE STATISTICS;

The NUM_ROWS column at that point will be 1000.

At this point, if you insert 1000000 records, and do NOT analyze the table
again, you will have 1100000 records, but NUM_ROWS will still be 1000.

look at
=====
http://otn.oracle.com/support/s_repo...ent/591032.htm


Cheers

Padmam