RE: AIX swapping...

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Thu, 20 Dec 2001 12:35:16 -0800
Message-ID: <F001.003E12C7.20011220122101@fatcity.com>

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

Are you doing async I/O?
full 64 bit read write or some hybrid?
and kind of "direct I/O" going on?
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: Ethan.Post_at_ps.net

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: ListGuru_at_fatcity.com (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). Received on Thu Dec 20 2001 - 14:35:16 CST