| Menu function | Description |
|---|
| > DBA general | |
| Start page | Show global information for choosen database |
| Dashboard | Show dashboard with current performance aspects |
| > DB-Locks | |
| Current | shows current locking state incl. blocking sessions |
| Blocking locks historic from ASH | Show historic blocking locks information from Active Session History |
| Blocking locks historic from Panorama-Sampler | Show historic blocking locks information from Panorama-Sampler |
| > Redo-Logs | |
| Current | Show current redo log info from gv$Log |
| Historic from gv$Log_History | Show detailed historic redo log info from gv$Log_History |
| Historic from AWR | Show historic redo log info from Active Workload Repository (AWR) |
| Sessions | Show info of current DB-sessions |
| > Database configuration | |
| Init-Parameter | Show init-parameters of instance(s) |
| Resource limits | Show resource limits from gv$Resource_Limit |
| Optimizer hints | Show supported optimizer hints for this database |
| > User management | |
| Database users | Show database users (DBA_Users) |
| Roles | Show database roles (DBA_Roles) |
| System privileges | Show system privileges (DBA_Sys_Privs) |
| Object privileges | Show object privileges (DBA_Tab_Privs) |
| > Audit Trail | |
| Auditing rules | Show rules for standard and fine grain auditing |
| Standard audit trail + FGA | Show activities logged by standard audit trail and fine grain auditing (DBA_Common_Audit_Trail) |
| Unified audit trail | Show activities logged by unified audit trail |
| > Server Files | |
| Server Log Files | Show content of server logs (alert.log, listener.log, ASM-log) |
| Server Trace Files | Show trace files of DB server |
| Database Triggers | Show global database triggers (like LOGON etc.) |
| > Scheduled Jobs | |
| Autotask jobs | Show jobs from DBA_Autotask_Client |
| Scheduler jobs | Show jobs from DBA_Scheduler_Jobs |
| Feature usage | Statistics about usage of features and packs of Oracle-DB |
| Upgrade/patch history | History of upgrades / downgrades / patches |
| > Analyses / statistics | |
| > Session-Waits | |
| Current | All current session waits |
| Historic | Prepared active session history from DBA_Hist_Active_Sess_History |
| CPU-Usage / DB-Time | Historic CPU-Usage and DB-Time from DBA_Hist_Active_Sess_History.
Shows you the difference between real CPU-usage and waiting for CPU
if you don't have Resource Manager activated.
Difference means you have more sessions waiting for CPU than your system's number of CPU-cores. |
| Long-term trend | Long-term trend recording of session waits |
| > Segment Statistics | |
| Current | Current waits by DB-objects |
| Historic | Historic values (waits etc.) by DB-objects |
| > System-Events | |
| Current | Current system events |
| Historic | Historic system events |
| > System statistics | |
| Historic | Historic system statistics |
| > System metric | |
| Historic | Historic system metric from DBA_Hist_Sysmetric_History |
| > Latch statistics | |
| Historic | Calculated historic info from DBA_Hist_Latch |
| > Mutex statistics | |
| Historic | Prepared historic information based on GV$Mutex_Sleep_History (since last start of instance) |
| > Enqueue statistics | |
| Historic | Calculated historic info from DBA_Hist_Enqueue_Stat |
| RAC Blocking Enqueue | Blocking enqueue locks known by RAC lock-manager |
| > OS statistics | |
| Current | Current statistics of operating system from gv$OSStat |
| Historic | Historic statistics of operating system from DBA_Hist_OSStat |
| > Genuine Oracle reports | |
| Performance Hub | Genuine Oracle performance hub report by time period and instance |
| AWR report | Genuine Oracle active workload repository report by time period and instance |
| AWR global report (RAC) | Genuine Oracle active workload repository global report for RAC by time period and instance (optional) |
| ASH report | Genuine Oracle active session history report by time period and instance |
| ASH global report (RAC) | Genuine Oracle active session history global report for RAC by time period and instance (optional) |
| > RAC related analysis | |
| GC Request Latency historic | Analysis of global cache activity |
| Dynamic Remastering (DRM) events historic | History of master role changes for DB-objects between RAC-instances |
| > Special event analysis | |
| Latch: cache buffer chains | Current reasons for 'cache buffer chains' latch-waits |
| db file sequential read | Current reasons for 'db file sequential read' waits (Attention: large response time at large systems) |
| > Schema / Storage | |
| Disk-storage summary | Overview over disk space/tablespace usage by schema |
| Datafile-usage | Show data-files of DB |
| > UNDO-TS | |
| Undo segments summary | Current usage of undo space by segments |
| Active transactions | Current active transactions |
| Undo usage historic | Historic usage of UNDO space |
| Tablespace-Objects | DB-objects by size, utilization and wastage |
| Object size evolution | Evolution of object sizes in considered time period |
| Describe object | Describe database object (table, index, materialized view ...) |
| Invalid objects | List invalid objects (from DBA_Objects and DBA_Indexes) |
| Recycle bin | Show content of recycle bin |
| Materialized view structures | Show structure of materialzed views and MV-logs |
| Table-dependencies | Direct and indirect referential dependencies of tables |
| > Temp usage | |
| Current | Current usage of TEMP-tablespace |
| Historic from SysMetric | Historic usage of TEMP tablespace from system metrics of AWR snapshots (down to sampling once per minute) |
| Historic from ASH | Historic usage of TEMP tablespace by active sessions from Active Session History (down to sampling once per second) |
| > EXADATA-specific | |
| Cell server config | Configuration of exadata cell server |
| Cell server physical disks | List physical disks of exadata cell server |
| Cell server cell disks | List configured cell disks of exadata cell server |
| Cell server grid disks | List configured grid disks of exadata cell server |
| Object by file and block no. | Determine object-name by file- and block-no. |
| > I/O analysis | |
| I/O-Stat detail history | I/O history based on DBA_Hist_IOStat_Detail |
| I/O-Stat filetype history | I/O history based on DBA_Hist_IOStat_FileType |
| I/O history by files | I/O history by files based on DBA_Hist_FileStatxs |
| > SGA/PGA-Details | |
| > SQL-Area | |
| Current SQLs (SQL-ID) | Analysis of current SQL in SGA at level SQL-ID (cumulated across child-cursors) |
| Current SQLs (SQL-ID / child-no.) | Analysis of current SQL in SGA at level SQL-ID, child-no. |
| Historic SQLs | Analysis of historic SQL from DBA_Hist_SQLStat |
| SQL-Monitor reports | Show recorded SQL-Monitor reports from gv$SQL_Monitor and DBA_HIST_Reports |
| SQL-Area day comparison | Comparison of SQL-statements from two different days |
| > SGA Memory | |
| SGA-components current | Show components of current SGA |
| SGA-components historic | Show history of components of SGA |
| SGA resize operations historic | Show historic evolution of SGA resize operations |
| > DB-Cache | |
| DB-cache usage current | Current content of DB-cache |
| DB-cache advice | Historic view on what-happens-if-analysis for change of cache size |
| DB-cache usage historic | Historic view on DB-cache usage by Panorama_Cache_Objects |
| > Object usage by SQL | |
| Current | Usage of given objects in explain plan of current SQLs in SGA |
| Historic | Usage of given objects in explain plan of historic SQLs |
| > PGA-statistics | |
| Current | Show current PGA-usage |
| Historic from DBA_Hist_PGAStat | Historic usage of PGA memory from DBA_Hist_PGAStat |
| Historic from ASH | Historic usage of PGA memory by active sessions from Active Session History (down to sampling once per second) |
| > Result Cache | |
| Current | Show current usage of result cache |
| SQL plan management | Show all SQL plan management directives of database:
- SQL profiles
- SQL plan baselines
- Stored outlines
- SQL translations
- SQL patches |
| > Compare execution plans | |
| in current SGA | Compare execution plan of two different cursors in SGA |
| in historic AWR data | Compare two execution plans from AWR history |
| > Spec. additions | |
| Dragnet investigation | Dragnet investigation for performance bottlenecks |
| Execute with given parameters | Execute one of Panoramas functions directly with given parameters |
| SQL worksheet | SQL worksheet for executing and explaining SQL statements |
| Admin login | Login with master password to activate additional admin functions |
| > Admin | |
| Panorama-Sampler config | Configure target databases for Panorama-Sampler |
| Set log level | Set the log level of Panorama server process |
| DB connection pool | Show current DB connections in connection pool and server threads of Panorama |
| Usage history | Show history of Panorama usage by users |
| Server cache store sizes | Show sizes of server-side cache store in folder client_info.store |
| Admin logout | Logout from admin functions |