|
[oracle-l]
||
[Date Prev]
[05-2005 Date Index]
[Date Next]
||
[Thread Prev]
[05-2005 Thread Index]
[Thread Next]
Query Help - Very High Buffer Gets and Executions
- From: BN <bnsarma@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 May 2005 13:51:12 -0400
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
|
|
