Re: 3GB RAM usage by Oracle

Don Burleson wrote:

> Just last week I had a client who was having a huge CPU bottleneck,
> and the root cause was excessive parsing and REALLY bad SQL. They
> chose to spend $50k for faster processors (15 minutes to fix) rather
> than spend $100k to tune 2,000 SQL statements (6 weeks to fix).

Six weeks and $100K? I would have done it in a week for 1/10th that cost.

Step 1: Install 10g
Step 2: Run ADDM
Step 3: Accept ADDM's replacement statements
Step 4: Print invoice
Step 5: Get a decent single malt and listen to David Bowie CDs

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)