Skip to Content
author's profile photo Former Member
Former Member

Oracle: Warning BRCONNECT Check database

Estimated

I have these problems running TCODE DB13 "Check database"

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

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 13 files on disk 3) 82462720 KB (> 26660972 KB)

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

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14251008 (>< 4096,512 KB)

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

Please can you help me.

Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2012 at 02:24 PM

    A frequently asked question.

    Please search SDN!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 07, 2012 at 03:10 PM

    hi,

    you need to maintain your oracle paramteter (initSID.ora). please check these notes:

    838725

    1171650

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.