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.  64 bit yes, I assume read and write, don't know how to
check that one.  Buffers?  Db block or some other?  Most non-default parms
are below.

-----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).

Reply via email to