Solaris Swap Question, Oracle processes dying

Posted on 2007-10-03
Last Modified: 2013-12-21
Hello, I am running Solaris 9 on a Sun Fire E20k with 64 Gigs of memory. My swap partition is 16 gigs. This server runs primarily Oracle databases but we have been having some trouble where new Oracle processes are dying with errors about not enough memory. I'm looking at the swap information as below, but `swap -l` is telling me I have 16 gigs of free swap space, while `swap -s` is telling me I only have about 6 1/2 gigs of free swap space. I realize that swap -s is including virtual memory, etc..., but it doesn't look like my physical swap partition is even being touched. Why is swap -s telling me I only have 6 or so gigs left of swap? This caused a problem the other day when swap -s was down to a few hundred megs, but swap -l still looked like it was untouched.

bash-2.05$ swap -l
swapfile             dev  swaplo blocks   free
/dev/md/dsk/d1      85,1      16 33560432 33560432

bash-2.05$ swap -s
total: 30387544k bytes allocated + 16178416k reserved = 46565960k used, 6351752k available

Thanks for any help on this and let me know if I can provide more information.

Question by:umfkit
    LVL 40

    Accepted Solution


    This could be due to system wide (kernel) parameter related to semaphores or shared memory that you need to increase. It could be also related to Oracle SGA size. If you can give the exact Oracle error message, it might help in finding the exact problem.

    LVL 3

    Expert Comment


    omarfarid is correct here, if you are running Solaris 9, check /etc/system and make sure the kernel parameters are tuned according to your Oracle installation. Also check to make sure you have allocated enough to your Oracle SGA. You really need to provide the ecact error message you received, was it an ORA message or was it something you saw in syslog?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    About FreeBSD Jails In FreeBSD, jails are a way of doing operating system level virtualization.  The basis of FreeBSD jails is chroot (, which changes the root directory of processes.  As a…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    779 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

    21 Experts available now in Live!

    Get 1:1 Help Now