Monitoring

Oracle ADRCI is the command line interface for Automatic Diagnostic Repository used for viewing diagnostics data like listener log , alert log ,incident and core… Read More »Oracle ADRCI Commands

Managing Automatic Diagnostic Repository Log and Trace Files Use the managelogs command to manage Automatic Diagnostic Repository log and trace files. The -purge command option removes files managed by… Read More »Manage Automatic Diagnostic Repository Log and Trace Files

Oracle Hang Manager autonomously resolves hangs and continuously logs the resolutions in the database alert logs and the diagnostics in the trace files. Oracle Hang… Read More »Using Oracle Hang Manager

Oracle data dictionary views, also known as catalog views, let you monitor the state of the database in real time: The USER, ALL, and DBA, views show information… Read More »Oracle Data Dictionary Views

Real-Time SQL Monitoring reports are available from three locations: Enterprise Manager – Click the “Performance” tab, then the “SQL Monitoring” link at the bottom-right of… Read More »Using Real-Time SQL Monitoring Reports

Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle… Read More »Using Oracle Trace File Analyzer (TFA)

Oracle ORAchk is a tool similar to the RACchk and Exadata Exachk tools, which offer database and clusterware, patchware, patch, OS recommendations and best practices. … Read More »Database Health Check with Oracle ORAchk