Expert Oracle SQL
Optimization, Deployment, and Statistics
|Price||$58.31 - $62.67
|Format||Paper book / ebook (PDF)|
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
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
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
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
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
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
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
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
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