Oracle SQL Internals Handbook by Burleson D.K.

By Burleson D.K.

OCP teachers advisor for Oracle DBA Certification 2.03 MB

Show description

Read or Download Oracle SQL Internals Handbook PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time details entry and information sharing throughout your disbursed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g info Replication explains find out how to manage and administer a unified firm information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program show four Recipes presents an example-based method of studying software exhibit - the ground-breaking, swift program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes an excellent instance or to kick commence their considering and get pointed within the correct path.

Additional info for Oracle SQL Internals Handbook

Example text

30 Oracle SQL Internals Handbook SQL Tuning Using dbms_stats CHAPTER 4 Query Tuning Using DBMS_STATS Introduction Increasingly enterprises are purchasing their mission-critical applications, whether these use Oracle or other data management software. Typically the licensing and support agreements for such applications seek to prevent the customer from reverse engineering or modifying the application in any way. Although such restrictions may be extremely sensible from a supplier's point of view, they can prevent an individual site from making changes that would result in valuable performance benefits.

Finally, it gives you an option for using the new cursor_sharing parameter without paying the penalty of losing optimum execution paths. There are a few issues to work around in Oracle 8 (largely eliminated in Oracle 9), but in general it is very easy to take advantage of this feature; and this article describes some of the things you can do. Background / Overview To demonstrate how to make best use of stored outlines, we will start with a stored procedure with untouchable source code that (in theory) is running some extremely inefficient SQL.

Although such restrictions may be extremely sensible from a supplier's point of view, they can prevent an individual site from making changes that would result in valuable performance benefits. This paper describes the work performed to overcome a specific performance problem in a purchased application without having to resort to the obvious (but impossible) solution of modifying the application code. Test Environment The experiments conducted during the preparation of this paper were performed on the author's laptop, a Compaq Armada M700 with 448 Mb of memory and a single 20 Gb hard disk partitioned into a FAT device for the operating system and an NTFS device for both the Oracle installation and the database files.

Download PDF sample

Rated 4.54 of 5 – based on 50 votes