Hi,
Question: did you note much I/O when running the sort ??. In AIX it's usefull to make some modifications in paging space behavior in order to reduce I/O contention ad let the ORACLE SGA be in main memory instead on paging space.
Try this:
Apply the latest Maintenance Level of AIX 5
Take a view of paging space activity using AIX tools like lsps, vmstat, topas, etc
run the following command vmtune -p 5 -P 10 -t 10
compare with the view taken before issuing the previous command
Good Luck ....
Saludos, Cesar D. Delgado P.
IBM de Venezuela
Tlf (58212) 908-8904
mailto:[EMAIL PROTECTED]
sts://[EMAIL PROTECTED]/
Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun (1912-1977)
| Robertson Lee - lerobe <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 29/10/2003 06:19 a.m.
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: 9i RAC on AIX 5L |
Hi,
Oracle 9.2.0.3
AIX 5L
Anyone out there suffered serious performance issues with sorts to disk on
this platform. we are using GPFS filesystems. The same query took about 16
minutes on a 8.1.7 database running on a small Tru/64 machine, the query on
the p650/9.2.0.3 machine took over 6 hours for a smaller data-set. Obviously
by doing sorting to memory we have reduced the time significantly but we
really would like to get this performing as the 8i system. Our data will be
of a size that some sorting to disk will be inevitable in the future and we
cannot live with the performance as it is. I have raised a call with Oracle
but as usual, the good people on this list invariably come up with some
useful hints/solutions in the meantime.
Regards
Lee
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
