Re: Query Help - Very High Buffer Gets and Executions

From: mr SunnyGuy <sunnyguy11_at_gmail.com>
Date: Tue, 3 May 2005 18:28:46 -0700
Message-ID: <99c0eae505050318283c3563f4@mail.gmail.com>

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_at_gmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>

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

Received on Tue May 03 2005 - 21:33:08 CDT