db stat warnings

Former Member — Thu, 31 Aug 2006 07:16:45 GMT

Hi,

we have scheduled Check and Update optimizer daily.

Now it shows me following warning messages.

BR0988W Bitmap index /BI0/F0AFSD_C01~09 selected for checking statistics - please activate the monitoring attribute for table SAPBWD./BI0/F0AFSD_C01

BR0986W Index SAPBWD./BI0/IMATERIAL~0 is unbalanced - please rebuild the index

SO can any body tell me

1. how to activate monitoring attribute for table.

2. How to rebuild the index.

What is the use of running this update stats daily.I think it will improve the performance.

Pls help...

Regards,

viren.

Re: db stat warnings

Former Member — Thu, 10 May 2007 12:31:29 GMT

Ans1: go to oracle prompt sqlplus /nolog

conn /as sysdba

and issue

ALATER TABLE <tablename> MONITOR;

Ans2: To rebuild index, runreport RSORAANA.

SA38 --> RSORAANA, Here u can mention index name and select rebuild radio button.

Naresh