Oracle SQL Tuning Pocket Reference und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
  • Alle Preisangaben inkl. MwSt.
Nur noch 1 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
Oracle SQL Tuning Pocket ... ist in Ihrem Einkaufwagen hinzugefügt worden
+ EUR 3,00 Versandkosten
Gebraucht: Gut | Details
Verkauft von britbooksde
Zustand: Gebraucht: Gut
Kommentar: Einfach Brit: Wir haben von unserem England Lager Bücher von guter Zustand auf über 1 Million zufriedene Kunden weltweit versandt. Wir sind bemüht, Ihnen mit einem zuverlässigen und effizienten Service zu allen Zeiten begangen.
Ihren Artikel jetzt
eintauschen und
EUR 0,10 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Dieses Bild anzeigen

Oracle SQL Tuning Pocket Reference (Englisch) Taschenbuch – 5. Dezember 2001


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 9,40
EUR 5,90 EUR 2,07
12 neu ab EUR 5,90 10 gebraucht ab EUR 2,07
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation

  • Taschenbuch: 112 Seiten
  • Verlag: O'Reilly & Associates; Auflage: Poc (5. Dezember 2001)
  • Sprache: Englisch
  • ISBN-10: 0596002688
  • ISBN-13: 978-0596002688
  • Größe und/oder Gewicht: 10,8 x 1 x 17,8 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 380.476 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Synopsis

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..

Über den Autor und weitere Mitwirkende

Mark Gurry is owner and President of Mark Gurry & Associates, a 50 person consulting company that provides end-to-end IT services, including 24 x 7 database administration, Web, GUI and back-end development, advice on architecture, business analysis, and design. The Company's performance skills are known worldwide. Mark's and his consultants' short-term site audits, tuning expertise, and internal skills transfer are keenly sought after, and Mark Gurry & Associates is often classified as being the Company to seek out when "only the absolute best will do". Mark Gurry & Associates is headquartered in Australia, and has recently expanded to Seattle in the United States. The Company also has several clients in the UK, New Zealand, and in Asia. Mark's customers are in many areas, including electricity; legal; the stock market; banking and finance; telecommunications; emergency services; and local, state, and federal governments.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Rückseite
Hier reinlesen und suchen:

Kundenrezensionen

5.0 von 5 Sternen
5 Sterne
1
4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
Siehe die Kundenrezension
Sagen Sie Ihre Meinung zu diesem Artikel

Die hilfreichsten Kundenrezensionen

5 von 6 Kunden fanden die folgende Rezension hilfreich Von Gregor Theis am 6. Februar 2002
Format: Taschenbuch Verifizierter Kauf
I just bought this pocket reference because I did not want to wait for the new O'Reilley ORACLE Performance Tuning book (scheduled for March 2002).
I like this book very much because it is a short reminder of all the things that I read in several other books and forgot.
This book already saved one of my customers more than 2 hours of processing time and about 4GB of TEMP tablespace because I applied an tip from this book. I found the encouragement to use the cost based optimizer very good and this optimizer saved me in this situation together with some INIT.ORA settings that were also mentioned in the booklet.
This book already contains references to the new ORACLE 9i features that I am currently reading about.
I especially like the common problems sections in this book. If you are really working in the area of ORACLE performance tuning I think that you should buy this book and take it with you.
Kommentar War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback. Wenn diese Rezension unangemessen ist, informieren Sie uns bitte darüber.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 6 Rezensionen
10 von 10 Kunden fanden die folgende Rezension hilfreich
Essential guide for tuning Oracle SQL 22. Mai 2003
Von Jeff Price - Veröffentlicht auf Amazon.com
Format: Taschenbuch
This is the best book I've seen for tuning Oracle SQL.
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.
5 von 5 Kunden fanden die folgende Rezension hilfreich
Largely obsolete now (2009) 10. September 2009
Von N. Lee - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I didn't notice that this pocket reference was still in its first printing, from January of 2002. As such most of the content is now obsolete. Specifically the author devotes a lot of space to comparing the Rule-Based and Cost-Based Optimizers, and points out the clear superiority of the latter. This was big news when Oracle 9i was about to be released, not so much now.

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.
4 von 4 Kunden fanden die folgende Rezension hilfreich
Practical Oracle database tuning guide that provides best overall return 26. Mai 2007
Von Erik Gfesser - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Purchased a few years ago, this little guide has provided the best return on investment when compared to more bulky works on the subject of Oracle database tuning. The word "reference" was probably chosen over the word "guide" in the title of this book because the former would seem to imply usage solely for quick lookups on various related subjects. However, this work is really a step-by-step primer that can be used alongside online Oracle database reference manuals. Because this book is so short, it can be digested in a matter of hours. During such a short time period, the reader is exposed to topics ranging from Oracle rules-based and cost-based optimization to database statistics gathering and SQL hints. And all this information is presented in a practical manner that includes many examples that will help the reader start off on the right path.
Well written and to the point 6. Juli 2007
Von J. MCADAMS - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I typically like these little pocket reference books from O'Reilly and this one is no exception. However, this is more than just a reference, it's a nice primer on Oracle SQL tuning. It's a pretty safe bet that you'll get your $10 worth out of this book pretty quickly.
11 von 19 Kunden fanden die folgende Rezension hilfreich
Worths to own one! 28. Dezember 2001
Von Anthony Lai Cheuk Tung - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Yesterday, I saw this pocket book, then I decide to buy it because...
* 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.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.