?
Solved

How to set limit size for dump area

Posted on 2011-09-23
7
Medium Priority
?
519 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
ID: 36592066
what's OS ?
0
 

Author Comment

by:gbcbr
ID: 36592160
Solaris 10/9
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:gbcbr
ID: 36599570
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
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).

wmp
0
 

Author Comment

by:gbcbr
ID: 36599705
@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 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.

wmp

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hello fellow BSD lovers, I've created a patch process for patching openjdk6 for BSD (FreeBSD specifically), although I tried to keep all BSD versions in mind when creating my patch. Welcome to OpenJDK6 on BSD First let me start with a little …
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
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.
Suggested Courses
Course of the Month15 days, 8 hours left to enroll

850 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