Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

RAM DISK

Posted on 2006-05-31
1
Medium Priority
?
828 Views
Last Modified: 2012-06-22
Hi,

We are looking into using Solaris 10 RAM DISK feature with Oracle.
Our plan is to build some of the TEMPORARY tablespaces on RAM DISK files.
Our test came out positive and the performance of SORT operations are twice as fast.

does anyone have any production experience with Solaris10 & Oracle 9 (or 10g) using RAM DISK?

Thanks
0
Comment
Question by:peledc
1 Comment
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 2000 total points
ID: 16799414
On Solaris, no.  On RedHat Linux and Windows, yes.  We used RAMdisks with both Oracle9.2 on WindowsServer2003 and currently with Oracle10.1 on RedHat LinuxAS4.  In both systems, we placed our temporary tablespace in the RAMdisk, and we saw performance up to 10x faster for some reports and large PL\SQL processes that use lots of temp tablespace area.  On Windows, we needed third-party software (from www.superspeed.com) to support a RAMdisk, since the O/S does not provide this natively.  Linux offers native support for RAMdisks, so it is easier.  I have no Solaris experience, so I don't know if Solaris supports RAMdisks natively or not.

For Oracle10.1 on Linux, I modifed the "dbora" script to save the contents of the RAMdisk to a physical disk when Oracle is shut down, and to restore the temporary tablespace files to the RAMdisk before the database is restarted.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question