Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Virtual drive on Solaris
Thanks.
-----Original Message-----
Sent: Tuesday, June 25, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L
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-----
Sent: Monday, 24 June 2002 7:58 AM
To: ORACLE-L_at_fatcity.com
Cc: fmantfeld_at_siebel.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...
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).
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: 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 --------------------------------------------------------------------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: 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 --------------------------------------------------------------------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). Received on Tue Jun 25 2002 - 13:10:31 CDT
![]() |
![]() |