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 RMAN Backup Status Check
Query RMAN backup history to verify last successful backup, backup type, and duration from V$RMAN_BACKUP_JOB_DETAILS.
Read MoreOracle User Privileges Report
List all system and object privileges granted to Oracle database users, including role memberships and admin options.
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 More