Pro Oracle 10g Performance Tuning - Paik, Soumendra
41,99 €
inkl. MwSt.
Versandkostenfrei*
Versandfertig in über 4 Wochen
  • Broschiertes Buch

Many existing Oracle installations perform well below expectations, and this costs companies both time and money. As a senior member of the Oracle Support team, the author is exposed to this sort of difficulty daily and sees the same problem arising time and again. This book will allow DBAs and developers to tackle these problems in a quick and effective manner. It will show the reader how to use the Oracle tools to identify and analyze a performance bottleneck, isolate the root cause, apply different possible resolutions and then quantify performance improvements. It is a practical field…mehr

Andere Kunden interessierten sich auch für
Produktbeschreibung
Many existing Oracle installations perform well below expectations, and this costs companies both time and money. As a senior member of the Oracle Support team, the author is exposed to this sort of difficulty daily and sees the same problem arising time and again. This book will allow DBAs and developers to tackle these problems in a quick and effective manner. It will show the reader how to use the Oracle tools to identify and analyze a performance bottleneck, isolate the root cause, apply different possible resolutions and then quantify performance improvements. It is a practical field guide for the diagnosis and resolution of common day-to-day problems such as poorly performing SQL queries, database hang, session hang, the sudden slow performance of a Production database, and so on. TOC:Introduction to SQL query performance tuning.- Execution plan.- Optimizer modes.- Statistics and histograms.- New statistics and query performance problem.- Indexing options and reorganization.- SQL statement sharing and caching.- Stored procedure recompilation.- Query design.- SQL Tracing and identifying sub-optimal SQL queries.- Query tuning methodology.- Oracle internal errors and query tuning.- Diagnose and resolve hot block problem.- Diagnose and resolve deadlock problem.- Database upgrade and performance problem.- Diagnosing a hung database.- Diagnosing sudden slow performance in the database.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Autorenporträt
Soumendra joined Oracle Support Services 5 years ago as Senior Technical Analyst and is currently working there as Principal Support Engineer. He has been working with Oracle since version 6, and was one of the core developers on Oracle Developer Tools team (Forms, Reports, Pro* etc). He is also an Oracle-certified DBA and has extensive expertise in query tuning, database tuning and troubleshooting techniques.