Oracle Database 11gR2 Performance Tuning Cookbook: Over 80 Recipes to Help Beginners Achieve Better Performance from Oracle Database Applications
In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is keen to dig into the causes of performance issues, or a developer who wants to learn why and where the application is running slow, this is the book for you. Basic knowledge of SQL language is required and general knowledge of the Oracle Database architecture is preferable.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
ANALYZE application asynchronous I/O avoid baseline bind variables bitmap index Buffer Cache checkpoint cluster column CONNECT sh@TESTDB/sh COUNTRY_ID CREATE TABLE cursor CUST_FIRST_NAME CUST_ID CUST_LAST_NAME CUST_YEAR_OF_BIRTH CUSTOMERS table data dictionary database blocks default denormalization disk dynamic performance view example EXEC execution plan following screenshot following steps full table scan function Getting ready hash histograms Howit Howitworks INSERT inthe inthis l_stmt latch Library Cache load lock log file LOOP materialized view memory MY_CUSTOMERS MY_SALES NUMBER NOT NULL obtain ofthe OLTP optimizer Oracle database Oracle Enterprise Manager package parameter parsing partitioning performance tuning PL/SQL procedure/Procedures Program Global Area RAID level redo log relevant view fields result cache rows S.CUST_ID script segment SELECT server session SH schema sh.CUSTOMERS sh.MY_CUSTOMERS sh.SALES shared pool snapshots SQL statement SQL*Plus statistics steps will demonstrate stored outlines stored procedure SYSDBA TABLE_NAME tablespace temporary tablespace thedatabase thefollowing There's There'smore todoit tothe trigger UPDATE wecan wehave