CCMS: Oracle
Getting Started in CCMS with Oracle DBA
The DBA Cockpit
Central System Data
Maintenance Actions in the DBA Cockpit
Displaying the Audit Log
Configuration of Systems for Remote Monitoring
Configuring Systems for Remote Monitoring Using Remote Database Connections
Configuration of Database Connections
Adding a Database Connection
Changing a Database Connection
Testing a Database Connection
Deleting a Database Connection
Configuring Systems for Remote Monitoring Using the System Landscape Directory (SLD)
The DBA Cockpit on a Local System and on SAP Solution Manager
Architecture Overview: End-to-End Monitoring and Alerting in SAP Solution Manager and DBA Cockpit
Setting Up Database Monitoring and Alerting in SAP Solution Manager
Setting Up Remote Monitoring Manually
Performance (Oracle)
SAP/Oracle Database Monitor
Performance Overview
Wait Event Analysis
Session Monitor
Buffer Busy Waits
System Event
System Event History
Filesystem Requests
Enqueue Stat
Lock Monitor
Latch Monitor
Active Session History
Workload Reporting
IO Redo Logs per Hour
SQL Statement Analysis
Shared Cursor Cache
Table Access
Column Usage
System Statistics for the CBO
Oracle Tuning Advisor
Statistical Information
SGA Monitor
PGA Monitor
Undo Statistics
Performance Database
System Metrics
System Summary Metrics
File Metrics
Wait Class Metrics
DNFS Monitor
Feature Monitoring
Automatic Segment Space Management
Online Redefinition
Resumable Space Allocation
Parallel Query
Segments with Activated Parallelism
Additional Functions
SQL Command Editor
Display GV$-Views
Display DBA Tables
Display USER Views
Database Parameters
Alert Log
Checkpoints
Oracle Net
User End to End Trace
User End to End Stats Trace
Program End to End Trace
Program End to End Stats Trace
Bundle Patches
Space (Oracle)
Space Overview
Space Statistics Collector
Database Overview
Users Overview
Users Detailed Analysis
Tablespaces Overview
Tablespaces Detailed Analysis
Segments Overview
Segments Detailed Analysis
Segments Detailed Analysis (Aggregated)
Collector Logs
BW Analysis
Jobs (Oracle)
Central Calendar
Using the Central Calendar
DBA Planning Calendar (Oracle)
Setting Up the DBA Planning Calendar (Oracle)
Configuring the Back End of the DBA Planning Calender (Oracle)
Scheduling an Action (Oracle)
Changing an Action (Oracle)
Deleting an Action (Oracle)
Re-Executing an Action (Oracle)
Displaying the Status of a Day's Actions (Oracle)
Displaying Scheduled Actions (Oracle)
Troubleshooting (Oracle)
Displaying DBA Logs (Oracle)
Display of the Backup Logs (Oracle)
Displaying Logs for Database Backups (Oracle)
Displaying Logs for Redo Log Backups (Oracle)
Displaying the Recovery Report (Oracle)
Database System Check
Configuring Database System Check (Oracle)
Displaying Alert Messages from Database System Check
Update Statistics for the Cost-Based Optimizer in CCMS (Oracle)
Updating Statistics in the DBA Planning Calendar (Oracle)
Updating Statistics for a Single Table (Oracle)
Updating Statistics for Groups of Tables in CCMS (Oracle)
Configuring Update Statistics in CCMS (Oracle)
Maintaining Database Parameters (Oracle)
Monitoring the Oracle Database
Space Management Alerts
Database Performance Alerts
Database Backup and Restore Alerts
Database Consistency Alerts
Database Health Alerts
Information on Oracle Database Alerts