Oracle SAP/R3 FAQ

$Date: 05-Dec-1999 $
$Revision: 0.02 $
$Author: Frank Naudé $

Topics

Some of the SAP admin programs:

• BRBACKUP (backup the database)
• BRARCHIVE (backup off-line redo logs)
• BRRESTORE (restoring the database and the redo logs)
• SAPDBA (database administration. Eg: database startup and shutdown, space analysis, tablespace extensions, monitoring, reorganization, database recovery)

The easiest way to change them is using the R3INST program. The only negative consequence when SYSTEM's password is changed is that sapdba will request a password to perform most actions.

By modules, I mean applications - SD (Sales and Distribution), MM (Material Management), HR (Human Resources), FI (Financials), etc. All of these tables are initially created with 16K initial extent, 16k next extent.

The growth of 50GB a month shows that your site is probably using a lot of the modules (as one would expect with a properly used ERP app) or that there are many users with a lot of volume for a handful of modules.

Using the SAP transaction DB02, one can watch the growth of your extents and tablespace allocations.

• SAP AG Home Page

• The SAP Fan Club

• SAP-FAQ

• OraSapDba ListServ: Send a e-mail to lyris@deere.com with "subscribe orasapdba" in the body.