Oracle ebusiness consultants and dbas

Search Site
About Think Forward
Contact Think Forward
Proactive Low Cost Database Support
Reactive Low Cost Database Pay Per Incident Support
Creative Solutions and Independent Advice from our expert consultants
Oracle High Availability Consultancy Services
Fast Forward Training
Professional Oracle Build Services
Revive your poorly database with an Oracle Health Checkup
Low Cost Oracle Development
Think Forward Home Page

Oracle Certified Professional

E-Mail Us and make cost savings on Oracle databases

info@think-forward.com

Oracle DBA Scripts and Tips

It has come to our attention that an Oracle Development company have copied our scripts without our permission and are using them as part of their own products for which they are charging users a license fee.

As a result of this, we have decided to suspend access to our DBA scripts until further notice and we regret the impact that this decision will inevitably have upon genuine users of the scripts repository.

We are continuing to monitor the situation and would encourage you to check back in the future for developments.

Script Home Utilities

Scripts sorted by Title



  1. Amended sqlplus GLogin Script ( Oracle : 8 8i 9i )
    SQL Script : This glogin scripts includes the SID name and the database username you are logg
    Updated: 02-JUN-05

  2. Check Grid Control Blackout Details ( Oracle : 10g )
    SQL Script : Use this to debug any Grid Control Blackout problems
    Updated: 28-DEC-05

  3. Compare Two Databases ( Oracle : 7 8 8i 9i )
    SQL Script : Ever done a full database import to make a copy of a database and found that the
    Updated: 28-SEP-01

  4. Connect as another user ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script allows you to change to connect to another schema from any DBA datab
    Updated: 01-JUN-98

  5. Count Partition Rows ( Oracle : 7 8 )
    SQL Script : Displays each individual table partition row counts.
    Updated: 30-JAN-02

  6. Count Table Rows ( Oracle : 8i 9i 10g )
    SQL Script : This script lists the number of rows in all tables for a given schema. Can be us
    Updated: 28-SEP-02

  7. Count Table Rows ( Oracle : 7 8 )
    SQL Script : This script lists the number of rows in all tables for a given schema. Can be us
    Updated: 01-JUN-98

  8. Data Pump through PLSQL Example ( Oracle : 10g )
    SQL Script : Example script to run Data Pump through PLSQL
    Updated: 02-JUN-05

  9. DataPump Monitor ( Oracle : 10g )
    SQL Script : This script displays active 10g Data Pump Sessions
    Updated: 19-MAR-05

  10. Database Documentor ( Oracle : 7 8 8i 9i )
    SQL Script : This displays table and column comments. Useful for a quick summary of databases
    Updated: 28-MAR-02

  11. Database Information ( Oracle : 7 8 )
    SQL Script : Basic Database details - useful to put in as part of a glogin.sql script if you
    Updated: 28-FEB-01

  12. Database Information ( Oracle : 10g )
    SQL Script : Basic Database details - useful to put in as part of a glogin.sql script if you
    Updated: 28-MAR-05

  13. Database Information 9i ( Oracle : 9i )
    SQL Script : Basic Database details - useful to put in as part of a glogin.sql script if you
    Updated: 02-JUN-05

  14. Database Layout ( Oracle : 8i 9i 10g )
    SQL Script : This query lists the physical location of datafiles, controlfile , online redolo
    Updated: 30-JUL-02

  15. Database Layout ( Oracle : 7 8 )
    SQL Script : This query lists the physical location of datafiles, controlfile and redologs co
    Updated: 06-JUN-00

  16. Database Scheduler ( Oracle : 10g )
    SQL Script : Details Job Windows and Jobs in the 10g Scheduler.
    Updated: 20-MAR-05

  17. Database Uptime ( Oracle : 7 )
    SQL Script : Simple Script to display the database uptime i.e. How long the database has been
    Updated: 06-JUN-00

  18. Database Uptime ( Oracle : 8 8i 9i 10g )
    SQL Script : Simple Script to display the database uptime i.e. How long the database has been
    Updated: 27-MAR-02

  19. Database User Account Listing ( Oracle : 8i 9i 10g )
    SQL Script : This script lists the database user details and their status.
    Updated: 20-MAY-03

  20. Disable All Database Triggers ( Oracle : 8i 9i 10g )
    SQL Script : This script disables all database triggers. If you are supporting a database tha
    Updated: 03-APR-02

  21. Disable All Database Triggers ( Oracle : 7 8 )
    SQL Script : This script disables all database triggers. If you are supporting a database tha
    Updated: 01-JUN-98

  22. Display Data Dictionary Descriptions ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script displays the name and description of all tables matching the search
    Updated: 31-DEC-02

  23. EPOC Date ( Oracle : 7 8 8i 9i )
    SQL Script : This converts a UNIX epoc date into a normal date. This is useful for third part
    Updated: 06-JUN-00

  24. Enable All Database Triggers ( Oracle : 7 8 )
    SQL Script : This script enable all database triggers. If you are supporting a database that
    Updated: 01-JUN-98

  25. Enable All Database Triggers ( Oracle : 8i 9i 10g )
    SQL Script : This script enable all database triggers. If you are supporting a database that
    Updated: 01-APR-02

  26. End Backup Script ( Oracle : 8 8i 9i 10g )
    SQL Script : IF a hot backup script fails for some reason, the tablespaces will still be in h
    Updated: 10-JAN-03

  27. Explain Plan ( Oracle : 7 )
    SQL Script : Explain Plan for Version 7 Databases of Oracle
    Updated: 02-JUN-05

  28. Explain Plan Template ( Oracle : 8 8i 9i 10g )
    SQL Script : The old faithful explain plan script. No Oracle professional should be without i
    Updated: 21-MAR-05

  29. Generate Create Rollback Script ( Oracle : 9i 10g )
    SQL Script : This script generates a create rollback segment script. It is especially useful
    Updated: 14-MAR-04

  30. Generate Create Rollback Segments ( Oracle : 7 8 8i )
    SQL Script : Crerate the syntax for recreating rollback segments
    Updated: 19-JUL-04

  31. Generate Create Tablespace Script ( Oracle : 7 8 )
    SQL Script : This script generates a create tablespace script from an existing database. It i
    Updated: 26-NOV-98

  32. Generate Create Tablespace Script ( Oracle : 9i 10g )
    SQL Script : This script generates a create tablespace script from an existing database. It i
    Updated: 24-NOV-04

  33. Generate Create Tablespace Script ( Oracle : 8i )
    SQL Script : This script generates a create tablespace script from an existing database. It i
    Updated: 19-JUL-04

  34. Generate Object DDL ( Oracle : 9i 10g )
    SQL Script : This script uses the DBMS_METADATA package tp generate the DDL of the majority o
    Updated: 24-NOV-04

  35. Logminer Script ( Oracle : 9i )
    SQL Script : Simple Logminer script to analyze one log file
    Updated: 03-JAN-03

  36. Logminer Script ( Oracle : 9i 10g )
    SQL Script : Simple Logminer script to analyze one log file
    Updated: 03-JAN-03

  37. Number Of CPUS ( Oracle : 7 8 8i 9i 10g )
    Shell Script : A UNIX platform independent script which displays the number of CPUS on a server
    Updated: 24-NOV-04

  38. Oracle 10G Grid Control Management Repository Health Check ( Oracle : 10g )
    SQL Script : Script to report on the health of the management repository in Grid Control
    Updated: 02-JUN-05

  39. Random Number Generator ( Oracle : 8i 9i 10g )
    SQL Script : This script contains 3 useful functions for generating random numbers, string an
    Updated: 28-FEB-03

  40. Show Average Row Length ( Oracle : 10g )
    SQL Script : This script prompts for a table and then calculates the average row length. This
    Updated: 03-APR-02

  41. Show Average Row Length ( Oracle : 7 8 )
    SQL Script : This script prompts for a table and then calculates the average row length. This
    Updated: 06-JUN-00

  42. Show Average Row Length ( Oracle : 9i )
    SQL Script : Calculates the average row lenth for tables.
    Updated: 19-JUL-04

  43. Size System Global Area ( Oracle : 8i 9i 10g )
    SQL Script : This script will calculate the size of the SGA of an existing database based upo
    Updated: 03-APR-02

  44. Size System Global Area ( Oracle : 7 8 )
    SQL Script : This script will calculate the size of the SGA of an existing database based upo
    Updated: 03-NOV-98

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links