SAPDBA for Oracle
Use
SAPDBA for Oracle is an integrated database administration tool for Oracle databases running with R/3 Systems, particularly large ones. You can use it without detailed knowledge of the database and its tools. It filters information about the database, showing you only what you need, and uses complex database statements to let you confidently manipulate the data while ensuring security and integrity.
SAP recommends you to use SAPDBA rather than the Oracle tools, because it is designed to run with R/3 databases. SAPDBA runs at operating-system level, allowing you to perform database administration tasks that are not possible when the database is running.
Integration
The following SAPDBA functions are also available in the Computing Center Management System (CCMS) of the R/3 System:
There are some tasks that can only be performed in CCMS (for example, scheduling backups).
When the R/3 System is running, you can use CCMS to access some of the same information (but not all) found in SAPDBA. Whether to use SAPDBA or CCMS depends on the task you want to perform, and the setup of your system.
Prerequisites
For more information about setting up SAPDBA, see
SAPDBA Configuration.Features
Activities
We recommend you to implement SAPDBA if you want to perform a wide range of database administration tasks, which are more difficult or unavailable with other tools: