Posted on 2006-05-31
Last Modified: 2012-06-22

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?

Question by:peledc
    1 Comment
    LVL 34

    Accepted Solution

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

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
    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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    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.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now