Re: Query Help - Very High Buffer Gets and Executions
- From: mr SunnyGuy <sunnyguy11@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 May 2005 18:28:46 -0700
Hi,
Try this from sqlplus:
analyze table ECL_TIRKS_DYNAMIC_PIAT estimate statistics sample 9 percent;=
=20
SET AUTOTRACE TRACE
select TO_CHAR(min(DV),'YYYY-MM-DD HH24:MI:SS.FF') DV from=20
ECL_TIRKS_DYNAMIC_PIAT having min(dv) is not null
It would tell us if you are using either an index and/or function based ind=
ex.
-msg
On 5/3/05, BN <bnsarma@xxxxxxxxx> wrote:
> Greetings,
>=20
> Please see the Query Below, is there any way I can make it efficent
> Oracle 9.0.1.2.0 on HP-UX
>=20
> I cannot use MV. This is for one hour. its there in every houlr report.
>=20
> CPU Elapsd
> Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Has=
h =3D
> Value
> --------------- ------------ -------------- ------ -------- --------- ---=
--=3D
> -----
> 142,450,789 204,722 695.8 23.7 1069.35 1439.02 162=
76=3D
> 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
>=20
> Regards & Thanks
> BN
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
