Solved

How to set limit size for dump area

Posted on 2011-09-23
7
485 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
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 36598734
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
can't umount nfs share after server goes offline... 4 84
OpenLDAP Proxy to Active Directy 6 292
Unix Question 19 50
Searching File Names and Eliminating Duplicates in Linux 4 71
A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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.

831 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