Re: performance problem : tkprof show many fetches with high elapsed time

From: <janik_at_pobox.sk>
Date: 4 Jan 2007 01:29:53 -0800
Message-ID: <1167902993.786282.246620@11g2000cwr.googlegroups.com>

> call count cpu elapsed disk query current rows
> ------- ----- ------ ------- ------- ------- ------- -----
> Parse 12 0.01 0.01 0 0 0 0
> Execute 12 0.00 0.00 0 0 0 0
> Fetch 7297 54.03 852.73 82456 330248 0 72935
> ------- ----- ------ ------- ------- ------- ------- -----
> total 7321 54.04 852.74 82456 330248 0 72935

How data are processed (e.g. it is in stored procedure with BULK COLLECT or a OCI client etc) ?
One fetch is fetching 10 rows. Maybe if you increase the fetch size (in SQLPLUS it is called arraysize) then you reduce the number of FETCH and maybe also the elapsed time.

Jan Received on Thu Jan 04 2007 - 03:29:53 CST