check database ended with warning

[Former Member]

Hi All,

When i perfomed check database, it met with few warnings:

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 27 files on disk 3) 172789760 KB (> 122504860 KB)

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPSR3.TISSR_OUT_HEADL

BR0973W Database operation alert - level: WARNING, operation: Archive log backup, condition: Operation too old or has not been run in clean-up period

BR0976W Database message alert - level: ERROR, line: 490549, time: 2011-03-08 15.31.02, message:

ORA-00600: internal error code, arguments: [kqlfFillBindData:1], [645], [120], [], [], [], [], []

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

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2148 (>< 16384,4096)

BR0978W Database profile alert - level: ERROR, parameter: QUERY_REWRITE_ENABLED, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: WARNING, parameter: SHARED_POOL_SIZE, value: 322961408 (< 400 MB)

BR0978W Database profile alert - level: WARNING, parameter: STAR_TRANSFORMATION_ENABLED, value: FALSE (<> TRUE)

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

Kindly help me as i am unable to understand what to do and where to start from...

Thanks Disha

[Former Member]

Please refer SAPnote- Note 1366660 - BRCONNECT warning BR0978W for MAX_DUMP_FILE_SIZE for this problem.

[former_member182505]

Hi

You should maintain Oracle parameter recommendations for the warning .

thanks

sadiq

[Former Member]

Hi,

What oracle parameter setting should i go with,?

Actually problem is with, we can extend datafile upto 27 and in my system it has reached to 30.. tablespace is increasing with the fast pace.

Help urgently as it seems it would crash.

Should i clean logs via db13.? or if i clean, would it affect my system?

Regards

Disha

[Former Member]

ORA-00600: internal error code, arguments: kqlfFillBindData:1, 645, 120], [, ], [, ], [

You should definitely check this one..

Check [this|; URL for the solution.

For the other checks/warnings, you should check the Oracle parameter recommendations note and make the correct modifications in transaction db17.

Kind regards,

Mark