CCMS: OracleLocate this document in the navigation structure

Use

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 Data Archiving administration tool (DB 15): Determine the archiving objects for a specific table or determine the tables that a specific archiving object archives. Display various statistics for the amount of used database space.

  • 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

  • The DB Operations Monitor (Transaction DB24): Online monitoring of database operations (for example, data backups, database checks, and so on)

  • 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: Detailed database performance information and histories

For more information about Oracle database administration with the SAP System, see SAP Database Guide: Oracle.