DBA ValidStruct IS TAKING VERY LONG TIME

[Former Member]

HELLO,

THE PROBLEM IS THAT THE BACKGROUND JOBS SCHEDULEDFROM DB13

DBA:ValidStruct

DBA:UpdateStats

ARE TAKING A VERY LONG TIME TO COMPLETE.

DBA:ValidStruct IS TAKING 2 DAYS PLUS (IT IS A WEEKLY JOB, RUNS ONLY ON SAYURDAYS')

DBA:UpdateStats IS A DAILY JOB (IT RUNS OKEY EVERYDAY BUT ON SATURDAYS IT TOO TAKES 1 PLUS DAYS)

THIS IS MAKING IT HARD TO WORK ON SATURDAY.

MOREOVER THERE IS AN ADDITION ON 4 GB DATA IN THE SYSTEM.

FOLLOWING IS THE PIECE OF LOG

"""""

BR0280I BRCONNECT time stamp: 2006-10-14 07.12.37

BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT thread 3: time stamp: 2006-10-16 01.55.47

"""""

COULD YOU PLEASE HELP.

[Former Member]

******log entry

BR0280I BRCONNECT time stamp: 2006-10-14 07.12.37

BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT thread 3: time stamp: 2006-10-16 01.55.47

*******log entry

I agree that return code 0 stands for successful execution but the time gap between

Thread 2 finished &

thread 3

is more than a day.

Moreover the job is started on Saturdays when the system load is the minimum. No backups run during the same day.

DB is of 200 GB.

Oracle Patch is 9.2.0.6

I will be trying to go for parallel processing this weekend ' -p ' option. Lets see if it works. Any other idea will be appreciated.

[Former Member]

Hello Abhishek,

Check if backup is active during the same time.

Check if there are any long running jobs that put load on the system during the same time.

Cross-check for any 'changes' executed on the system that has resulted in slow execution of mentioned task.

NB: Please avoid using CAPS.

Regards,

Ammey Kesarkar

[JPReyes]

Hi Abhishek,

About the piece of the log that you quoted

<b>"BR0848I Thread 2 finished with return code 0 "</b>

0 means it finished successfully, this may be a performance problem related to hardware, have you check what is the CPU, Memory, Disk Utilization during the time the job is running?, What is the size of your DB?, when the problem started?, is the DB software up to date?

Hope this help!

Juan

Please reward with points if helpful

[Former Member]

Please do not use CAPS LOCK, thanks.