RE: Query Help - Very High Buffer Gets and Executions
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <bnsarma@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 May 2005 15:48:59 -0400
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@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of BN
Sent: Tuesday, May 03, 2005 12:51 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
