-check (SAP Library - Database Administration (Oracle) with SAPDBA)

-check

Makes a database system check, covering the following aspects:

Space monitoring (fill and fragmentation)

Monitoring of Oracle alert messages

Check on the init.ora profile parameters

Physical consistency (availability of data files, control files and redo log files)

Check on certain problem situations, based on SAP’s experience in administrating R/3 databases

You can view the results of the database check in the logs under sapcheck/<timestamp>.chk.

Use the option sapdba -check -e <no._of_extents> to adjust the default number of extents (2), for checking the tablespace overflow. However, you should make individual adjustments to the database system check in the table DBCHECKORA (transaction DB17) in R/3 CCMS.

Start the database system check function weekly, if possible as a background process. For more information, refer to Using the DBA Planning Calendar: Oracle.

When you start SAPDBA with a command option (which does not invoke the SAPDBA initial menu), you can use the operating system to substitute the password by reading a data file. Then the password does not appear in the process list of the operating system.
Example: sapdba -check -l system < <file_name>
The file <file_name> contains the password.

For more information, see Checking the Database System and Configuring the Database System Check.