Oracle PL/SQL Performance Tuning Tips & Techniques

By Michael Rosenblum & Paul Dorsey


Oracle PL/SQL Performance Tuning Tips & Techniques - Michael Rosenblum & Paul Dorsey

More by Michael Rosenblum & Paul Dorsey : Oracle PL/SQL Performance Tuning Tips & Techniques


Related Books

Proven PL/SQL Optimization Solutions

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 handson 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. Follow a request-driven nine-step process to identify and address performance problems in web applications Use performance-related database tools, including data dictionary views, logging, tracing, PL/SQL Hierarchical Profiler, PL/Scope, and RUNSTATS Instrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers Embed PL/SQL in SQL and manage user-defined functions Embed SQL in PL/SQL using a set-based approach to handle large volumes of data Properly write and deploy data manipulation language triggers to avoid performance problems Work with advanced datatypes, including LOBs and XML Use caching techniques to avoid redundant operations Effectively use dynamic SQL to reduce the amount of code needed and streamline system management Manage version control and ensure that performance fixes are successfully deployed


Search
Recent Posts
Presentations
Superintelligence
Python Programming: Your Step By Step Guide To Easily Learn Python in 7 Days
The Book of Why
The Future of Leadership
Deep Thinking
Prediction Machines
(ISC)2 CISSP Certified Information Systems Security Professional Official Study Guide
Python for Data Analysis
The Handy Tips Guide to the iPad
100 Things Every Mac User Should Know
Email
Ghost in the Wires
Photoshop CS6 Beta New Features
Writing On The iPad: Text Automation with Editorial
Beginning Java Programming
iPhone Blueprints
iPhone & iPad Secrets (For iOS 10.3)
The Handy Tips Guide to the iPhone 5 & iOS 6
What the Plus!
iPad Pro Guidebook
The iPad Office
iPhone X Pro Guide
Beginning C++ Programming
Objective-C Programming
The Handy Tips Guide to the iPad & iPad Mini
Beginning C# Programming
iCloud
Our Final Invention
My First MacBook and MacBook Air
A Beginner’s Guide to iPhone 6 and iPhone 6 Plus
iPhone 7 Guidebook
HTML, XHTML and CSS For Dummies
Agile Project Management Methodology for Beginners: Scrum Project Management for Beginners
An Unofficial Guide to Mac Mini Media Servers for Newbies: Yosemite (2nd Edition)
The Brand Gap: Revised Edition
iPad Pages
The Big Switch: Rewiring the World, from Edison to Google
The Handy Tips Guide to the New iPad
iPad: The Missing Manual
JavaScript: The Good Parts
100 More Things Every Mac User Should Know
iPad Superguide, Third Edition
Microsoft Excel Basic Formulae
iPad Numbers
Scrivener vs Ulysses
Adobe Photoshop CS6 Classroom in a Book
iPhone 5 Quick Starter Guide
Presentation Zen
Objective-C Programming
Data and Goliath: The Hidden Battles to Collect Your Data and Control Your World
Aqua and Bondi
Amazon Audible Audiobooks
The Soul of A New Machine
The Art of Invisibility
The Age of Spiritual Machines
All the C You Need to Know
A Newbie’s Guide to OS X Yosemite
CompTIA A+ Certification All-in-One Exam Guide, Ninth Edition (Exams 220-901 & 220-902)
iPhone 8 Advanced Guide
The Art of Intrusion
OS X 10.8 Mountain Lion
Official (ISC)2 Guide to the CISSP CBK, Fourth Edition
Social Engineering
Minecraft
iPhone 5s and 5c Starter Guide
Siri:
CCNA Certification All-In-One For Dummies
iMac Pocket Genius
iPhone 6s Tips & Tricks
Building Your Own Computer. No Frills, No Filler, Just Answers.
101 Essential iPad Tips & Tricks
Beginning Programming All-In-One Desk Reference For Dummies
How to Be Invisible
JavaScript: The Definitive Guide
Programming in Objective-C, 4/e
CCENT/CCNA ICND1 100-101 Official Cert Guide
In the Beginning...Was the Command Line
Learning Python
Mac Gems Superguide
Objective-C Boot Camp
Upgrade Your Apps
Python® Programming for the Absolute Beginner, Third Edition
A Newbies Guide to Evernote
Xcode Primer
A Newbies Guide to iPhone 6s and iPhone 6s Plus
Cocoa Programming for Mac OS X, 4/e
Presentation Zen: Simple Ideas on Present...
iPad iWork
ZAG
Learn 3D With Cheetah 3D 6
Cloud Computing For Dummies
#iPadOnly. The First Real Post-PC Book [iPad Version]
Writing A Novel with Ulysses
Beginning Excel VBA
All-New Amazon Echo User Guide: Newbie to Expert in 1 Hour!
Programming in Objective-C, 6/e
Excel 2007 For Dummies
The Non-Designer's Design Book
Adobe Photoshop Lightroom 3 Book for Digi...