| Script Name | Description |
|---|
| bytes.sql | Show a bytes value as kilobytes, MB and GB. |
-->
| acl.sql | Access Control List setup. |
| addm.sql | Show the results of the latest ADDM run(s) |
| asp.sql | Show users who have access to a defined system privilege. |
| audits.sql | Show current Oracle audit settings |
| autotask.sql | Show automatic tasks. |
| ccount.sql | Generates sql to return a schema's table name and total number of records. |
| close_dbl.sql | Closes any database links open in the session. |
| cstrings.sql | Compare two strings. |
| dpds.sql | Dependency chain. |
| ds.sql | Displays segment data for owner/name/object type and/or tablespace. |
| elink.sql | Takes an input statement and creates copies using all database links in the users' schema. |
| f_sp.sql | Free and used space for tablespaces. |
| findit.sql | Creates DML to interrogate tables holding specific data in a named column |
| gvlatch.sql | Show latch contention (from gv$latch) with miss > 0. |
| icols.sql | Displays table indexes and columns for a given owner. |
| in_source.sql | Searches DBA_SOURCE for a given text string |
| invaln.sql | List invalid objects. |
| io.sql | Input/output statistics over a thirty second period. |
| jbs.sql | List current jobs and their statuses. |
| listcode.sql | Lists code between two line-numbers entered; useful for identifying where an error is happening when logged using dbms_utility.format_error_backtrace() |
| meta.sql | Extracts the DDL for creating an object, e.g. table, view, trigger. Uses dbms_metadata.get_ddl |
| recomp.sql | Create DDL to recompile invalid objects. |
| recov.sql | Show recovery details, e.g. archive logs etc. |
| rmans.sql | Show rman backup history. |
| sess.sql | Session listing. |
| sga_general.sql | General overview of SGA settings and movement. |
| sga_search.sql | Shows sql in the SGA for a given username/SID |
| soa.sql | Search all objects based on partial input values for owner, type, name and/or id. |
| sql_id.sql | Shows DML and explain plan for a given SQL_ID. |
| tf.sql | Tablespace files; all files for a tablespace. |
| the_needful.sql | For use when asked to 'Do the needful'. |
| tlinks.sql | Table links: structure, primary and foreign keys, unique constraints, triggers etc. |
| topsql.sql | Returns top n number of SQL statments based on an entered sort order. |
| trans.sql | Shows current transaction data, including start time, run time, undo records used blocks, program etc. |
| udets.sql | Expanded user details, including system privileges and tablespace quotas. |
| uo.sql | Lists basic details of user accounts, short for 'user only'; see udets.sql for a more detailed user report. |
| uobjects.sql | Show summary of number of objects in schemas. |
| v.sql | Display data from a select statement vertically. |
| waits.sql | Waits by session. |