Oracle-L: Virtual drive on Solaris

From: Ferenc Mantfeld <fmantfeld_at_siebel.com>
Date: Sun, 23 Jun 2002 18:53:18 -0800
Message-ID: <F001.00485188.20020623185318@fatcity.com>

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: vladob_at_aster.si

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: Ji, Richard
INET: Richard.Ji_at_MobileSpring.com

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

--

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

Author: Ferenc Mantfeld
INET: fmantfeld_at_siebel.com

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