- Paperback: 112 pages
- Publisher: O'Reilly Media; 1st edition (January 11, 2002)
- Language: English
- ISBN-10: 0596002688
- ISBN-13: 978-0596002688
- Product Dimensions: 4.2 x 0.4 x 7 inches
- Shipping Weight: 3.5 ounces (View shipping rates and policies)
- Average Customer Review: 6 customer reviews
- Amazon Best Sellers Rank: #1,579,162 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Oracle SQL Tuning Pocket Reference 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
Customers who viewed this item also viewed
About the Author
As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia, the largest computer site in Australia and one of the largest in the world. He has also spoken on tuning at Oracle user group meetings and has given internal tuning courses at several of his larger client sites. He has been a senior team member on award-winning systems that have been developed using Oracle.
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $0.99 (Save 84%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
Try the Kindle edition and experience these great reading features:
Showing 1-6 of 6 reviews
There was a problem filtering reviews right now. Please try again later.
As to the rest, there are 22 pages (out of merely 102) enumerating the many hints one can apply to SQL. There's not much here that isn't already available from Oracle documentation directly.
* Clear clarification on which optimizer (cost-based and rule- based) is used for a specific situation and its problems.
* Sorts, indexes, IN/EXISTS, OR/UNION, Loop, joins with tables...etc related performance issues and rating , giving a reader a reminder on the criteria to write a well-performed SQL.
* What is bad SQL?How to use SQL Hints?
* How to analyze table with DBMS_STATS package?
* How to pre-define outline for your execution plan ?
I have bought DBA checklist and Oracle with UNIX, they are my nice partners as well. Haha...I still remember I deal with a staging database problem in my work, I cannot find a solution from a THICK and HEAVY book but from them.
If you need handy guides, pocket references are excellent and light, haha...I want to buy RMAN reference later :D, they seem a series of fiction.
It is well written, up to date (includes 9i info), and full of examples and real world experiences. All packed into 100 little pages!
Many of the Oracle books I've purchased (especially the tuning references) are just sitting on the shelf collecting dust. They're too big, and filled with a lot of 'dead weight'. I've already read this pocket reference twice (it's suprising how much more of it 'sticks' the second time around) and gathered more useful knowledge than all my other sql tuning books combined.
I know this is called a pocket reference simply because of it's size, but it's really more of an instructional manual than just a reference.
Every Oracle developer and DBA should read this book ...at least twice.