Most Basis jobs are related with database server. Whether you’re using Microsoft SQL server from Microsoft, Oracle Database from Oracle, DB2 Universal Database from IBM or SAPDB from MySQL AB, all your job are facing with them closely.
SAP are design its database very complex and beatiful. SAP also develop database tools to accompany you as Basis in order free you from complicated and frustated database specific related jobs such as rebuilding index, checking tablespace, checking whole database, updating your database statistic, monitoring your database growth, etc.
I just going to explain about BRTOOLS for Oracle because I only have Oracle database right now. BRTOOLS has numerous tools inside it.
To check your Oracle database, you can go to your SAP screen. Go to DB13 tcode.
Double click on current date.
Choose Check Database.
If you want to run check database command now, just choose Start Immedietly. But if you wan to run it later, just schedule it on appropriate time.
Happy checking your database. Send your suggestion to me on firstname.lastname@example.org.