Oracle-L: RE: Virtual drive on Solaris

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Mon, 24 Jun 2002 08:04:03 -0800
Message-ID: <F001.00485745.20020624080403@fatcity.com>

Here is the command sample:

mount -f tmpfs -o size=800m swap /ramdisk

We use it to run a small database totally in memory. We decided that staying within the Oracle product suite was better for us vs. using a real memory-only rdbms. The mounting of the temporary disk is in our server startup scripts along with the other physical file systems. Then another script just copies a cold backup onto the temp file system before it starts up the database. Its been in production for almost 4 years now with no issues whatsoever.

Thinking about it a bit, is the 300 GB not on some sort of disk array with a hefty cache fronting it that would be slowing your LGWR down? Maybe it isn't the disk that's holding the LGWR back but instead some other resource on the server. Anyway, I guess this is an easy hypothesis to test with the ramdisk. If you get the performance boost that you expect without inducing additional paging then you can look into acquiring some solid state disks so that your successors don't totally freak out about the ramdisk (we still blow people's mind away when we show them our implementation.)

HTH
Tony Aponte

-----Original Message-----
Sent: Sunday, June 23, 2002 10:53 PM
To: Multiple recipients of list ORACLE-L

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

--

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

Author: Aponte, Tony
INET: AponteT_at_hsn.net

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