Expert Oracle SQL

Optimization, Deployment, and Statistics



Bookstore > Books > Expert Oracle SQL

Price$58.31 - $65.35
Rating
AuthorTony Hasler
PublisherApress
Published2014
Pages624
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101430259779
ISBN-139781430259770
EBook Hardcover Paperback

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance.




5 5 7

Similar Books


Expert Oracle Application Express, 2nd Edition

Expert Oracle Application Express, 2nd Edition

by Doug Gault, Tom Petrus, Denes Kubicek, Dan McGhan, Francis Mignault, Roel Hartman, Raj Mattamal, Jorge Rimblas, Martin D'Souza, Christoph Ruepprich, Dimitri Gielis, Nick Buytaert, Karen Cannell, John Scott, Sharon Kennedy

Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Applica...

Price:  $16.00  |  Publisher:  Apress  |  Release:  2015

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference

by Mark Gurry

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. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...

Price:  $6.76  |  Publisher:  O'Reilly Media  |  Release:  2002

Expert Oracle and Java Security

Expert Oracle and Java Security

by David Coffin

Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java provides resources that every Java and Oracle database application programmer needs to ensure that they have guarded the security of the data and identities entrusted to them. You'll learn to consider potential vulnerabilities, and to apply bes...

Price:  $46.78  |  Publisher:  Apress  |  Release:  2011

Expert PL/SQL Practices

Expert PL/SQL Practices

by Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Connor McDonald, Melanie Caffrey, John Beresniewicz, Sue Harper, Torben Holm, Robyn Sands, Ron Crisco, Martin Buchi, Adrian Billington, Stephan Petit, Arup Nanda

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you'll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can...

Price:  $6.32  |  Publisher:  Apress  |  Release:  2011

Expert Oracle Application Express

Expert Oracle Application Express

by Dietmar Aust , Martin Giffy D'Souza , Doug Gault , Dimitri Gielis , Roel Hartman , Michael Hichwa , Sharon Kennedy , Denes Kubicek , Raj Mattamal , Dan McGhan , Francis Mignault , Anton Nielsen , John Scott

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The f...

Price:  $12.47  |  Publisher:  Apress  |  Release:  2011

Expert Oracle GoldenGate

Expert Oracle GoldenGate

by Ben Prusinski, Steve Phillips, Richard Chung

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It ...

Price:  $7.06  |  Publisher:  Apress  |  Release:  2011

Expert Oracle Application Express Security

Expert Oracle Application Express Security

by Scott Spendolini

Expert Oracle Application Express Security covers all facets of security related to Oracle Application Express (APEX) development. From basic settings that can enhance security, to preventing SQL Injection and Cross Site Scripting attacks, Expert Oracle Application Express Security shows how to secure your APEX applictions and defend the...

Price:  $37.99  |  Publisher:  Apress  |  Release:  2013

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

by Stelios Charalambides

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tu...

Price:  $33.95  |  Publisher:  Apress  |  Release:  2013