Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Tip of the Month: Index Browning
Winnie is right.
Be also advised that only one results may be store into that table at any time. Therefore, you must analyze indexes one at a time. If you want to keep the data, you'll need to store it into another table.
sylvain
sleclerc_at_magrit.com
> -----Original Message-----
> From: Winnie Liu [SMTP:oracle_dba_at_zdnetmail.com]
> Posted At: Tuesday, September 22, 1998 12:27 AM
> Posted To: server
> Conversation: DBA Tip of the Month: Index Browning
> Subject: Re: DBA Tip of the Month: Index Browning
>
> I believe you have to issue something like :
>
> analyze index <indexname> validate structure.. to generate information
> for
> index_state. not just any analyze with compute statistics.
>
> Winnie
>
> Ken Walters wrote in message <36065c5e.1127503874_at_nntp.pbs.org>...
> >On Fri, 18 Sep 1998 13:30:07 -0400, Devinder Pal Singh
> ><Devinder_Pal.Singh_at_pharma.novartis.com> wrote:
> >
> >>When you analyse your index look for this information in
> index_stats.
> >
> >My sys.index_stats table is empty, but I just did a full analyze
> >compute statistics. Do I need to do something special to have it
> store
> >the index information in this table?
> >--
> >Ken Walters
> >kwalters_at_pbs.org
> >DBA
> >Public Braodcasting Service
> >kwalters_at_pbs.org
>
Received on Tue Sep 22 1998 - 12:48:16 CDT