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 Performance

Scripts sorted by Title



  1. DB Block Buffer ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script lists the state of all the DB_BLOCK_BUFFERS in the database. This sc
    Updated: 03-JUN-05

  2. DB Cache Advice ( Oracle : 9i 10g )
    SQL Script : New 9i view which details the potential benefits of increasing the buffer_pool p
    Updated: 26-MAR-05

  3. Database File Statistics ( Oracle : 7 8 8i 9i 10g )
    SQL Script : Script displays file statistics within the database. This script displays the
    Updated: 02-JUN-05

  4. Database Hit Ratios ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script calculates the database hit ratio on you database. It also displays
    Updated: 30-MAR-02

  5. Events the System is Waiting on ( Oracle : 8i 9i 10g )
    SQL Script : Excessive waits on system events can indicate disk I/O bottlenecks, network bott
    Updated: 10-JAN-03

  6. Free Memory for SGA ( Oracle : 8i 9i 10g )
    SQL Script : This script list the total memory in the shared_pool and the amount of free memo
    Updated: 30-JUL-02

  7. Free Memory for SGA ( Oracle : 7 8 8i 9i )
    SQL Script : This script list the total memory in the shared_pool and the amount of free memo
    Updated: 30-JUN-02

  8. Fully Decoded Locking Script ( Oracle : 9i 10g )
    SQL Script : Fully Decoded Locking Script
    Updated: 28-DEC-05

  9. Library Cache ( Oracle : 8i 9i 10g )
    SQL Script : Library Cache Misses indicate that the Shared Pool is not big enough to hold the
    Updated: 24-NOV-04

  10. List Unpinned Objects in DB Cache ( Oracle : 8 8i 9i 10g )
    SQL Script : List details of all packages, procedures, functions that are in the db_object_ca
    Updated: 20-MAR-02

  11. Objects in DB Cache ( Oracle : 8i 9i )
    SQL Script : List of what objects are current in the DB Cache
    Updated: 02-JUN-05

  12. Open Cursors ( Oracle : 7 8 )
    SQL Script : This script reports current open cursors ordered by the the average cost of the
    Updated: 17-JAN-99

  13. Open Cursors ( Oracle : 8i 9i 10g )
    SQL Script : This script reports current open cursors ordered by the the average cost of the
    Updated: 22-MAY-03

  14. Oracle Parallel Server Statistics ( Oracle : 7 8 8i 9i )
    SQL Script : Lists Basic File Pinging and other statistics related to Parallel Server
    Updated: 26-SEP-02

  15. Pin All Packages ( Oracle : 7 8 )
    SQL Script : Pin all packages that exist in the database above a minimum size. This script sh
    Updated: 30-JUN-99

  16. Pin All Packages ( Oracle : 8i 9i 10g )
    SQL Script : Pin all packages that exist in the database above a minimum size. This script sh
    Updated: 20-MAR-02

  17. Pin All Standard Packages ( Oracle : 8i 9i 10g )
    SQL Script : Pin all packages standard database packages. This script should be run on databa
    Updated: 20-MAR-04

  18. Recently Accessed Indexes ( Oracle : 8i )
    SQL Script : When maintaining the database, it is sometimes useful to know which indexes were
    Updated: 14-MAR-02

  19. Session Details ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script reports for each session in the database the objects accessed by the
    Updated: 20-MAR-02

  20. Session Hit Ratios ( Oracle : 7 8 8i 9i 10g )
    SQL Script : This script lists the database hit ratio for each session
    Updated: 17-JAN-99

  21. Set Session in Trace ( Oracle : 7 8 8i 9i 10g )
    SQL Script : Script displays the set session in trace command, but does not run the command
    Updated: 08-JAN-02

  22. Snapshot Of Database Performance ( Oracle : 7 8 )
    SQL Script : This script lists the key database performance indicators for a quick overview o
    Updated: 02-NOV-98

  23. Snapshot Of Database Performance ( Oracle : 8i 9i 10g )
    SQL Script : This script lists the key database performance indicators for a quick overview o
    Updated: 02-MAR-02

  24. Sort Usage ( Oracle : 8i 9i 10g )
    SQL Script : Script reports sort statistics
    Updated: 08-JAN-02

  25. Statspack Database Load Profile Script ( Oracle : 8i 9i )
    SQL Script : Displays all Load Profile statistics for many statspack snapshots in single repo
    Updated: 02-JUN-05

  26. Statspack Historical Analysis Script ( Oracle : 8i 9i )
    SQL Script : Displays all Wait statistics for many statspack snapshots in single report. T
    Updated: 02-JUN-05

  27. Statspack Historical File statistics Script ( Oracle : 8i 9i )
    SQL Script : Displays all File statistics for many statspack snapshots in single report. T
    Updated: 02-JUN-05

  28. Statspack Historical Memory Script ( Oracle : 8i 9i )
    SQL Script : Displays all Memory statistics for many statspack snapshots in single report.
    Updated: 02-JUN-05

  29. TOP CPU Users ( Oracle : 8i 9i 10g )
    SQL Script : Script displays details so the session which have used the most CPU. Needs the I
    Updated: 08-JAN-02

  30. TOP CPU Users ( Oracle : 7 8 )
    SQL Script : Script displays details so the session which have used the most CPU. Needs the I
    Updated: 08-JAN-01

  31. TOP Consistent Gets ( Oracle : 7 8 )
    SQL Script : Script displays the top consistent gets within the database - a good indicator w
    Updated: 08-OCT-02

  32. TOP Consistent Gets ( Oracle : 8i 9i 10g )
    SQL Script : Script displays the top 10 consistent gets within the database - a good indicato
    Updated: 08-JAN-02

  33. TOP Cursors ( Oracle : 7 8 )
    SQL Script : Script displays details of the sessions holding open the most cursors. It also a
    Updated: 03-OCT-02

  34. TOP Cursors ( Oracle : 8i 9i )
    SQL Script : Script displays details of the sessions holding open the most cursors. It also a
    Updated: 08-JAN-01

  35. TOP PGA Users ( Oracle : 8i 9i 10g )
    SQL Script : Scripts displays detail so the sesion which are using the most PGA (Program Glob
    Updated: 04-OCT-02

  36. TOP PGA Users ( Oracle : 7 8 )
    SQL Script : Scripts displays detail so the session which are using the most PGA (Program Glo
    Updated: 04-OCT-02

  37. TOP Physical Read Users ( Oracle : 8i 9i 10g )
    SQL Script : Script displays details so the session which have issued the most physical read
    Updated: 10-OCT-02

  38. TOP Physical Read Users ( Oracle : 7 8 )
    SQL Script : Script displays details so the session which have issued the most physical read
    Updated: 10-OCT-02

  39. TOP UGA Users ( Oracle : 8i 9i 10g )
    SQL Script : Scripts displays detail so the sesion which are using the most UGA (User Global
    Updated: 04-OCT-02

  40. TOP UGA Users ( Oracle : 7 8 )
    SQL Script : Scripts displays detail so the session which are using the most UGA (User Global
    Updated: 04-OCT-02

  41. Tables accessed Recently By Full Scan ( Oracle : 8i )
    SQL Script : Lists tables that have been recently accessed by a full table scan. This script
    Updated: 14-MAR-02

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