RE: Query Help - Very High Buffer Gets and Executions

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 3 May 2005 15:48:59 -0400
Message-ID: <002301c55019$264d93f0$2004a8c0@development.perceptron.com>

So, you make "695.8 Gets per execution" just to get MIN value. Do you have an index on DV column?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BN Sent: Tuesday, May 03, 2005 12:51 PM
To: oracle-l_at_freelists.org
Subject: Query Help - Very High Buffer Gets and Executions

Greetings,

Please see the Query Below, is there any way I can make it efficent Oracle 9.0.1.2.0 on HP-UX

I cannot use MV. This is for one hour. its there in every houlr report.

                                                     CPU      Elapsd

  Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash =
Value
--------------- ------------ -------------- ------ -------- ---------
-----=

---

    142,450,789 204,722 695.8 23.7 1069.35 1439.02 16276=
65409
select TO_CHAR(min(DV),'YYYY-MM-DD HH24:MI:SS.FF') DV from ECL_T IRKS_DYNAMIC_PIAT having min(dv) is not null

Regards & Thanks
BN
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 03 2005 - 15:53:20 CDT