Re: 9i Parsing Optimization

Without seeing the statement, I would say max_permutations. Your parse elapse time consists of mostly cpu time, so that could be it. However it may not be the (only) one.

Anjo.

On 8/30/06, amonte <ax.mount_at_gmail.com> wrote:
>
> Hi
>
> I have TKPROFed some batch processes running in Oracle 8i. After upgraded
> to 9i I monitored the same batch processes and I notice Parsing has been
> reduced by 50% without changing any code.
>
> Does anyone know what Optimization is this? I have not changed any
> parameters. Only added automatic pga.
>
>
> TIA
>
> Alex
>
>
> 8i:
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 120 0.43 0.44 0 0
> 0 0
> Execute 60 0.01 0.03 0 0
> 0 0
> Fetch 60 0.05 1.51 157 829
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 240 0.49 1.98 157 829
> 0 0
>
> 9i
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 60 0.01 0.01 0 0
> 0 0
> Execute 60 0.01 0.03 0 0
> 0 0
> Fetch 60 0.05 1.33 165 828
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 180 0.07 1.37 165 828
> 0 0
>
>

-- 
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888

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