DBA Tip of the Month

You are invited to join and participate in the "DBA Pipeline" - a free internet community for Oracle DBAs hosted by author Mike Ault, and sponsored by RevealNet.
You will find tips, techniques, white papers and an excellent discussion group ("Pipe Talk" available for your use. This service is completely free, and you will have unrestricted access to the site: http://www.revealnet.com/dbapipe/index.htm

DECEMBER'S TIP OF THE MONTH: On a recent project we had a problem where performance would start acceptable at the beginning of the day and by mid-day would be totally unacceptable.

(the description of the problem is lengthy, please visit the pipeline...)

It was determined that an automatic procedure was needed to monitor the shared pool and flush it when it reached 60-70% of capacity. The following procedure was created:

(please visit the pipeline for the code supplied to solve the problem...)

December's Tip of the Month is fairly lengthy, but very good. Please visit the DBA Pipeline for full information. The DBA Pipeline is a dedicated
resource for Oracle DBAs. We strongly encourage active participation, and the sharing of ideas between DBAs around the world.

Season's Greetings

Cam White
RevealNet, Inc. Received on Mon Dec 15 1997 - 00:00:00 CST