Oracle PL/SQL performance tuning tips & techniques / Michael Rosenblum and Dr. Paul Dorsey.
Contributor(s): Dorsey, Paul [author.]Material type: TextPublisher: New York : McGraw-Hill Education, 2014Edition: 1st edDescription: xxvi, 306 pages ; 23 cmContent type: text Media type: unmediated Carrier type: volumeISBN: 9780071824828 (paperback); 0071824820 (paperback)Subject(s): SQL/ORACLE (Computer program language) | PL/I (Computer program language)DDC classification: 005.133 LOC classification: QA76.73.S67 | R68 2014
|Item type||Current location||Call number||Status||Date due||Barcode|
|Books||Centeral Library Second Floor - Computer Sciences||005.133 R.M.O 2014 (Browse shelf)||Available||23969|
The role of PL/SQL in contemporary development -- DBA/Developer Borderline: tools and features -- Code instrumentation in PL/SQL -- Expanding the SQL horizons -- Thinking in sets -- Pulling the trigger -- Going beyond scalar dataypes -- Keepind the cache -- Shooting at a moving target -- Tales from the trenches -- Code management in real-world systems -- Extra tips, tricks, and ideas.
"In Oracle PL/SQL Performance Tuning Tips & Techniques, Oracle ACE authors with decades of experience building complex production systems for government, industry, and educational organizations present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery process required to pinpoint performance problems and then provides measurable and repeatable test cases. In-depth coverage of linking SQL and PL/SQL is followed by deep dives into essential Oracle Database performance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide"--