# README.TXT This floppy contains a number of subdirectories, each corresponding to a chapter or appendix. The chapter subdirectories contain the SQL scripts extracted from the book; we hope that these will help you in tuning your site. The appg (Appendix G) subdirectory contains a listing of the dynamic performance tables for the system. Within each subdirectory there are individual files; the examples included in the book reference the filenames. There is also a subdirectory called mgextras, which contains a number of additional scripts that Mark Gurry uses when he tunes and audits sites. You may find them useful! A description of the mgextras scripts is included at the bottom of this readme. The following lists the subdirectories and their corresponding chapters: chap6 - SQL chap7 - PL/SQL chap8 - Locking chap9 - New database chap10 - Tools chap11 - Existing database chap12 - Parallel server chap13 - Parallel query chap14 - Backup and recovery chap15 - Long-running jobs chap16 - Client-server chap18 - System-specific appg - Dynamic performance tables mgextras - Mark Gurry's shell scripts: sesscpu.csh - A UNIX C shell script that is used on a machine when the database is at its absolute worst. It gathers CPU users and the SQL that they are running. sqlsnap.csh - A UNIX C shell script that is also used on a machine when the database is at its absolute worst. It gathers all SQL statements that are currently running and reports on their expected run time and efficiency. syswaits.csh - A UNIX C shell script that is also used on a machine when the database is at its absolute worst. It gathers all waits that are currently occurring in your database. It lists information such as the objects that the waits are occurring on. Mark Gurry's SQL scripts: bufcache.sql - Gives tuning information in the Oracle buffer cache. It is for those greedy people (like me) who want to know even more about the buffer cache performance and contents. bmark.sql - A large collection of scripts that I run initially when doing a performance audit. Contains many of the scripts from the book, stored in the chapter subdirectories. initparm.sql - Gives some basic tuning advice on key INIT.ORA parameters after observing your site's setup. nummrolb.sql - Provides information on how well your rollback segments are set up. rolbusrs.sql - Lists who is currently holding which rollbacks. sharpool.sql - Provides extensive tuning information on the shared pool. sqlarea.sql - Lists all statements that have a response time > n seconds. It also spools a file that can be used to get the execution path of each statement. sysseg.sql - Lists all segments owned in the system tablespace not owned by SYS or SYSTEM. systsp.sql - Shows how appropriately your system tablespace is set up.