My Essential Oracle Scripts
Find Long Running Sessions
Identify sessions consuming excessive time.
Check Tablespace Usage
Monitor space usage for all tablespaces.
List All Users
Get a comprehensive list of all database users.
Kill Session by SID/Serial#
Terminate an active database session.
Database Instance Info
Retrieve general information about the database instance.
Tablespace Datafile Information
View details about datafiles within tablespaces.