Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance

Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance
Автор
 
Год
 
Страниц
 
154
ISBN
 
0972751327
Издатель
 
Rampant Techpress
Категория
 
Oracle
Искать в интернет библиотекахКупить

Описание:

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and provides ways to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle database administrators, this guide focuses on proactive tuning and scripting and shows how to collect historical data and use it to develop signatures for all memory areas. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

Похожие книги

The Prisoner: The Original ScriptsThe Prisoner: The Original Scripts
Автор: Peter Fletcher
Год: 2005
Beginning AppleScriptBeginning AppleScript
Автор: Stephen G. Kochan
Год: 2003
Beginning AppleScriptBeginning AppleScript
Автор: Stephen G. Kochan
Год: 2004
Afrikan Alphabets: The Story of Writing in AfricaAfrikan Alphabets: The Story of Writing in Africa
Автор: Saki Mafundikwa
Год: 2006