O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exercises

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.

  1. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required