4 posts tagged with "Oracle"

Diagnostic queries for finding and resolving Oracle locks on the current session and across the database.

Queries to inspect Oracle database size by tablespace and identify fragmented space per schema.

How to export, transport and reimport an Oracle SQL profile between databases.

Practical PL/SQL recipes for gathering, restoring and managing Oracle optimizer statistics.