Expert Oracle SQL
Optimization, Deployment, and Statistics
| Price | $58.31 - $65.35
|
| Rating |  |
| Author | Tony Hasler |
| Publisher | Apress |
| Published | 2014 |
| Pages | 624 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1430259779 |
| ISBN-13 | 9781430259770 |
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.
- Tony Hasler
5 5 7
Similar Books
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 
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
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
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
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
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
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
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