• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

How to set limit size for dump area

Please advice how to set limit size for dump area and automatically clean it after reaching this limit.
Thank you
0
gbcbr
Asked:
gbcbr
  • 3
  • 3
1 Solution
 
hossamshaabanCommented:
what's OS ?
0
 
gbcbrAuthor Commented:
Solaris 10/9
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gbcbrAuthor Commented:
Sorry for not correct question.
I need to control Oracle dump area from overfilling and stacking whole system.
0
 
woolmilkporcCommented:
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
 
gbcbrAuthor Commented:
@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
 
woolmilkporcCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now