DBA.SQR

Prints a report about cache performance, memory allocation, disk I/O usage, rollback segment and latch contention, and open cursors. Since I'm not a full-fledged DBA, I am not sure how accurate all of the selects are. I would appreciate feed-back from the DBA's out there. Needs to be run in "system/manager".

History:

The 98/6/21 version added a report of SQL statements in the SGA which run longer than a given amount of time.

Contributed by Chanan Morrison, chananm@netvision.net.il.

Download DBA.SQR.

Send comments and questions to the SQRUG Librarian.

Go to SQR Users Group Home Page.

File last modified 12-OCT-1998.