Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: bdbafh@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Performance problem: anything else I can do to make this faster?
Date: 3 Mar 2005 15:22:40 -0800
Organization: http://groups.google.com
Lines: 10
Message-ID: <1109892159.940643.252440@z14g2000cwz.googlegroups.com>
References: <1109793882.803053.240440@l41g2000cwc.googlegroups.com>
   <1109799052.789107.250590@o13g2000cwo.googlegroups.com>
   <00fc2196m32dguelv7p3uqbqbdla0unnvi@4ax.com>
   <1109805174.099516.303550@f14g2000cwb.googlegroups.com>
   <1109805606.965366.268740@o13g2000cwo.googlegroups.com>
   <1109871953.020529.138170@o13g2000cwo.googlegroups.com>
   <jsoe2191e2ean1g1iren3odme8em5bh4rr@4ax.com>
   <1109886332.669618.34910@o13g2000cwo.googlegroups.com>
   <1109886635.572153.26420@f14g2000cwb.googlegroups.com>
   <1109887179.762042.188670@l41g2000cwc.googlegroups.com>
NNTP-Posting-Host: 156.43.4.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1109892163 18667 127.0.0.1 (3 Mar 2005 23:22:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 23:22:43 +0000 (UTC)
In-Reply-To: <1109887179.762042.188670@l41g2000cwc.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=156.43.4.1;
   posting-account=rcQZawwAAAALUCo-zZUVUQgj4l_8W6zb
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237415

dump a 10053 trace as described in the papers above.
the initialization parameter summary alone is worth the effort.
if you read further into it, you'll see the costs and decisions that
the CBO is making.

get a cup of coffee and a serving of your favorite analgesic ... and
give it a shot.

-bdbafh