CCMS: Oracle 
You can perform most regularly-recurring database administration tasks from within the SAP System by using the DBA tools of the CCMS. After installation, reorganizations and certain other tasks are the only tasks that you cannot perform from within the SAP System, as shown in the following table:
Database Task |
Executed Using |
|---|---|
Installation |
SAPinst on operating-system level |
Data backup Backup database files and redo log files |
SAP (CCMS), operating system (BRARCHIVE, BRBACKUP) |
Performance optimizing Monitor and optimize database performance |
SAP (CCMS), operating system |
Access optimizing Configure cost-based optimizer, create and update statistics |
SAP (CCMS), operating system (BRCONNECT) |
Monitoring Monitor database using alert monitor, check database and DBA action logs |
SAP (CCMS), operating system (BRCONNECT) |
Check Analyze space (number of objects, fragmentation, bottlenecks), check configuration (control file, online redo log files, INIT.ORA parameters) |
SAP (CCMS), (BRCONNECT) |
Reorganization Reorganize tables |
Operating system (BRSPACE) |
Other tasks For example, database recovery (restore and recovery) |
Operating system (BRRECOVER) |
Features
The main CCMS tools for database administration are:
Display of the Backup Logs (in the DBA Cockpit): Check the status of database backups
The DBA Planning Calendar (in the DBA Cockpit): Automatically schedule and execute database operations (for example, database backups, update statistics, and database checks)
Displaying DBA Logs (in the DBA Cockpit): Access action logs created by BRSPACE, BRBACKUP, BRARCHIVE, BRCONNECT or an external program
The Database System Check (Transactions DB16 and DB17): Configure and check important database parameters to be able to recognize critical database situations in time.
Update Statistics (Transactions DB20 and DB21): Configure the cost-based optimizer, and check and update optimizer statistics
Online Maintenance of Database Parameters (Transaction DB26): Details and history of database parameters
Maintaining Database Connection Information (Transaction DBCO): Information about additional, nonstandard database connections
The SAP/Oracle Database Monitor (New): Detailed database performance information and histories
The SAP/Oracle Database Monitor (Old): Detailed database performance information and histories
For more information about Oracle database administration with the SAP System, see SAP Database Guide: Oracle.