02430nam a22002417a 450000500170000001000150001702000260003203500130005803700130007108200120008410000220009624500970011826000430021527000500025830000340030850000190034250514190036152002670178065000430204765000370209065000450212770000160217220160425113249.0  aENG-115076  a9789339222369c695.00  aEN-98608  bDBAD/PUB  a005.133  aRosenblum,Michael  aOracle PL/SQL performance tuning tips & techinques /cby Michael Rosenblum [and] Paul Dorsey  aNew DelhibMcGraw Hill Educationc2015  aP-24, Green Park ExtensionbNew Delhie110016  axxvi,306p. :c24cm(pbk)bill.  aIncludes index  a"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 perMachine generated contents note: Section 1. Core ideas and elements of PL/SQL performance tuning -- Introduction. Role of PL/SQL in contemporary development -- Chapter 1. The concept of performance tuning -- Chapter 2. DBA/Developer borderline: tools/features/setup -- Chapter 3. Performance measuring techniques -- Section 2. Tuner's toolkit -- Chapter 4. Thinking in SETs -- Chapter 5. Pulling a trigger -- Chapter 6. Doing more -- Chapter 7. Do more with LESS -- Chapter 8. Keeping the cache -- Chapter 9. Shooting moving target -- Section 3. PL/SQL in the daily life -- Chapter 10. Effective utilization of PL/SQL in the web environment -- Chapter 11. Version control and editions -- Chapter 12. Small tips, tricks and ideas -- Appendix: Knowledge self-test.formance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide"-- Provided by publisher.  arepeatable 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"-- Provided by publisher.  aSQL/ORACLE (Computer program language)  aPL/I (Computer program language)  aCOMPUTERS / Programming Languages / SQL.  aDorsey,Paul