on 06-30-2011 9:10 AM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.