Check_alertlog
- This Script search for Oracle error messages in last 100 lines in the alert log file , send a email message to concerned and keep log to a file.
You should pass name of ORACLE_SID as a parameter.
for eg: Ck_alerlog FINL
pop
(Added: 7-Jul-2000 Hits: 15271 Rating: 5.04 Votes: 20) Rate It
Oracle Database, Listener and Names Server Monitor
- Monitor the status of the Oracle database, listener, names server can be added in the cron to be executed on regulary basis.
pop
(Added: 23-Aug-1999 Hits: 14621 Rating: 6.22 Votes: 22) Rate It
BEFORE APPEND
- This script will insert a message into a specific line of multiple files.
(Added: 1-Oct-2008 Hits: 305 Rating: 0 Votes: 0) Rate It
Beyond Find
- Delete all the files from the temporary directory, leaving only the recently created last 4 files.
(Added: 9-Feb-2007 Hits: 3765 Rating: 10.00 Votes: 1) Rate It
Estimate Space Utilization Script
- This script queries your database for tablespaces and estimates their space utilization like allocated space, used space, free space available and percentage of used space. The script can also search if %used space is more than 80, send an email to concerned, and log details to a file.
(Added: 30-Nov-2001 Hits: 6866 Rating: 6.33 Votes: 3) Rate It
pidinfo for unix
- Script to find parents and descendants of a given process id.
Puts arrow on pid given as argument parents and descendants of given process id are shown in proper order and indented for readability
(Added: 25-Aug-2003 Hits: 3707 Rating: 10.00 Votes: 3) Rate It
Unix script for performing repetitive jobs
- Unix script/ Awk command for performing repetitive jobs, like creating directories from u01 u99 on an unix server.
(Added: 12-Sep-2006 Hits: 2893 Rating: 0 Votes: 0) Rate It
Which instance owns which unix shared memory segment
- With multiple instances on a system, sometimes it is helpful to know which instance owns which unix shared memory segments. Orphan memory segments can cause problems starting a database.
Searching for these by hand can take a long time on a system with many databases. This script lists all segments, their owners and any orphans.
Use ipcrm -m to remove problem segments.
(Added: 4-Feb-2003 Hits: 4463 Rating: 9.00 Votes: 1) Rate It