Oracle PL/SQL Performance Tuning Tips & Techniques /

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 hands-on approach to enabling optimal results from PL/S...

Full description

Bibliographic Details
Main Authors: Rosenblum, Michael (Author), Dorsey, Paul (Author)
Corporate Author: Safari, an O'Reilly Media Company
Format: eBook
Language:English
Published: Oracle Press, 2014.
Edition:1st edition.
Subjects:
Online Access:Connect to this electronic resource

MARC

Tag First Indicator Second Indicator Subfields
LEADER 00000uam a2200000 a 4500
001 in00004257980
005 20260128222547.4
006 m o d
007 cr cn
008 300714s2014 xx o eng
020 |z 9780071822183 
020 |z 9780071824828 
035 |a (CaSebORM)9780071824828 
040 |d UtOrBLW 
041 0 |a eng 
100 1 |a Rosenblum, Michael,  |e author.  |0 http://id.loc.gov/authorities/names/nr97004595 
245 1 0 |a Oracle PL/SQL Performance Tuning Tips & Techniques /  |c Rosenblum, Michael. 
250 |a 1st edition. 
264 1 |b Oracle Press,  |c 2014. 
300 |a 1 online resource (336 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
520 |a 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 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. 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 Code examples in the book are available for download. 
533 |a Electronic reproduction.  |b Boston, MA :  |c Safari,  |n Available via World Wide Web.  |d 2015. 
538 |a Mode of access: World Wide Web. 
542 |f Copyright © McGraw-Hill 2015  |g 2015 
588 |a Online resource; Title from title page (viewed August 29, 2014) 
500 |a Electronic resource. 
630 0 0 |a Oracle (Computer file)  |0 http://id.loc.gov/authorities/names/n91015760 
650 0 |a Database management.  |0 http://id.loc.gov/authorities/subjects/sh85035848 
650 0 |a Relational databases.  |0 http://id.loc.gov/authorities/subjects/sh86007768 
655 7 |a Electronic books.  |2 local 
700 1 |a Dorsey, Paul,  |e author.  |0 http://id.loc.gov/authorities/names/n81044133 
710 2 |a Safari, an O'Reilly Media Company. 
856 4 0 |u https://proxy.library.tamu.edu/login?url=https://go.oreilly.com/TAMU/library/view/-/9780071824828/?ar  |z Connect to this electronic resource  |t 0 
999 f f |s 16bdc469-aded-3b19-8f75-3c4de8156377  |i d9fd0508-1606-32e5-802c-739849df2268  |t 0 
952 f f |a Texas A&M University  |b College Station  |c Electronic Resources  |s www_evans  |d Available Online  |t 0  |h No information provided 
998 f f |t 0  |l Available Online