Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

Quantity:

More Buying Choices

32 used & new from �14.42

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series) (Paperback)

by Richard Niemiec (Author)

1.0 out of 5 stars See all reviews (1 customer review)

RRP:	�37.99
Price:	�22.79 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�15.20 (40%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Thursday, July 16? Choose Express delivery at checkout. See Details

25 new from �22.48 7 used from �14.42

This book is part of our Up to 50% off 1000s of Paperbacks promotion.

Frequently Bought Together

Oracle Database 10g DBA Handbook (Osborne Oracle Press Series)

Price For All Three: �76.53

Show availability and shipping details

This item: Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series) by Richard Niemiec
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle Database 10g RMAN Backup & Recovery (Osborne Oracle Press Series) by Matthew Hart
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle Database 10g DBA Handbook (Osborne Oracle Press Series) by Kevin Loney
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Oracle Database 10g RMAN Backup & Recovery (Osborne Oracle Press Series)

by Matthew Hart

�29.74

Oracle Database 10g DBA Handbook (Osborne Oracle Press Series)

by Kevin Loney

1.0 out of 5 stars (1) �24.00

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series)

by Richmond Shee

5.0 out of 5 stars (1) �17.99

Oracle Database 10g High Availability with RAC, Flashback & Data Guard: With RAC, Flashback and Data Guard (Osborne Oracle Press Series)

by Matthew Hart

5.0 out of 5 stars (2) �30.49

Oracle Database 10g The Complete Reference (Osborne Oracle Press Series)

by Kevin Loney

�25.14

› Explore similar items

Product details

Paperback: 967 pages
Publisher: McGraw-Hill Osborne; illustrated edition edition (1 Aug 2007)
Language English
ISBN-10: 0072263059
ISBN-13: 978-0072263053
Product Dimensions: 23.1 x 18.8 x 5.1 cm

Average Customer Review: 1.0 out of 5 stars See all reviews (1 customer review)

Amazon.co.uk Sales Rank: 28,816 in Books (See Bestsellers in Books)

Popular in these categories:

#7 in	Books > Computing & Internet > Databases > Oracle
#31 in	Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
#33 in	Books > Computing & Internet > Databases > Applications

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Oracle Consultancy

www.teamsolve.co.uk/Consultancy Expert Oracle Consultancy Services, Optimise Your Oracle, Call Today

Bad SQL performance?

www.active-base.com No need to be an Oracle expert to optimize your SQL statements

10g performance tuning

www.OSSCube.com Achieve 2x to 10x increase without Hardware Upgrade. 100% gurantee!

Product Description

Product Description

Exclusively from Oracle Press

The definitive guide to Oracle performance tuning has been fully expanded to cover every aspect of Oracle Database 10g. This comprehensive resource contains everything database administrators and developers need to know to keep Oracle Database 10g performing at its peak. Real-world case studies and in-depth examples illustrate best practices and highlight the latest tuning options.

From the Back Cover

Maintain a High-Performance Oracle Database 10g Environment

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

"Rich does it again with a book that teaches to multiple levels in a bold and inspiring way." --Ari Kaplan, President, Independent Oracle Users Group

"There is no doubt about Rich's grasp on Oracle tuning and the way he simplifies intricate details in it." --Muhammad Shuja Uddin, Vice President and Head of Technical Support, Ora-Tech Systems; President, Pakistan Oracle Users Group

"Rich Niemiec is THE expert on Oracle tuning. This book is a ‘must have' for every Oracle DBA's bookshelf--there is something for everyone to learn. It is an excellent reference that proves useful over and over again." --Kimberly Floss, Manager, Database Services, PepsiCo; Former President, Independent Oracle Users Group

"Any book with Rich Niemiec as the author is a ‘must buy.' The man knows Oracle inside and out." --Karen Brownfield, Board of Directors, Oracle Applications Users Group

See all Product Description

Inside This Book (Learn More)

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

oracle tuning

tuning

oracle

oracle performance tuning

database management systems

aerobooks

What Do Customers Ultimately Buy After Viewing This Item?

	73% buy the item featured on this page: Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series) 1.0 out of 5 stars (1) �22.79
	12% buy Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series) 5.0 out of 5 stars (1) �17.99
	6% buy Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) 5.0 out of 5 stars (10) �37.52
	5% buy Troubleshooting Oracle Performance, Hardback 5.0 out of 5 stars (1) �45.12

Explore similar items

Customer Reviews

1 Review

5 star:		(0)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(1)

Average Customer Review

1.0 out of 5 stars (1 customer review)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

24 of 26 people found the following review helpful:

1.0 out of 5 stars Try before you buy, 28 Sep 2007

By	J. P. Lewis (London, England, UK) - See all my reviews (REAL NAME)

Download chapter 14 ("Using Statspack and the AWR report to tune waits and latches") from McGraw-Hill before you buy the book. The last line reads: "Rich Niemiec upgraded this chapter from 9i to 10g (painful!)", so it seems reasonable to use this chapter to evaluate the book. Here are some examples of the issues I have with this chapter:

For the "Log Buffer Space" wait, we are told: "When a change is made, the changed block is copied to the log buffer" Wrong. A typical redo record contains the smallest possible description of the changes made to the targeted block and associated undo block - and even that's not an accurate statement in 10gR2, which introduced "private redo threads" (and related statistics) for small transactions.

Under "Enqueue" we see the statement: "while you no longer get TM locks, which are table locks when you don't index foreign keys, be sure to still index them to avoid a performance issue." Even in 10g you still get TM/4 (or 5) locks on child tables if you update or delete parent keys and haven't indexed the foreign key columns; but a change made in 9i means the locks get released, or down-converted, sooner. (So the indexing decision is application dependent.)

We are told that "Buffer Busy Waits" may be waits for a buffer that is `being read into the buffer cache' - but that event was renamed "read by other session" in 10g.

We are told that dbms_scheduler runs job gather_stats_job to take an AWR snapshot - but the AWR collection is controlled by the mmon background process; gather_stats_job handles database statistics.

There are sundry discussions of internal mechanisms that are simply wrong. For example the following definition appears for short tables "fewer than 5 blocks for v7, fewer than 20 blocks for 8i, and 2% of the buffer cache for 9i and 10g" (and repeated for long tables). Apart from a couple of special cases for small caches the limit has been related to 2% of the buffer cache since at least Oracle 7.

A comment following an example of the "Load Profile" says: "a soft parse rate greater than 300/second could indicate program inefficiencies". But why 300; and does that limit change if we have 1,000 live sessions, or 5,000 live sessions? And where is the comment that should be there to tell us to cross-check with the instance statistics because the "soft parse" is virtually irrelevant if nearly all the parse calls were pre-empted by the session cursor cache. One number that "could" indicate a problem does not help people decide if they need to take action.

There are two "Top 5" examples (one from 9i the other from 8i) but neither gives any indication of the snapshot duration, number of CPUs, or number of sessions. When the author says that after one day's tuning of the 9i database "well over five terabytes of reads were eliminated in a 24 hour period" it certainly sounds good; but we have no idea of the difference that made to the users or the system. With no idea of scope the commentary is pretty meaningless.

Switching to the subjective viewpoint, I was surprised by some of the omissions. You always need to cross-check and counter-balance various parts of the Statspack/AWR report, and some of the new details are an enormous benefit in this task. Some examples:

In that 9i "Top 5" section, the author states that part of the problem was "slow disk access"; but the average read time was 6.41 milliseconds, which isn't usually considered slow. If the example had come from 10g we could have had a demonstration at this point of how the reports of v$event_histogram and v$file_histogram can expand the average time into more useful information, perhaps showing wide variations in read times; but these important new tools have been given no more than a cursory reference later in the chapter.

The author also failed to point out that excess I/O can lead to high CPU usage and large numbers of buffer busy waits (both visible in the snapshot), which may allow you to discount the immediate significance of those two sets of figures. Nor did the author mention the "log file switch (checkpoint incomplete)" figures, which record relatively little time but could actually be much more visible to users than the high volume I/O, and therefore be a more urgent problem (possibly fixable in just a few minutes).

Revisiting "Buffer Busy Waits": we are told to check the buffer waits section (or v$waitstat) when we see buffer busy waits; but wouldn't this be a good point to cross-reference to the segment statistics (v$segstat) section of the report, which again merits only a cursory description and screen shot.

There are several comments about the system statistics "sorts (rows)", "sorts(disk)" and "sorts(memory)". But where is the information about the extremely useful "workarea executions" statistics that appeared in 9i to tell us about other heavy duty operations such as hash joins and bitmap merges, and gave us a way of splitting disc operations into "onepass", and "multipass"? Where is the discussion of how to interpret the "PGA Aggr Target Histogram" section of the report that appeared in 9i to tell you about the size of data and amount of disc activity due to these operations? That section of the report deserves far more than the one line saying: "The AWR shows statistics on ...".

Maybe Rich Niemiec ran out of space but, with focused editing, low value material (such as an arbitrary list of bugs that had been fixed by 10g) could have been replaced with some of the very useful stuff that appeared in 9i and 10g.

In summary - there are a number of observations in this chapter which are highly arguable, inadequately analysed, or simply wrong and it contains little to mark it out as having any real added value for a 10g DBA. It does not encourage me to buy the book.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jsOnDisplayBlock { display: none; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; }

Customer Discussions

Beta (What's this?)

This product's forum (0 discussions)

	Discussion	Replies	Latest Post
	No discussions yet

Ask questions, Share opinions, Gain insight

Start a new discussion

Topic:

First post:

Prompts for sign-in

[Cancel]

Guidelines

Listmania!

Software Development Essentials: A list by Jose Almeida
I got oracle master.: A list by mysteries of the Computer
Ultimate Java Books: A list by Mr. K. Stephens

Create a Listmania! list

Look for similar items by category

Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
Books > Computing & Internet > Databases > Oracle
Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon

Feedback

Would you like to update product info or give feedback on images?
I am the Author, and I want to comment on my book.
I am the Publisher, and I want to comment on this book.

Health & Beauty at Amazon.co.uk

From soap to shavers, massagers to mascara, stock up on your daily essentials or truly pamper yourself.

›Discover Health & Beauty

More From Rich Niemiec

Oracle9i Performance Tuning Tips...

Get Undocumented, Insider Advice Maintain a high-performance Oracle9i... Read more
£44.00 £37.40

Up to 53% off Braun Series Shavers

Braun Series 3 390cc Clean & Renew System Rechargeable Foil Electric Shaver

Get in touch with your smooth side with Braun Series shavers, now with Gillette blade technology.

›Discover Braun Series at Amazon.co.uk

Treat Someone

With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

Where's My Stuff?

track your recent orders
view or change your orders in Your Account

Delivery and Returns

see our delivery rates and policies
thinking of returning an item? (See our Returns Policy)

Need Help?

Forgot your password?
Buy Gift Certificates.
still have questions? Visit our Help Pages

Your Recent History

(What's this?)

You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

The Girl Who Played with Fire by Stieg Larsson

4.5 out of 5 stars (76)�3.86

Breaking Dawn (Twilight Saga) by Stephenie Meyer

4.1 out of 5 stars (464)�6.49

The Girl with the Dragon Tattoo by Stieg Larsson

4.1 out of 5 stars (166)�3.99

The Host by Stephenie Meyer

4.2 out of 5 stars (87)�3.86


Amazon Home

International Sites: United States \| Germany \| France \| Japan \| Canada \| China

Business Programs: Sell on Amazon \| Fulfilment by Amazon \| Join Associates \| Join Advantage

Customer Service \| Help \| View Basket \| Your Account

About Amazon.co.uk \| Careers at Amazon


Amazon Home

International Sites: United States \| Germany \| France \| Japan \| Canada \| China

Business Programs: Sell on Amazon \| Fulfilment by Amazon \| Join Associates \| Join Advantage

Customer Service \| Help \| View Basket \| Your Account

About Amazon.co.uk \| Careers at Amazon