Solved

How to set limit size for dump area

Posted on 2011-09-23
7
466 Views
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
0
Comment
Question by:gbcbr
  • 3
  • 3
7 Comments
 
LVL 5

Expert Comment

by:hossamshaaban
Comment Utility
what's OS ?
0
 

Author Comment

by:gbcbr
Comment Utility
Solaris 10/9
0
 
LVL 68

Expert Comment

by:woolmilkporc
Comment Utility
0
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!

 

Author Comment

by:gbcbr
Comment Utility
Sorry for not correct question.
I need to control Oracle dump area from overfilling and stacking whole system.
0
 
LVL 68

Expert Comment

by:woolmilkporc
Comment Utility
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).

wmp
0
 

Author Comment

by:gbcbr
Comment Utility
@wmp
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
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
Comment Utility
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.

wmp

0

Featured Post

IT, Stop Being Called Into Every Meeting

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!

Join & Write a Comment

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

772 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

15 Experts available now in Live!

Get 1:1 Help Now