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: Yong Huang <yong321_at_yahoo.com>
Date: 30 May 2002 15:31:20 -0700
Message-ID: <b3cb12d6.0205301431.4ed792a1@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 Thu May 30 2002 - 17:31:20 CDT

Original text of this message

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