This book is designed to enhance the skills of the Oracle DBA by giving them knowledge and examples on how to improve their system's performance. Readers will learn how to: understand how to use trace files, the alert log file and event sets to assist with tuning; become familiar with the new features of Oracle9i.; understand and be able to use utilities and dynamic performance views to assist with tuning; understand how to tune applications using index structures and how to perform SQL statement tuning.; tune SQL Statements Efficiently; read Alert Logs and Trace Files; tune the Shared Pool; tune the Buffer Cache; use Multiple Buffer Caches; tune a Multi-Threaded Server; configure and tune the storage subsystem that Oracle is using, and use Oracle in a SAN environment.
- ISBN10 0672321467
- ISBN13 9780672321467
- Publish Date 24 April 2002
- Publish Status Out of Print
- Out of Print 20 July 2011
- Publish Country US
- Publisher Pearson Education (US)
- Imprint Addison-Wesley Educational Publishers Inc
- Format Paperback
- Pages 432
- Language English