RE: AIX swapping...

Whoops, how did that sneak in there? Your right I usually set sort_area_size to 10 MB on a OneWorld system, I am monitoring disk sorts and really have not incurrered that many but this should be increased. Why do you think retained is too big? I actually increased it. If someone uses 8 MB for a sort I want it to fall back to 3-4 MB or so assuming they might need another sort. Sorts are so rare that this really won't use much memory on my system. I agree if you have 500 users all performing sorts then you would want it smaller so that the memory if freed up.

• Ethan

-----Original Message-----
Sent: Thursday, December 20, 2001 3:55 PM To: Multiple recipients of list ORACLE-L

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?

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