Re: Star transforms and global temp tables

From: Yong Huang <yong321_at_yahoo.com>
Date: 1 Jun 2002 14:23:16 -0700
Message-ID: <b3cb12d6.0206011323.13afeb29@posting.google.com>

You're right. DB_FILE_DIRECT_IO_COUNT. No underscore.

sort_multiblock_read_count is only in effect when sorting to TEMP occurs. hash_multiblock_read_count is used when building hash tables in TEMP. Other direct path reads or writes to any tablespace including TEMP uses DB_FILE_DIRECT_IO_COUNT.

Yong Huang

mikerault_at_earthlink.net (Mike Ault) wrote in message news:<37fab3ab.0205310952.15c8df75_at_posting.google.com>...
> This is 8.1.7.3 and the parameter for Global temps is DB_FILE_DIRECT_IO_COUNT.
>
> Mike
> >
> > 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?
Received on Sat Jun 01 2002 - 16:23:16 CDT