Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EM Job Slow

661846Oct 2 2008 — edited Oct 4 2008

Hai to all,

I have two database one database name is A and another one is B, in our database A having one job, every day tonight (1pm) few tables move to database B and after move the table’s, the table was deleted in database A, in early time (2 month before), this job took time 20 minutes and now more than 7 hours.

I have written below my database detail’s…
1) Oracle 10gR2
2) Red hat linux 3
3) all user managed tablespace is auto managed
4) While job running database A cpu goes to 100%
5) Last 6 months, No modification for parameter file
6) This job I have put on EM

Pls give me ur idea and where I want to check?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2008

Added on Oct 2 2008

#database-key-features, #job, #performance, #scheduler

4 comments

1,800 views