Expert Oracle SQL

Optimization, Deployment, and Statistics



Bookstore > Books > Expert Oracle SQL

Price$58.31 - $62.67
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 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 best pra...

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 make...

Price:  $54.99  |  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 framew...

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:  $49.99  |  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:  $34.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 tuning as a whole...

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

Expert Oracle Exadata, 2nd Edition

Expert Oracle Exadata, 2nd Edition

by Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder

Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn t...

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

Beginning Oracle SQL, 3rd Edition

Beginning Oracle SQL, 3rd Edition

by Lex deHaan, Tim Gorman, Inger Jorgensen, Melanie Caffrey

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2014