Re: direct path read/write temp waits

as said earlier by bobak the Tempfiles start numbering w/ db_files+1 u can also check from v$sql_workarea_Active to find out whether u are using temp or memory

On 4/25/07, genegurevich_at_discoverfinancial.com < genegurevich_at_discoverfinancial.com> wrote:
>
>
> Hi all
>
> I'm trying to find out a way to deal with direct path read/write temp
> waits. I am loading a table as a select from another table
>
> insert /*+ append */ into table1 (select col1, col2, sum ... from table2
> group by ...);
>
> While this is running I see a number of the direct path read/write temp
> waits in the v$session_waits table
> I have found a document dealing with this waits on metalink
> (
> http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10752/instance_tune.htm
> )
> The file_id that I am seeing are 301 and 302. I only have 55 datafiles in
> this database so this is definitely a TEMP tablespace. If I read that
> document correctly, this means that the sorts are too large to fit in
> memory and some
> data are written to disk. I have however checked the sessstat table for
> the
> sessions listed in the tempseg_usage view
> and found no data for sorts. I am not sure how to reconcile these two
> pieces of data.
>
> I am also doing a full scan of one partition in the table2. Both tables
> are
> parallelized. My oracle version is 10.2.0.3
>
> thanks for any suggestion
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
thanks
Arun

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