Monitoring
How to check the database character set and NLS parameters in Oracle
Show every Oracle database-wide NLS parameter (character set, sort order, date format, currency) from NLS_DATABASE_PARAMETERS.
How to check the diagnostic destination in Oracle
Show every path Oracle writes diagnostic content to (ADR base, alert log, trace, incident, dumps) from V$DIAG_INFO.
How to check session and process resource limits in Oracle
Check current vs max sessions and processes against the configured init.ora limits — current, RAC-aware, and historical from AWR.
How to check CPU and memory info in Oracle from V$OSSTAT
Show the number of CPUs, cores, sockets, and physical memory Oracle sees from V$OSSTAT.
How to check database link info in Oracle
Show open Oracle database links with owner id, heterogeneous flag, open cursors, and transaction status from GV$DBLINK.
How to check Oracle feature usage statistics
List Oracle database features that have been detected as used, from DBA_FEATURE_USAGE_STATISTICS — the same source Oracle License Management uses.
How to check the database GLOBAL_NAME in Oracle
Show the Oracle database GLOBAL_NAME from the GLOBAL_NAME view — the database identifier used for database links and Data Guard.
How to check long-running operations in Oracle
Show currently running long operations in Oracle from V$SESSION_LONGOPS with elapsed, remaining, and percentage progress.
How to check the Oracle Database version
Show every component version banner from V$VERSION to identify the exact Oracle build.
How to check Oracle instance uptime
Show Oracle instance name and startup time from V$INSTANCE.
How to check session count per hour from ASH in Oracle
Pivot Oracle session counts by hour from V$ACTIVE_SESSION_HISTORY for the last ~1 hour of in-memory samples.
How to check historical session count per hour from AWR in Oracle
Pivot Oracle distinct session counts by day and hour from AWR active session history to see daily load patterns.