Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Optimisation issues.

Re: Optimisation issues.

From: Craig Burtenshaw <crb_at_amsa.gov.au>
Date: Thu, 17 Jul 2003 12:47:59 +1000
Message-ID: <3f160e57$0$95045$c30e37c6@lon-reader.news.telstra.net>


Hi,
Okay, so I didn't realise what information was required. Here it goes:

Sun Solaris 2.7 - Enterprise 450.
Oracle 8.1.7
Optimiser = CHOOSE
Statistics were with Explain Plan in TOAD.

Cheers

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F16072F.A725B5C3_at_exxesolutions.com... <SNIP
>
> Lets see ... no hardware, no operating system, no version, no edition, no
init
> parmeters, no indication of RBO or CBO, no indication as to whether
statistics
> were created using DBMS_STATS, no EXPLAIN PLAN.
>
> So you want someone to guess?
>
> I guess it is the humidity. ;-)
>
> Seriously ... give us something to work with.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Wed Jul 16 2003 - 21:47:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US