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