Oracle SQL Tuning Pocket Reference

3,38 valoración promedio
( 21 valoraciones por Goodreads )
 
9780596002688: Oracle SQL Tuning Pocket Reference

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.

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. Mark 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, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark 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.

"Sinopsis" puede pertenecer a otra edición de este libro.

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.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Gurry, Mark
Editorial: O'Reilly Media (2017)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: > 20
Impresión bajo demanda
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2017. Paperback. Estado de conservación: New. Never used! This item is printed on demand. Nº de ref. de la librería 0596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 5,34
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,70
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Mark Gurry
Editorial: O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2002. Paperback. Estado de conservación: New. Language: English . Brand New Book. 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. Nº de ref. de la librería AAH9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 7,04
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Mark Gurry
Editorial: O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2002. Paperback. Estado de conservación: New. Language: English . Brand New Book. 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. Nº de ref. de la librería AAH9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 7,08
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Gurry, Mark
Editorial: O'Reilly Media 1/11/2002 (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback or Softback Cantidad: 10
Librería
BargainBookStores
(Grand Rapids, MI, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media 1/11/2002, 2002. Paperback or Softback. Estado de conservación: New. Oracle SQL Tuning Pocket Reference. Book. Nº de ref. de la librería BBS-9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 7,59
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Mark Gurry
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Cantidad: 5
Librería
ReadWhiz
(Portland, OR, Estados Unidos de America)
Valoración
[?]

Descripción Estado de conservación: New. Nº de ref. de la librería ria9780596002688_ing

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 9,18
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Gurry, Mark
Editorial: O'Reilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 0596002688 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería SWATI2132574549

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 5,83
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Gurry, Mark
Editorial: O'Reilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos PAPERBACK Cantidad: 10
Librería
Lakeside Books
(Benton Harbor, MI, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 0596002688 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|0.5. Nº de ref. de la librería OTF-Y-9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 6,19
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Mark Gurry
Editorial: O'Reilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: > 20
Librería
BuySomeBooks
(Las Vegas, NV, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. Paperback. Estado de conservación: New. Paperback. 112 pages. Dimensions: 6.8in. x 4.2in. x 0.3in.One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracles SQL statement optimizers. Marks 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. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problemsolution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMSSTATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you cant otherwise modify. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Nº de ref. de la librería 9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 11,06
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Mark Gurry
Editorial: OReilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 3
Librería
THE SAINT BOOKSTORE
(Southport, Reino Unido)
Valoración
[?]

Descripción OReilly Media. Paperback. Estado de conservación: New. New copy - Usually dispatched within 2 working days. Nº de ref. de la librería B9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 3,87
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 7,81
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Gurry, Mark
Editorial: O'Reilly Media (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 10
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2002. Paperback. Estado de conservación: New. Nº de ref. de la librería INGM9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 8,82
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 4,25
A Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda