Yes we are doing async, I checked smitty aio and the numbers were the
default, I am having the admins increase them to soemthing more along the
Oracle reccomends.
|| yes....yes....
64 bit yes, I assume read and write, don't know how to check that one.
|| can you do a "truss" on this OS..i'll be surprised if not....
in any case, do a "man -k read" and that'll give you 600 commands
that have 'something' to do with reading. Some of them'll be
the 64bit IO calls. See if you recognize any from doing the
truss.
Buffers? Db block or some other?
|| Some other. some (most?) implementations of aio depending not
trivially on aio buffer/daemon settings. Worth doing some diligence
on.
Most non-default parms are below.
|| yes...thanks....IMHO I think yer sort_area is too small and the
"...retained..."
is too big, but I don't really know enough about yer RAM, user load,
app profile
to say for sure.
Hope this helps, even if as a warning of things NOT to waste your time
thinking of,
- Ross
-----Original Message-----
Sent: Thursday, December 20, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
more questions, no answers...sorry...
1) Are you doing async I/O?
2) full 64 bit read write or some hybrid?
3) and kind of "direct I/O" going on?
4) if (1) == 'yes', then what are buffers set to?
**************************************************
buffer_pool_keep buffers:64000, lru_latches:2 FALSE
buffer_pool_recycle buffers:2560, lru_latches:2 FALSE
compatible 8.1.7.0.0 FALSE
cursor_space_for_time FALSE FALSE
db_block_buffers 262144 FALSE
db_block_checksum FALSE FALSE
db_block_lru_latches 8 FALSE
db_block_max_dirty_target 0 FALSE
db_block_size 8192 FALSE
db_file_multiblock_read_count 32 FALSE
db_files 100 FALSE
db_writer_processes 1 FALSE
disk_asynch_io TRUE FALSE
distributed_transactions 5 FALSE
dml_locks 200 FALSE
fast_start_io_target 12000 FALSE
global_names FALSE FALSE
log_buffer 1048576 FALSE
log_checkpoint_interval 0 FALSE
log_checkpoint_timeout 0 FALSE
log_checkpoints_to_alert TRUE FALSE
max_dump_file_size 20480 FALSE
open_cursors 1000 FALSE
open_links 4 FALSE
optimizer_mode CHOOSE FALSE
parallel_max_servers 16 FALSE
processes 500 FALSE
rollback_segments rb1, rb2, rb3, rb4, rb5, rb6, FALSE
sessions 555 FALSE
shared_pool_size 62914560 FALSE
sort_area_retained_size 524288 FALSE
sort_area_size 1048576 FALSE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
