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

Home -> Community -> Usenet -> c.d.o.server -> Re: Skewed Data or What?

Re: Skewed Data or What?

From: jsfromynr <jatinder.1975_at_gmail.com>
Date: 27 Apr 2006 21:09:25 -0700
Message-ID: <1146197365.071937.75310@j33g2000cwa.googlegroups.com>


Hello Steve,

      Yes this is the right execution Plan. I ran it twice so that cached result would not come in picture for the stat. I had also run the statement

Histogram
ANALYZE TABLE voucher_dt COMPUTE STATISTICS FOR ALL COLUMNS and so on for almost all table which have last_analysed <sysdate-15

How I can reduce the round trip ?? using some high end LAN cards or it has something to do with routing algos .

Any help is appreciated.

With Warm regards
Jatinder Singh

stevedhoward_at_gmail.com wrote:
> Hi Jatinder,
>
> How on earth did that statement generate 173235 round trips (not to
> mention over 6MB of traffic) from the client to the server??? Are you
> sure that is the right explain plan?
>
> Regards,
>
> Steve
Received on Thu Apr 27 2006 - 23:09:25 CDT

Original text of this message

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