Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL tuning
"Access" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message
news:419271a3$0$21986$ba620e4c_at_news.skynet.be...
> Hello,
>
> I'm looking for some good resources (books, websites, courses, ...) on
> Oracle SQL tuning. I already have Mark Gurry's "Oracle SQL Tuning" pocket
> reference which I find very good.
>
> Note: i'm currently working with both Oracle 8i and 9i databases so it
would
> be ideal if both releases are covered (hints, CBO behaviour etc).
>
> Thanks,
> Matthias Hoys
>
>
OK thanks for all the suggestions.
What about this one : (I saw it in a local book store) :
Oracle High-Performance SQL Tuning (Donald K. Burleson)
Tune SQL Statements for Optimal Execution This resource explains how to take any SQL statement, view the internal execution plan, and change the execution plan to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and methods for tuning Oracle SQL statements. Understand how SQL tuning fits into the overall Oracle tuning model; Improve Oracle SQL functionality using extensions such as in-line views and BIFs; Identify and report on SQL in the library cache; Tune SQL table access, full-table scans, and parallel query; Run TKPROF to get a SQL trace report; Change the execution plans for Oracle SQL statements using Oracle hints; Use the Oracle8i optimizer plan stability, cost-based optimizer, and rule-based optimizer; Tune SQL DML statements, SQL subqueries, and data warehouse SQL; Tune SQL with temporary tables and indexes; Diagnose and optimize system performance using STATSPACK. Received on Thu Nov 11 2004 - 07:45:19 CST