Storage related problem can be generated from different reasons. The following is an interesting example.
Once a database performance has stalled without any change in hardware level and physical layout level. The detail analysis shows that, the application running on the database is mistakenly submitting huge number of jobs in oracle job queue table. The application’s problem
Here we will see in
details how we can define concurrent manager in oracle R12. As you
are aware a concurrent manager
itself is a concurrent program which runs other concurrent manager.
So, lets see how we can define this manager.