alter session set db_file_multiblock_read_count =
32768;
enable event 10046 at level 8
do a large full scan
check the trace file, 'p3' tells you the max mb count
it could use, and thus the max io (from oracle's
perspective)
hth
connor
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Um that
Title: RE: db_file_multiblock_read_count/max i/o
Oracle
will silently set it to the max setting for the platform. Meaning the
v$parameter will just show what you set it at reguardless of what the max
is. The only way is using truss type utility and monitor the system
calls.
"Wa
Title: RE: db_file_multiblock_read_count/max i/o
thanks Connor. Excellent info.
Lisa Koivu
Ft. Lauderdale, FL, USA
-Original Message-
From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE