Check DB taking log time

[Former Member]

Hi All ,

We have an issue in BI system . We have schduled checkDB running everday at 5am .Below is detail of database

Total Number 10

Total Size/KB 4.976.109.632

Total Free/KB 164.409.408 3 %

Minimum Free/KB 84.800

Max. Autoextensible/KB Unlimited

Tables Indexe

Total Number 70.249 52.680

Total Size/KB 3.580.046.592 444.614.784

More than 1 Extent 25.944 8.745

Missing from Database 1 277

Missing in ABAP DDIC 11 120

Space-critical objects 0 0

Please suggest us what action need to be taken to resolve the issue

Thanks and Regards

Brijesh Prasad

[markus_doehr2]

> We have an issue in BI system . We have schduled checkDB running everday at 5am .Below is detail of database

4 TB is a HUGE database, I'm not really sure whether it's a good idea to verify the full database every day and if it's possible to speed it up.

If you back up your database using RMAN the DBV is done implicitly so you don't have to run it again.

Check

Note 540463 - FAQ: Consistency Checks + Block Corruptions

Markus

[Former Member]

Hi

Databse is Oracle release 10.2.0.4.0. Below is the details for a month. It took more the 7-8 hrs and we need to cancelled the job

every day .

DBA:CHECKDB_________@050000/1007 HLINSKEN Canceled 27.06.2011 05:00:18 19.991 18

DBA:CHECKDB_________@050000/2007 HLINSKEN Canceled 21.06.2011 05:00:04 1.825 4

DBA:CHECKDB_________@050000/2007 HLINSKEN Canceled 28.06.2011 05:00:05 16.583 5

DBA:CHECKDB_________@050000/3007 HLINSKEN Canceled 22.06.2011 05:00:06 920 6

DBA:CHECKDB_________@050000/3007 HLINSKEN Canceled 29.06.2011 05:00:22 11.776 22

DBA:CHECKDB_________@050000/4007 HLINSKEN Canceled 23.06.2011 05:00:09 1.795 9

DBA:CHECKDB_________@050000/4007 HLINSKEN Canceled 30.06.2011 05:00:01 16.346 1

DBA:CHECKDB_________@050000/5007 HLINSKEN Canceled 24.06.2011 05:00:11 5.175 11

DBA:CHECKDB_________@050000/5007 HLINSKEN Canceled 01.07.2011 05:00:04 13.673 4

Thanks and Regards

Brijesh Prasad

[Former Member]

Dear All ,

Please help me in the issue , still i have not received any answer for the issue

[boobboo]

Ok, so your CheckDB is running for more than 8hrs on a 4TB Oracle Database.

A couple more questions,

1. Why are you cancelling the jobs?

2. Did you increase the tracelevel and look in the logs

3. Can you post the output logs from the CheckDB, which you will find in either DB13 or DB14

4. Are your statistics up to date on the system

5. What SAP Notes have you looked at in resolving this

Thanks

Chris

[Former Member]

Hi Chirs

1. Why are you cancelling the jobs?

Ans : Becuase the job is for longer period and it affecting the performance. This also impacting the other jobs extraction and slow the background job

2. Did you increase the tracelevel and look in the logs

Ans : No

3. Can you post the output logs from the CheckDB, which you will find in either DB13 or DB14

4. Are your statistics up to date on the system

Ans : Yes

5. What SAP Notes have you looked at in resolving this

Ans: Still no Note has been applied , because no note got me to resolve the issue.

Regards

Brijesh Prasad

[Former Member]

2. Did you increase the tracelevel and look in the logs
Ans : No

So you want us to guess ?

My crystal ball is under repair currently, so I can't help.

Please help us to help you!

[Former Member]

Hi atleast paste the job logs for the cancelled job.

[boobboo]

Brijesh,

A few questions

When you say it is taking a long time, what do you mean by a long time, is it hours, days ?

Also what is your platform, is it Oracle? As that will determine the troubleshooting methods

Have you tried running your checkDB from the command line or increasing the logging so determine where the process gets stuck.

Can you pinpoint when it started to take a long time to do the checks, for example 20 days ago the time taken to check the database went from 30mins to over 5 hours

Not to worry you, but when I have seen database checks taking a long time, there can be corruption in the database somewhere.

Thanks

Chris