| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAM Disks, redo logs, and beer
Thanks for the info, Ross.
We have a tablespace set up on the RAM disk, we know what the hot files are, and we've moved some of'em to the RAM disk (it's not big enough to move all of'em there).
Now we're just gonna sit back and watch all the great performance stats roll in. :>)
FWIW, the SQL is doggy. It's developed on MySQL and ported to Oracle with very little change. Kind of ugly. But, the RAM disk was available so we figured we'd take advantage of it.
Thanks,
--Walt
-----Original Message-----
Sent: Wednesday, October 31, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Walt,
The SDS guys have a few neat utilities that'll help you decide what your hot files are...with some DBA magic, you can figure out what your hot tables in those files are.
Make a new, small "hot" tablespace, and put it on the ramdisk.
And yes, with all the failsafes built into the ramdisk by SDS, i'd skip the duplex.
Benchmark it all, pre and post, because your throughput/bottleneck and app performance will change alot and you'll want to know "how".
Oh, and...if your SQL is doggy (multitable joins...sorting...etc...) it may well be that you'll become compute bound, and no amount of disk will save you.
Please keep us posted!
good luck
-----Original Message-----
Sent: Tuesday, October 30, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L
Anybody out there ever use, or are using, RAM disks?
We recently purchased a 2gb RAM disk from Solid Data Systems, originally to put some of our larger MySQL databases on it in hopes of increasing the performance. Since speed wasn't really the problem we're having with MySQL it didn't do any good.
SO, we attached it to one of our Oracle database servers this weekend. I've moved the customer database redo logs to the RAM disk and am hoping for wonderful things to happen once we put a load on the machine.
Since I don't know a damn thing about RAM disks I was hoping someone could give me some pointers on correct RAM disk etiquette. I'm duplexing the redo logs and both plexes are on the RAM disk. During periods of high usage will this cause the RAM disk to overheat? Will it get confused? Will it roll over and die? Should I ignore everything my mother ever taught me about redo logs and de-duplex the suckers?
Also, the redo logs take up about 250mb. The RAM disk holds 2gb, and since the little guy put us back about US$29,000, we would sure like to use the rest of the space. We're thinking about putting some of the more active tables on the RAM disk. Anybody ever do something like this? Any suggestions on what not to do?
I'll also be talking to the Solid Data Systems engineers to get their input, but I'd like to hear from the people who actually use the things.
Thanks,
--Walt Weaver
Bozeman, Montana
P.S. The beer part of this message was rerouted to ORACLE-L-OT.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: wweaver_at_rightnow.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Wed Oct 31 2001 - 10:18:51 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |