Home | Consulting | Resume | Whitepapers | Scripts | Sandbox
Contact Info  
  Scripts: Oracle Performance and Other
Older Performance Tools
There was a time when I created a number of free and commercial Oracle Performance Tuning tools and scripts, like the ones shown below.

Unfortunatley, these tools are no longer available.

A few sites that might be a good place to visit for help are TOADSoft and OraFAQ.

allen hayden oracle

allen hayden oracle database

allen hayden oracle performance psl


  • An API for Dynamic User-Defined Queries and Updates In Oracle
  • An Enhancement to Recompiling Invalid Oracle Database Objects
  • Analyzing Free Space in Oracle Tablespaces Over Three Months
  • Automated Oracle Data-Copying Utility for complex RI-Driven Environments
  • Automatically Adjustment Oracle Sequences In User Schema
  • Automating an Oracle Cold Backup When Running Peoplesoft HRMS
  • Oracle Autonomous Transactions
  • Oracle Available Object Space
  • Avoiding ORA-1555 Error When Deleting Large Oracle Tables
  • Backing Up Oracle Archive Logs to ADSM
  • Oracle Bulk Binds
  • Calculating the Average Row Size in Oracle
  • Catching Run-Time or User-Defined Oracle Errors
  • Checking Parent Columns for Child Table,R_Constraints in Oracle
  • Comparing Data in Two Oracle Schemas
  • Converting Multiple Formats String Dates to Y2K Compliant Dates
  • Converting Oracle Numbers To Hex
  • Creating An Oracle Tablespace Summary Report
  • Creating a DDL Script for Foreign Key Constraints in A Schema
  • Data Transfer Between Oracle Schema
  • Debugging Package for Oracle External Procedures
  • Determining Oracle Free Space for a Next Extent
  • Determining Oracle Instance Duration Time
  • Determining Which Oracle Objects Are Low on Extents
  • Displaying User Constraints and Indexes Reports
  • Dropping Oracle Database Objects
  • Dynamically Executing "Create Tables"
  • Dynamically Setting the Transaction to Use the Largest Rollback Segment
  • Eliminating Duplicate Rows From Large Oracle Tables
  • Enable Oracle SQL Trace for a Session Other Than Your Own
  • Exporting Oracle Table Data to SQL*Loader Files
  • External Procedures
  • External Procedures "C"
  • Filling Your Small Free Extents
  • Finding the Non-Indexed Foreign Keys
  • Full User Details for Oracle Applications
  • Generating CREATE USER DDL Statements
  • Generating DDL to Recompile Invalid Database Objects
  • Generating Oracle Index Re-creation Schema
  • Generating Matrix & Nested Matrix Reports Using SQL Script
  • Generating Remote or Distributed Database Reports
  • Getting Entity and Attribute Relationships Without ER Software
  • Global Update of Numeric/Character Fields which are part of primary/foreign keys
  • Idea On Managing Oracle Log Files
  • Identifying Locks Based on the Session's SQL Addresses
  • Invoker-Rights Programs
  • Listing Memory Used By All Oracle Sessions
  • Mapping Physical UNIX Devices and Oracle Datafiles
  • Mapping Roles
  • Migrating a Oracle Database to New Mount Points
  • Monitoring Growing Rollback Segments
  • Native Dynamic SQL in Oracle PL/SQL
  • Nocopy Modifier
  • Note on Speeding up Oracle Triggers
  • Observing Occupied and Free Space of Tablespaces
  • Procedure For Estimating Table Size
  • Producing Owner's Data Dictionary
  • Profiler Example
  • Profiler Utilities
  • Rebalancing Oracle Indexes
  • Rebuilding Indices Rather Than Re-creating Them
  • Reclaiming Unused Space
  • Recompiling Objects
  • Recreating Indexes for Schema in Another Tablespace
  • Recreating Referential Constraints that Refer to a Table
  • Releasing Exclusive Locks and Killing Sessions From Oracle
  • Renaming an Oracle Table Column
  • Reorganizing the Indexes to a Different Tablespace
  • Report of Database Tables, Indexes, and Constraints
  • Reporting Oracle Index Storage Usage
  • Resetting Oracle Sequences To One
  • Oracle Rollback Segment User/Transaction
  • Schema Builder, Reverse Engineering
  • Schema Cleaner
  • Sequencing Object Dependencies
  • Showing Table Privileges For Users and Roles
  • Speeding Up Drop User
  • Oracle Tablespace Growth Analysis
  • Oracle Tablespace Saturation Alert
  • Testing Compressed Export Backups
  • Tricks for Faster Database Export to Tape on UNIX
  • Truncate a Table From a PL/SQL Program
  • User Activity at a Glance
  • Using Views, PL/SQL Functions and Forms Field Properties To Reduce Network Traffic
  • Viewing Critical Object Extents
  • Viewing an Oracle Datafile Usage With an ASCII Graph
  • Viewing Disk I/O For Each Datafile
  • Viewing Oracle Free Space, Largest Extent, and Fragment Info In One Report
  • Viewing The SQL Statement Of The CPU-Intensive Oracle Processes
  • Viewing the Dependency Tree
  • © Copyright 1998 - 2009 Allen Hayden. All rights reserved.