Checking SAP R/3 tablespaces
SAP R/3 are ERP software using large database. Usually commercial databases such Oracle, DB2, Informix is used as its database server. Mine using Oracle 9.2.0.6.
SAP tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace statistic, analyze detailed tablespace, checking missing indexes, and space critical objects. Actually, we can do more than that.
SAP R/3 installation created 6 tablespaces by default. Here are name of their tablespaces :
- PSAPTEMP
- PSAPUNDO
- PSAP[SID]
- PSAP[SID]620
- PSAP[SID]UDR
- SYSTEM
I am using SAP R/3 Enterprises 4.7 ext 200 version. It may be different if you are using old or new ones.
SAP R/3 data is saved on PSAP[SID] tablespace. So, we need to managed this tablespace carefully.
When you type DB02,
Press Space Statistic button to find out tablespace size and its growth. Tablespace’s growth can be seen daily, weekly, or monthly.
To check tablespace current size, just click Current Size button.
Click on PSAP[SID] tablespace and then, click Freespace Analysis.
If your PSAP[SID] tablespace size is reaching 95% level, you should consider increasing its size. You can use BRTOOLS to increase tablespace size. We’ll talk about BRTOOLS later.
9 Comments »
Leave a comment
About
Just another guy who wish to be an expert one day. Used to live in Bandung “Paris van Java“. Now running his own Linux, Computer Network, and SAP private consultant di Surabaya. Try to share his Basis knowledge to the real world.
If this blog information useful for you, please consider to donation to help me maintain and update this blog regularly.
My paypal account : devratt@yahoo.com
Want to contact me directly : Ardhian
-
Recent Comments
ulli on Installation and Configuration… ardhian on Installation and Configuration… Tintin on Installation and Configuration… Deepak on Print SAP documents using… Sathish on Remote Client Copy from PRD se… Ardhian Kioslinux – Journey to the “west”
SAP Basis Books- Basis Howto
- SAP on Linux
-
Popularity
-
-
-
PageRank
-
font size is to small nt able to see clearlly can u sent me little bit font size
thanks for u guidence
Very nice way of explaining, can you explain how to increase tablespace by using BRTOOLS for Oracle 9i on Linux.
Dear Laxminarayana,
You can access menu to increase tablespace from BRTOOLS command.
Just access your DB server using root user and switch to ora as oracle user.
Then type BRTOOLS
Choose SPACE Managements
You can that there you can see menu EXTEND TABLESPACE
Hope this could help you.
Ardhian
Hallo,
could you please tell me if I need to stop SAP system and DB Oracle I have to extend the PSAPTEMP tablespace?
Do I have to stop the system to extend other tablespaces??
Thnak you for your best answer ever in advance.
Regards
Lee
Hi,
You do not need to stop you SAP system and DB to extend any tablespace. You can extend any tablespace online while your SAP system and Oracle DB running.
Best Regards,
Ardhian
Just Love it!
Great explanation sir …
Excellent info appreciated…
Thanks
use BRTOOLS to increase tablespace size