 |
Oracle SQL Tuning Secrets |
|
|
|
Program Track:
Core Technologies
Program Duration:
47 Minutes
Tower:
Infrastructure
|
|
| Roles: |
|
| Primary: |
Data, Information and Knowledge Management |
| Secondary: |
Application Maintenance |
| Tertiary: |
Architecture |
| |
| Value Category: |
Navigation |
| Key Issues: |
How does an organization create a plan of attack for SQL tuning?
What are the tricks for changing its execution plans?
How can an organization make Oracle SQL statements perform quickly and efficiently?
How can an organizaiton uncover the internal execution plan for Oracle SQL?
How can an organization learn how to extract top performance from the application? |
|
 - high
 - medium
 - low
 |
 |
 |
 |
 |
 |
 |
 |
|
Application Development
|
 |
|
|
|
|
|
|
Architecture and Infrastructure
|
 |
|
|
|
|
|
|
Business Applications
|
|
|
|
|
|
|
|
Data Management
|
|
|
|
|
|
|
|
eBusiness
|
|
|
|
|
|
|
|
| |
 |
| |
 |
|
 |
* Oracle SQL Tuning Secrets
A Real Life Tuning Experience - Jonathan Gennick
Analyzing Oracle's Database Clustering Innovation - IT World - July 2001
Can Cursor_Sharing Tame Your Apps? - Interealm Computer Science
EXPLAIN PLAN: Everything You Wanted to Know - Element K - April 1997
Fundamental Tuning Goals: Critical for E-Business - Oracle
Getting the Most from Oracle's Cost-Based Optimizer - Akadia Information Technology
High Performance Oracle Data Warehousing
Improved Response Time with FIRST_ROWS(n) for ORDER BY Queries
Insisting on Indexes - Oracle
Introduction to Parallel Query Tuning - Oracle
Mining Gold From the Oracle Library - Oracle
Net8 Product Page - Oracle.com
Online Survey Form for Oracle SQL Tuning Secrets
Oracle 8 Product - Oracle.com
Oracle 8i Product - Oracle.com
Oracle 9i - Oracle.com
Oracle 9i Product - Oracle.com
Oracle Database Trend Analysis Using Statspack - Oracle
Oracle Dynamic SQL - Oracle
Oracle Initialaztion Parameters
Oracle Initialization Parameters - Oracle
Oracle Internals Home - Auerbach Publications
Oracle Partitioning, Oracle 9i Enterprise Edition - Oracle
Oracle Press Home
Oracle Tips, Tricks and Scripts - University of Arkansas
Oracle Tuning: Examining the Oracle Instance - BEI Consulting - May 2001
Oracle Tuning: Individual SQL Statements - BEI Consulting - May 2001
PeopleSoft Home Page
Precise Software Home
SAP Home Page
Speed Oracle Database Queries With Parallel Features - BEI Oracle Consulting - Jan. 2000
Start by Looking at the Big Picture - BEI Oracle Consulting
The ORDERED Hint - Oracle
The STAR Hint - Oracle
Tuning Problem Queries - Oracle
Using Optimizer Hints - Oracle
Using Oracle Stored Procedures for Fast Performance - BEI Oracle Consulting - Oct. 2000
Using The Oracle Optimizer - Connections - April - June 2002
Video Promo of Upcoming WatchIT Programming
What is SQL*Plus? - Oracle
What is Your Oracle SQL Optimizer Philosophy? - DBA-Oracle.com
|
|
