BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVE

[Former Member]

Hi,

While doing DBCheck one of my system i found this error

BR0973W Database operation alert - level: WARNING, operation: cdvkvbva.sta, time: 2007-06-07 06.05.02, condition: Last update optimizer stati

BR0976W Database message alert - level: WARNING, line: 13165, time: 2007-06-07 22.53.58, message:

BR0976W Database message alert - level: WARNING, line: 13184, time: 2007-06-07 22.55.23, message:

BR0976W Database message alert - level: WARNING, line: 13203, time: 2007-06-07 22.57.35, message:

BR0976W Database message alert - level: WARNING, line: 13590, time: 2007-06-08 00.09.04, message:

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

How to resolve please help what to check in DB17

Thanks

Punit

[former_member204746]

BR0973W Database operation alert - level: WARNING, operation: cdvkvbva.sta, time: 2007-06-07 06.05.02, condition: Last update optimizer stati

<b>This means that your last statistics run failed, check file cdvkvbva.sta for more information</b>

BR0976W Database message alert - level: WARNING, line: 13165, time: 2007-06-07 22.53.58, message:

<b>check file alert_SID.log for more information, I suspect this to be a "checkpoint not complete" error</b>

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

<b>Check SAP note 124361 if on ORacle 8 or 9 and check what value STATISTICS_LEVEL should be set at. adapt DB16 and initSID.ora accordingly</b>

[Former Member]

BR0973W Database operation alert - level: WARNING, operation: cdvkvbva.sta, time: 2007-06-07 06.05.02, condition: Last update optimizer stati

<b>This means that your last statistics run failed, check file cdvkvbva.sta for more information</b>

Yes Last run statistics failed how to work around

BR0976W Database message alert - level: WARNING, line: 13165, time: 2007-06-07 22.53.58, message:

<b>check file alert_SID.log for more information, I suspect this to be a "checkpoint not complete" error</b>

Yes it shows this error only how remove this error please help

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

<b>Check SAP note 124361 if on ORacle 8 or 9 and check what value STATISTICS_LEVEL should be set at. adapt DB16 and initSID.ora accordingly</b>

Its Oracel 10g how to work in DB16/DB17 to remove this error

Looking forward to hear from you

Thanks & Regards

Punit Maini

[former_member204746]

Yes Last run statistics failed how to work around

<b>--> check file cdvkvbva.sta to get error message and search SAP notes with them</b>

"checkpoint not complete" error

Yes it shows this error only how remove this error please help

<b>--> you read SAP 79341 - Checkpoint not complete</b>

Its Oracel 10g how to work in DB16/DB17 to remove this error

<b>--> You read SAP note 830576 - Parameter recommendations for Oracle 10g, adapt Oracle parameters accordingly, then you go in DB17 and change parameters to match SAP note 830576 recomemdantions

</b>

[Former Member]

BR0973W Database operation alert - level: WARNING, operation: cdvkvbva.sta, time: 2007-06-07 06.05.02, condition:

After seeing into file we found this error

BR0301E SQL error -20000 in thread 4 at location stats_tab_collect-18, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPR3"', TABNAME => '"/BI0/0P00000025"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COL

ORA-20000: Unable to analyze TABLE "SAPR3"."/BI0/0P00000025", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 13149

ORA-06512: at "SYS.DBMS_STATS", line 13179

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPR3./BI0/0P00000025

BR0976W Database message alert - level: WARNING, line: 13165, time: 2007-06-07 22.53.58, message:

"checkpoint not complete" error

-

---

SAP 79341 - Checkpoint not complete

The note which you have suggested is not suited to my environment what are the other possibilities the above error i am facing in one of the server does there i any data loss

Thanks the 3 rd problem is solved

Punit

[former_member204746]

for sta error:

sqlplus / as sysdba

grant analyze any to "OPS$[DOMAIN]\[SID]ADM","OPS$=[DOMAIN]\SAPSERVICE[SID]";

do not forgot to award points for useful answers.

[Former Member]

Hi Punit,

What's your Oracle version?

Regards,

JC Llanes.

[Former Member]

Oracle release is 10.2.0.2

[Former Member]

Hi Punit,

It seems that you have some Oracle obsolete parameters.

Please, follow Note 830576 to set the correct values. You can search for obsolete parameters running "SELECT NAME FROM V$OBSOLETE_PARAMETER WHERE ISSPECIFIED = 'TRUE';".

Probably you have the old "statistics_level='typical'" set at your initSID.ora file.

Best Regards,

JC Llanes.