Query Help - Very High Buffer Gets and Executions

From: BN <bnsarma_at_gmail.com>
Date: Tue, 3 May 2005 13:51:12 -0400
Message-ID: <61292a9d0505031051699b96f7@mail.gmail.com>

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 Received on Tue May 03 2005 - 14:03:59 CDT