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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Time to read 6000 (block size 2k) blocks

RE: RE: Time to read 6000 (block size 2k) blocks

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 6 Aug 2004 14:11:19 -0400
Message-ID: <001001c47be0$c5dbbea0$0704a8c0@development.perceptron.com>


Wrong :)
Event 10053 would do much better in this case.

Igor

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J.Velikanovs_at_alise.lv
Sent: Friday, August 06, 2004 12:58 PM
To: oracle-l_at_freelists.org
Subject: RE: RE: Time to read 6000 (block size 2k) blocks

Thank you father!
.

The lesson you have given me is invaluable. Lets me guess for the next step.
I imagine that we can try use our magic artifact, which we have received from Mag
with beautiful name Oracle8i.
.

I gona use magic of DBMS_STATS.
Please allow me to try?!
.

Jurijs
+371 9268222 (+2 GMT)



Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

"Cary Millsap" <cary.millsap_at_hotsos.com> Sent by: oracle-l-bounce_at_freelists.org
06.08.2004 20:21
Please respond to oracle-l  

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        RE: RE: Time to read 6000 (block size 2k) blocks


Excellent to watch this, buys.

Now, if I might suggest: Please take the next step as well, which is to figure out how to make the CBO execute the correct plan WITHOUT leaving =
the
hints in. Doing this step now will save you some potentially difficult maintenance tasks later on.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 8/10 Boston, 9/14 San Francisco, 10/5 = Charlotte
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 = Hartford
- Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of jaysingh1_at_optonline.net
Sent: Friday, August 06, 2004 12:10 PM
To: oracle-l_at_freelists.org
Subject: Re: RE: Time to read 6000 (block size 2k) blocks

Jurijs

You are correct. It worked. Now it is doing 9 LIOs instead of 18,800 = LIOs.
Thanks you so much.

> Rows     Row Source Operation
> -------  ---------------------------------------------------
>      1  SORT UNIQUE=20
>      1   COUNT STOPKEY=20
>      1    NESTED LOOPS=20
>   4766     TABLE ACCESS BY INDEX ROWID PROFILEDUSER (it has=20
> 450,000 rows)
>   4767      INDEX RANGE SCAN (PROFILEDUSER_IX03)
>      1     TABLE ACCESS BY INDEX ROWID EXTENDEDATTRIBUTES (it has=20
> 15,000=20
> rows)
>   9530      INDEX UNIQUE SCAN (ATTRIBUTES_PK)
>=20
> The idea is: to start NL with EXTENDEDATTRIBUTES table. Bacause in=20
> SQL you=20
> have E.CUSTOMERID =3D 'ABCDEFGH', and this seems ID value, which=20
> will return=20
> 1 row, instead 4766 loops thought PROFILEDUSER.
>=20
> Try to get EXTENDEDATTRIBUTES as driven table. Or I am wrong ?
>=20
>=20
> Jurijs
> +371 9268222 (+2 GMT)


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Aug 06 2004 - 13:07:06 CDT

Original text of this message

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