RE: Virtual drive on Solaris

[Aponte, Tony]

Title: RE: Virtual drive on Solaris

Thanks.

-----Original Message-----
From: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Virtual drive on Solaris

Tony

 

Ever since I first worked with you, I've always regarded you as best amongst the best (and I don't give that title lightly), and you have substantiated it once again. Thanks for the info, this is great ! Can't wait to freak out some minds :-) !

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-----
From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
Sent: Monday, 24 June 2002 7:58 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Virtual drive on Solaris

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-----
From: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 10:53 PM
To: Multiple recipients of list ORACLE-L
Subject: Virtual drive on Solaris

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