List All Active Sessions in Oracle
Query V$SESSION to list all active database sessions with username, status, machine, and SQL being executed.
Read MoreOracle Tablespace Usage Report
Monitor Oracle tablespace usage, free space, and percentage used with DBA_TABLESPACES and DBA_FREE_SPACE views.
Read MoreOracle RMAN Backup Status Check
Query RMAN backup history to verify last successful backup, backup type, and duration from V$RMAN_BACKUP_JOB_DETAILS.
Read MoreTop SQL Queries by CPU Usage
Identify the most CPU-intensive SQL queries in Oracle using V$SQL. Essential for performance tuning and bottleneck detection.
Read MoreOracle User Privileges Report
List all system and object privileges granted to Oracle database users, including role memberships and admin options.
Read MoreOracle Long Running Queries Monitor
Detect queries running longer than expected using V$SESSION_LONGOPS. Shows estimated completion time and progress percentage.
Read MoreOracle Database Size Report
Calculate total Oracle database size, data file sizes, and segment space usage from DBA_SEGMENTS and DBA_DATA_FILES.
Read MoreFind Duplicate Records in Oracle SQL
Identify duplicate records using GROUP BY, COUNT, and HAVING with reusable query examples. Safe for large tables with proper indexing.
Read More