An sql interface for alert log
- This is a very handy utility (9i only) which let you query the alert log file from an sql tool (sqlplus/toad /oem ...).
It's a generic one (unix,windows,vms) , and it's very simple to install . (install which dba owner).
(Added: 27-Feb-2004 Hits: 4290 Rating: 4.00 Votes: 1) Rate It
Another script to compare oracle parameter files
- Korn shell script to compare any two instance parameter files - spfile.ora and/or init.ora on the same server. Does not connect to databases. Reports only differences. Requires no customization. This versions may not work correctly with 10g parameter files that have multi-line entries
(Added: 4-Nov-2006 Hits: 2442 Rating: 0 Votes: 0) Rate It
Assign temporary tablespace to database users
- This script assigns a temporary tablespace (by number of assigned users) with a database user when its temporary tablespace is wrongly associated to system tablespace or another permanent tablespace. This is only useful when database has a dictionary-managed system tablespace.
(Added: 13-Oct-2003 Hits: 2225 Rating: 10.00 Votes: 1) Rate It
Auto Email from Oracle Database Ver >= 8.1.6
- This is useful when anybody wants to mail through Oracle database. You have to pass sender and receipts. this scripts run in ver >= 8.1.6
(Added: 16-Sep-2002 Hits: 4697 Rating: 7.00 Votes: 2) Rate It
Automate Process of LogMiner Implementation
- This scripts helps implement LogMiner. It takes some examples from Unix naming convention and some for Windows. Just copy this script in a file and run that file on OS level. Otherwise cut and paste portions.
(Added: 13-Apr-2004 Hits: 2147 Rating: 4.50 Votes: 2) Rate It
Check all the clients that have accessed the database
- It lists all the hostnames from where they have connected to your database . It will be helpful in case you haven't enabled auditing to keep track of the logons.
(Added: 19-Jan-2006 Hits: 2485 Rating: 0 Votes: 0) Rate It
COMPARE INIT.ora and SPFILE PARAMETERS
- Usually spfile cannot be opened to see what are the settings in it and sometimes the database parameters are wrong due to wrong spfile entries. This korn script compares the init.ora and spfile parameters and presents it in readable format ,after which the DBA can take proper action.
(Added: 23-Mar-2006 Hits: 2557 Rating: 9.50 Votes: 2) Rate It
Compile all objects
- This script compile ('FUNCTION','PROCEDURE','VIEW','PACKAGE','PACKAGE BODY','TRIGGER') with status is invalid
(Added: 17-Apr-2003 Hits: 3907 Rating: 10.00 Votes: 1) Rate It