Hi All does anyone have any white paper or info on how to configure a dedicated portion of real memory as a virtual drive on Solaris ? I want to move my online redo logs (4 X 128 M single threaded) for a 300 GB DW onto it, to speed up Informatica ETL, since Informatica does not allow me to specify /*+ APPEND */ mode of insert. I know I will not bypass the SQL layer this way, but at least, the LGWR will be writing to memory instead of disk. Thanks in advance.
Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -----Original Message----- Sent: Saturday, 22 June 2002 9:03 PM To: Multiple recipients of list ORACLE-L On Solaris ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM -opmem,pcpu,user,args use: psrinfo -v prtconf | grep Mem format uname -a HTH Richard -----Original Message----- Sent: Saturday, June 22, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by "ps", but what aditional parameters I have to provide? At a first glance, output of "man ps" vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld 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).
