The following tuning issues are based on real-life experiences. The solutions to them cannot be found in this chapter or on the Internet, but require real-life tuning experience to resolve them. A database administrator who is trained to think laterally is likely to be able to come up the solutions to them very quickly, after eliminating the obvious non issues.
Describe the approach an administrator should take to resolve this real life Oracle 11.2.0.2 tuning issue. At 1 a.m. a batch job starts running to load new images into a multimedia warehouse. The batch job takes about five hours to run. Every night at 3 a.m. the batch slows to a crawl or stops altogether even though there is nothing else running on the server.
Note: It's likely only an experienced database administrator can resolve this.
An organization has two servers with identical configuration (memory, disk, and CPU) and Oracle database version 11.2.0.2 databases on them. At 3 p.m. an identical job is run on both to process...