Database Administration (MOSC)

MOSC Banner

Table Statistics

edited Jan 13, 2012 1:39AM in Database Administration (MOSC) 5 commentsAnswered

Hello

I have three questions

1)

When I am importing schema with version 102.0.2, getting warning (gues it while exporting it does exports defnition along with the statistics)

'exporting questionable statastics',

Can you make me clear on this

2) I have a table count 25923076 rows, when I check the table statistics like num_rows, empty_blocks, blocks all are null,

     cant it be updated automatically without analyze table <table_name> compute statistics and when does the oracle analyzes the table

3) the above same table altered with a new column of datatype number and updated with a sequence,

after analyzed the table , the size of the table is same as the before, so how does this data gets inserted in the same blocks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center