RE: AIX swapping...

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 20 Dec 2001 14:23:22 -0800
Message-ID: <F001.003E1487.20011220135519@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.

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

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohan, Ross
INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------