Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming: 8

Valutazione media 4
( su 1 valutazioni fornite da GoodReads )
 
9780976157397: Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming: 8

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing techniques to achieve high performance. Ready-to-use tips for saving hardware costs by running applications at peak efficiencies are provided for senior Oracle DBAs and developers, and powerful PL/SQL techniques are outlined.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Contenuti:

Chapter 1 - Introducing PL/SQL

Introduction
What is PL/SQL and Why Should I use It?
PL/SQL Architecture
Overview of PL/SQL Elements
Blocks
Variables and Constants
Using SQL in PL/SQL
Branching and Conditional Control
Looping Statements
Goto
Procedures, Functions and Packages
Records
Object Types
Collections
Associative Arrays (Index-By Tables)
Nested Table Collections
Varrays
Collection Methods
Triggers
Error Handling
My Ideal Environment
Conclusion

Chapter 2 - Writing Efficient PL/SQL

Introduction
Bind Variables
Using Bind Variables
The cursor_sharing Parameter
Dynamic Binds using Contexts
SQL Injection
Bulk Binds
Using Rowids when Updating
Short-circuit Evaluations and Ordering Logic
Implicit vs. Explicit Cursors
Declarations, Blocks, Functions and Procedures in Loops
Duplication of Built-in String Functions
Minimize Datatype Conversions
The Trigger Compilation Myth
Efficient Function Calls
Using the NOCOPY Hint
Using PLS_INTEGER and BINARY_INTEGER Types
Using BINARY_FLOAT and BINARY_DOUBLE Types
Native Compilation of PL/SQL
Decoupling (cheating) for Performance
Conclusion

Chapter3 - Arrays and Bulk Binds

Introduction
Populating Collections Using Bulk Operations
Bulk collect
Bulk Collect from an Explicit Cursor
Chunking Bulk Collections Using the LIMIT Clause
Manually Limiting Bulk Collection Volumes
Bulk Collection of DML Results
FORALL
Bulk INSERT Operations
Bulk UPDATE Operations
Bulk DELETE Operations
Sparse Collections
Host Arrays in Bulk Operations
BULK_ROWCOUNT
Handling Exceptions in Bulk Operations
Unhandled Exceptions
Handled Exceptions
Bulk Operations that Complete
Dynamic SQL and Bulk Operations
Conclusion
Chapter 4 - Caching Session Data

Introduction
Using Arrays for Lookup Tables
Using Package Variables to Store Global Data
Using Contexts to Store Global Data
Conclusion

Chapter 5 - Memory Management

Introduction
Bind Variables and the Shared Pool
The NOCOPY Hint and Memory Usage
Bigger is Better for VARCHAR2 Variables
Using Packages Correctly
Pinning Packages in the Shared Pool
Conclusion

Chapter 6 - Cursor Variables and REF CURSOR Types

Introduction
Defining Cursor Variables
Cursor Variables as Parameters
Cursor Attributes and Cursor Variable Usage
Host Variables as Cursor Variables
Dynamic SQL and Variant Resultsets
Restrictions When Using Cursor Variables
Cursor Expressions
Conclusion

Chapter 7 - Table Functions and Pipelining

Introduction
Pipelining Table Functions
Parallel Enabled Table Functions
Creating Transformation Pipelines
Deterministic
Miscellaneous Information
Conclusion

Chapter 8 - Monitoring and Profiling PL/SQL

Introduction
Producing Performance Baselines
Monitoring Specific Code
Code Instrumentation (application tracing)
The DSP Package
dbms_application_info
dbms_session
dbms_system
dbms_profiler
dbms_trace
SQL trace, trcsess and tkprof
Generating SQL Trace Files
trcsess
tkprof
Trace Example
Execution Plans
plan_table
autotrace
Explain Plan
utlxpls.sql
dbms_xplan
Identifying the Impact of Code at the Database Level
Dynamic Performance Views (V$)
sessions.sql
top_sessions.sql
top_sql.sql
longops.sql
session_waits.sql
session_events_by_sid.sql and system_events.sql
session_stats.sql and system_stats.sql
session_io.sql
open_cursors_by_sid.sql
locked_objects.sql
STATSPACK
Automatic Workload Repository (AWR)
ADDM
Using Oracle Enterprise Manager
Conclusion
Book Conclusion

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Hall, Timothy S.
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: > 20
Print on Demand
Da
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. This item is printed on demand. Item doesn't include CD/DVD. Codice libro della libreria 1299334

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 22,39
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

2.

Timothy Hall
Editore: Rampant TechPress (2006)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Quantità: > 20
Print on Demand
Da
PBShop
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Rampant TechPress, 2006. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,83
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

3.

Hall, Dr. Timothy
Editore: Rampant Techpress (2017)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 20
Print on Demand
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Rampant Techpress, 2017. Paperback. Condizione libro: New. This item is printed on demand. Codice libro della libreria 097615739X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 25,45
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,77
In U.S.A.
Destinazione, tempi e costi

4.

Hall, Timothy S./ Mortensen, Eric/ Burleson, Don (EDT)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Quantità: 5
Da
Chiron Media
(Wallingford, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Condizione libro: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Codice libro della libreria NU-ING-00555202

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 25,21
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,45
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

5.

Timothy Hall
Editore: Rampant Techpress, United States (2014)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 10
Print on Demand
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Rampant Techpress, United States, 2014. Paperback. Condizione libro: New. 226 x 175 mm. Language: English . Brand New Book ***** Print on Demand *****.Oracle experts know that PL/SQL tuning makes a huge difference in execution speed. As one of the world s most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PL/SQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL./SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PL/SQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book. Codice libro della libreria APC9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,36
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

6.

Timothy Hall
Editore: Rampant Techpress, United States (2014)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 10
Print on Demand
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Rampant Techpress, United States, 2014. Paperback. Condizione libro: New. 226 x 175 mm. Language: English . Brand New Book ***** Print on Demand *****. Oracle experts know that PL/SQL tuning makes a huge difference in execution speed. As one of the world s most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PL/SQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL./SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PL/SQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book. Codice libro della libreria APC9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,46
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

Dr. Timothy Hall
Editore: Rampant Techpress
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 20
Da
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Rampant Techpress. Paperback. Condizione libro: New. Paperback. 230 pages. Dimensions: 8.9in. x 6.9in. x 1.0in.Oracle experts know that PLSQL tuning makes a huge difference in execution speed. As one of the worlds most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PLSQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL. SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PLSQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Codice libro della libreria 9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 26,02
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,66
In U.S.A.
Destinazione, tempi e costi

8.

Hall, Timothy
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 1
Da
READERS PRIDE
(FREMONT, CA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: BRAND NEW. NEW Book in Mint Condition -- Great DEAL !! Fast Shipping -- Friendly Customer Service -- Buy with Confidence!. Codice libro della libreria RP097615739XBN

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 27,06
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,66
In U.S.A.
Destinazione, tempi e costi

9.

Hall, Dr. Timothy; Burleson, Donald [Editor]
Editore: Rampant Techpress (2006)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Paperback Quantità: 10
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Rampant Techpress, 2006. Paperback. Condizione libro: New. Codice libro della libreria INGM9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 28,01
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

10.

Timothy Hall
Editore: Rampant TechPress (2006)
ISBN 10: 097615739X ISBN 13: 9780976157397
Nuovi Quantità: > 20
Print on Demand
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Rampant TechPress, 2006. PAP. Condizione libro: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780976157397

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 21,77
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,40
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro