CCMS: Oracle

Database Administration Tasks Supported by the CCMS

You can perform most regularly-recurring database administration tasks from within the SAP System by using the DBA tools of the CCMS. As the table below shows, after installation, reorganizations and certain other tasks are the only tasks that cannot be carried out from within the SAP System.

Database Task

Executed using

Installation

Operating system

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/recovery)

Operating system (BRRECOVER)

CCMS Database Administration

The main CCMS tools for database administration are:

·        Displaying Backup Logs and Status (Transaction DB12): Check the status of database backups

·        The DBA Planning Calendar (Transaction DB13): Automatically schedule and execute database operations (for example, database backups, update statistics, and database checks)

·        Displaying DBA Logs (Transaction DB14): Access action logs created by BRSPACE, BRBACKUP, BRARCHIVE, BRCONNECT or an external program

·        The Data Archiving administration tool ( Transaction DB15): 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. See also Determining Space Information (Oracle).

·        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, non-standard 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 on Oracle database administration with the SAP System, see SAP Database Guide: Oracle.