Database Tuning (MOSC)

MOSC Banner

Ask about statistics data in oracle 9i

edited May 29, 2012 9:26PM in Database Tuning (MOSC) 7 commentsAnswered
Hi all,

   My db is 9.2.0.4 run on AIX 5.3 64 bit.

   I use bellow script to gather statistic. Ok, when select from DBA_TAB_COL_STATISTICS from the LAST_ANALYZED I can view my table gathered. But I wonder that where are these statistics data store ? And Do I need delete them ?

begin
  dbms_stats.gather_table_stats(
       ownname           => 'XBANK',
       tabname             => 'T_LOG',
       estimate_percent  => dbms_stats.auto_sample_size,
       method_opt        => 'for all columns size auto',
       cascade           => true,
       degree            => 7
   );
end;

  Thanks.

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