cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Database administration alert

Go to solution
Former Member

on ‎2010 Mar 29 7:01 AM

0 Kudos
165

Dear all,

I am getting error in Db check in db13.

Please suggest how to solve it.

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 11 files on disk 5) 82

BR0280I BRCONNECT time stamp: 2010-03-25 14.21.16

BR0972I Checking database operations...

BR0280I BRCONNECT time stamp: 2010-03-25 14.21.16

BR0974I Checking database messages in F:\ORACLE\SOL\SAPTRACE\BACKGROUND\alert_sol.log ...

BR0280I BRCONNECT time stamp: 2010-03-25 14.21.17

BR0977I Checking database profile...

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: 264241152 (< 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)

BR0280I BRCONNECT time stamp: 2010-03-25 14.21.17

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2010-03-25 14.21.17

BR0955I Number of signaled error/warning/exception alerts for database administration: 0/1/0

BR0956I Number of signaled error/warning/exception alerts for database operations: 0/0/0

Regards,

Kumar

Show replies
Show replies
Answer
View Entire Topic
Former Member
‎2010 Mar 29 7:11 AM
0 Kudos

Questions like this are asked on a regular basis.

Please try the search button, here or at http://service.sap.com/notes , using keywords like CRITICAL_TABLESPACE and OPTIMIZER_FEATURES_ENABLE and ...., one by one.

PS:

By the way, why posting the same question again? What's wrong with my answer here:

Please don't be that lazy !!

Edited by: Joe Bo. on Mar 29, 2010 8:15 AM

Show replies
Show replies
Former Member
‎2010 Mar 29 8:44 AM
0 Kudos

Hi Joe,

Both the posts are not same because now i am getting more error in db check. as you have suggest search for the error ,but i did get the ans bze there is one sap note for parameters in 10g that i know.

My problem is our counsanlty are saying the parameters are set right and the error can be ignore in DB 13 .so i need to now it is true or if we don't correct them now they an cause damage to the system in further.Please suggests

Regards,

Kumar

Former Member
‎2010 Mar 29 8:50 AM
0 Kudos

In case you are sure that the warnings may be ignored, you may switch them off.

That also has been explained again and again. A search should bring that up.

A hint: Transaction DB17

Ask a Question