BASIS lesson 5

How to maintain the database ?

/ndb02 Database Management (beware, it takes a lot of time)
in my system which uses ORACLE, contains more than 40.000 tables with the size of more than 38 GB.

on Tab "Tables and indexes", press the button [Detailed analysis], Then continue to see a sample table LFA1 (Vendor Master) with the total size 750 kB.
on Tab "Tables and indexes", press the button [Space Statistics] to see the growth in month, day, year basis.

/ndb13 Database Administrator (DBA) Planning Calendar for Oracle Database to plan backup and archieve

DATABASE LOG

/ndb12 DATABASE BACKUP LOG

/ndb14 DISPLAY DBA OPERATIONS LOG (give options)

/ndb24 LOGS FOR ADMINISTRATIVE DATABASE OPERATIONS (show all)

DATABASE CHECK

/ndb16 DATABASE CHECK, display warnings and errors when you run /ndb13

/ndb17 ALL DATABASE CHECK CONDITIONS

PARAMETERS CHANGE

/ndb03 PARAMETERS CHANGES IN DATABASE

/ndb26 ALL DATABASE PROFILE PARAMETERS


All SAP products are trademark of SAP AG. This blog is not affiliated with nor endorsed by SAP AG.