Re: ANALYZE Command

From: <michael_bialik_at_my-deja.com>
Date: Sat, 03 Jul 1999 09:09:46 GMT
Message-ID: <7lkk0o$38e$1@nnrp1.deja.com>

Hi, Selena.
Just verify that you have parameter : optimizer_mode in your INIT*.ORA file set to CHOOSE or ALL_ROWS or FIRST_ROWS value. COST_BASED optimizer will be used by Oracle and it will take in consideration the statistics.

Check again that you analyzed ALL your tables, otherwise the performance will suffer.

Good luck. Michael.

In article <7li6ll$8vl$1_at_nnrp1.deja.com>, selena.flowers_at_gtri.gatech.edu wrote:
> Hi,
>
> I've ran the ANALYZE command, but I don't understand how to utilize
the
> statistics that were populated in the DBA_Histograms Table? I don't
> understand exactly understand the results concerning Endpoint_Number
> and Endpoint_Value? What should I be looking for?
>
> I need help. I just started focusing on Performance Tuning.
>
> Thanks, Selena
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 03 1999 - 04:09:46 CDT