Database Tuning (MOSC)

MOSC Banner

analyze table t validate structure cascade quesiton

edited Oct 12, 2009 2:04AM in Database Tuning (MOSC) 2 commentsAnswered
 i just meet some situation, that like block corrupt  and table high water and sql tunning

1.block corrupt 


just from analyze table t validate structure cascade

2.table high water

SQL> analyze table test1 compute statistics;

Table analyzed


Querying dba_tables for 'Blocks' and 'Empty_blocks' should give the high water mark.

Blocks -- > Number blocks that has been formatted to recieve data
Empty_blocks ---> Among the allocated blocks, the blocks that were never used

3.sql tunning

exec DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'imuse01', TABNAME => 'SUBSCRIBEINFO', GRANULARITY => 'DEFAULT' ,CASCADE => TRUE);

maybe i am freshman, so  i want to ask a quetion,  can  any explain

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