Caffrey, Melanie.
Expert Oracle Practices Oracle Database Administration from the Oak Table / [electronic resource] : by Melanie Caffrey, Pete Finnigan, Randolf Geist, Alex Gorbachev, Tim Gorman, Connie Green, Charles Hooper, Jonathan Lewis, Niall Litchfield, Karen Morton, Robyn Sands, Jože Senegačnik, Uri Shaft, Riyaj Shamsudeen, Jeremiah Wilton, Graham Wood. - 592 p. online resource.
Battle Against Any Guess -- A Partly Cloudy Future -- Developing a Performance Methodology -- The DBA as Designer -- Running Oracle on Windows -- Managing SQL Performance -- PL/SQL and the CBO -- Understanding Performance Optimization Methods -- Choosing a Performance Optimization Method -- Managing the Very Large Database -- Statistics -- Troubleshooting Latch Contention -- Measuring for Robust Performance -- User Security -- Securing Data.
This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.
9781430226697
10.1007/978-1-4302-2669-7 doi
Computer science.
Computer Science.
Programming Techniques.
QA76.6-76.66
005.11
Expert Oracle Practices Oracle Database Administration from the Oak Table / [electronic resource] : by Melanie Caffrey, Pete Finnigan, Randolf Geist, Alex Gorbachev, Tim Gorman, Connie Green, Charles Hooper, Jonathan Lewis, Niall Litchfield, Karen Morton, Robyn Sands, Jože Senegačnik, Uri Shaft, Riyaj Shamsudeen, Jeremiah Wilton, Graham Wood. - 592 p. online resource.
Battle Against Any Guess -- A Partly Cloudy Future -- Developing a Performance Methodology -- The DBA as Designer -- Running Oracle on Windows -- Managing SQL Performance -- PL/SQL and the CBO -- Understanding Performance Optimization Methods -- Choosing a Performance Optimization Method -- Managing the Very Large Database -- Statistics -- Troubleshooting Latch Contention -- Measuring for Robust Performance -- User Security -- Securing Data.
This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.
9781430226697
10.1007/978-1-4302-2669-7 doi
Computer science.
Computer Science.
Programming Techniques.
QA76.6-76.66
005.11