Skip to Content
0
Former Member
Oct 29, 2009 at 01:21 AM

BW, BRTools, statistics, monitoring and bitmap indexes.

21 Views

Hi all, I have a question about the above.

Oracle 10.2, Solaris 10, BW 7.00

We have a script that generates statistics weekly on our systems. lately, I have been noticing the following messages in the output after the BRTools statistics job is run:

BR0988W Bitmap index "Index_name" selected for checking statistics - please activate the monitoring attribute for table "Table_name"***

After reading SAPNotes 442395, 588688 & 408527, doing searches of SAPNotes, this forum and other forums such as ITToolbox, the answer to the above is "activate monitoring for the above/all tables". I get this.

My issue is that after seeing warnings or missing/skipped statistics, I will manually run the following

brconnect -u / -c -f stats -t all -p 4 as the SID_ORA user

When I do that, the warning message (BR0988W) does not appear in the output. And if I check the table in Oracle with something like the following:

select tablespace_name, table_name, partitioned, monitoring from all_tables where table_name = '"Table_name"';

The ouput is

TABLESPACE_NAME TABLE_NAME PAR MON

-


-


--- ---

"Tablespace_name" "Table_name" YES YES

which shows that monitoring is activated for the table.

My question is, by running "brconnect -u / -c -f stats -t all -p 4" was monitoring turned on? This would mean that I would not have to run the script suggested in 408527. Or can the BR0988W error be generated even though monitoring is activated.

The next time I see the error in the statistics output, I will run the SQL and check the status of the table before running the BRTools stats update.

  • Table_name and Index_name are just generic markers. I have checked and confirmed that I have not mistyped actual names when running select statements.