cancel
Showing results for 
Search instead for 
Did you mean: 

OSS note 0001020260 Oracle Stats - HARMFUL_STATISTICS

Former Member
0 Kudos

Hi Gurus,

We have implemented the statistics script statistics_BRCONNECT_710_25.txt from this OSS note. Strangely we have issue with all tables where statistics are unlocked in this script. In the DBCHECK all these tables appear as HARMFUL_STATISTICS and then the DBA Update Statistics program deletes the statistics for these tables. Today we manually created statistics for these tables using DB20.

Can you please help asap!

Thanks a lot

AC

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Did you check the statement in the OSS note?

Caution: If you import statistics_BRCONNECT_710_25.txt 
(even though you use an older BRCONNECT version), 
BRCONNECT deletes the table statistics due to the ACTIV=R
 entries you used, which can lead to critical performance problems

We executed the same script many times and didn't face with a problem.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Have you tried the option mentioned in same note?

Creating new statistics for the affected table:

brconnect -u / -c -f stats -t <table> -f collect,allsel,keep,locked

Former Member
0 Kudos

Hi,

We used the option DB20 to create the statistics again for the affected tables. Statistics are OK now. But when we run DBCHECK all these tables appear with warning in DBCHECK with HARMFUL_STATISTICS warning. Our question is once the update statistics will run as per DBA calendar in the night, will it again delete the statistics for these tables.

Rgds

AC

lbreddemann
Active Contributor
0 Kudos

Would you mind to check whether these tables have entries in DBSTATC?

Very commonly, deleting these entries is forgot during an upgrade of the Oracle database to something >=10g.

Nowadays, all tables should have CBO stats in place, which means, there are no harmful statistics; well, except this had been setup in DBSTATC...

regards,

Lars