SQL & Database
Practical Oracle SQL scripts, metadata queries and everyday database administration resources.
Practical SQL for everyday database work
A collection of reusable queries and database utilities for investigation, administration and troubleshooting.
Session Activity
Queries for reviewing active sessions, users, status, wait information and current database activity.
ExploreTablespace Information
Useful queries for reviewing tablespaces, datafiles, allocated space and database storage.
ExploreDatabase Objects
Metadata queries for schemas, tables, indexes, invalid objects and other database structures.
ExploreSQL Investigation
Practical queries for investigating SQL activity, execution information and database workload.
ExploreDBA Utilities
Everyday database administration queries and operational checks for Oracle environments.
ExploreDatabase Diagnostics
Queries that help establish what is happening inside an Oracle database before deeper investigation.
ExploreMore database resources will be added over time.
The SQL toolbox will grow with reusable Oracle queries, scripts, troubleshooting utilities and operational resources developed from real-world database work.
Back to Tools