Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Star transforms and global temp tables

Re: Star transforms and global temp tables

From: Mike Ault <mikerault_at_earthlink.net>
Date: 31 May 2002 10:52:20 -0700
Message-ID: <37fab3ab.0205310952.15c8df75@posting.google.com>


This is 8.1.7.3 and the parameter for Global temps is DB_FILE_DIRECT_IO_COUNT.

Mike
yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0205301431.4ed792a1_at_posting.google.com>...
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1022769304.21889.0.nnrp-13.9e984b29_at_news.demon.co.uk>...
> > likely to be irrelevant for TEMP writes. I haven't
> > actually checked which of the (many) multiblock
> > I/O parameters that gets used for this variant of
> > writing to TEMP, perhaps it is the
> > _db_file_direct_io_count which defaults to 1MB,
>
> Isn't it sort_multiblock_read_count? But let's wait for Mike to tell
> us the Oracle version.
>
> Which version has _db_file_direct_io_count?
>
> Yong Huang
Received on Fri May 31 2002 - 12:52:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US