[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


How to set limit size for dump area

Posted on 2011-09-23
Medium Priority
Last Modified: 2012-05-12
Please advice how to set limit size for dump area and automatically clean it after reaching this limit.
Thank you
Question by:gbcbr
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Expert Comment

ID: 36592066
what's OS ?

Author Comment

ID: 36592160
Solaris 10/9
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 36599570
Sorry for not correct question.
I need to control Oracle dump area from overfilling and stacking whole system.
LVL 68

Expert Comment

ID: 36599654
Use sqlplus to log in to oracle as sysdba and issue

show parameter max_dump_file_size

If it's UNLIMITED change it to a reasonable size.

The "dump area" is part of your filesystem.
All you can do (afaik) is monitor the accumulated size of the dumps therein and delete what you think is no longer needed.

Find the place where your dumps go with

show parameter dump_dest

(also in sqlplus as sysdba).


Author Comment

ID: 36599705
Thank you for advice.
I see the size and location of dump area in OEM, but I would like to automate cleaning of old records.
Now I'm doing this cleaning manually at Sunday, I need some PL/SQL JOB to do it instead of me by rm command.
Thank you
LVL 68

Accepted Solution

woolmilkporc earned 2000 total points
ID: 36599783
A Unix script based on "find" to remove everything from the dump destinations
which is older than let's say one week should not be a problem,
but PL/SQL is not really my favorite language.

I think you should search the net, I'm sure there are useful samples around.



Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

656 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