|
|
|
Forum Member
 
Group: Forum Members
Last Login: 2/24/2009 5:53:12 AM
Posts: 31,
Visits: 169
|
|
Hi
Our big batch have been automatically scheduled to run everyday from 5pm.
Mostly it runs fine during the week,but runs long over the weekend.
We do our weekly back ups on weekend, and release all the held jobs to run after completing the back ups,
but the biggest problem is that it runs for almost 14hours until we kill it.
Normally it runs for 30 minutes.
Please advice
Ince Chauke
Jnr BI System Analyst
Data Warehouse Department
Knowledge Leads The World.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/12/2008 4:18:58 AM
Posts: 2,
Visits: 13
|
|
It might be taking so long because certain tables are locked by other process's maybe the back up or some other process. You may want to release locks on the IOS database and try again. and make sure the Big Batch runs alone and all the back ups and other process completed successfully and released all the locks.
Regards,
Abdul
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/9/2009 5:16:57 AM
Posts: 3,
Visits: 22
|
|
Hi,
While executing check the PMON,I presume it is getting blocke by some other user query,make sure that nop user is running some complex queries,so automatically the CPU utilization may fall down.
Cheers,
Suneel Veluru
|
|
|
|