SAP Daily Monitoring

SAP Daily System Monitoring

Daily System Monitoring:

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.

Tanya Jawab Seputar Space critical Objects di DB02 – SAP

Hi All,

Please help me understand the status of space critical objects in DB02.
Which of these are critical to the system’s performance?
What must be done to minimize or to avoid occurrence of these objects?

Thanks and regards to all,
Djmervz
————————————————————————————–
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

————————————————————————————–

In DB02, space critical objects refer those objects (tables/indexes) that become space critical due to lack of insufficient free space of that tablespace holding these objects.
As data gets added to tables in a tablespace, the available freespace of a tablesapce gets reduced, at some point of time the tablespace goes out of needed free space and results in space critical objects as these objects are requiring more memory that available.
DB02 allows us to check the monitor the free space of the table spaces and add space when needed.
Coming to system performance, if a tablespace goes space critical and has space critical objects, this will have impact on performance of the database and the application, all the database inserts/updates on this tablespace gets rollback due to non availability of sufficient free space. Hence the space needs to be closely monitored by the basis team.
Hope the information is answering your questions?, pls. feel free for any more queries.

Regards
VDM.

Yahoo Msg On YM

nindasakura : Yahoo akan dimatikan pada tgl 17 November. Mereka ingin memperoleh data messenger yg gratis. klo km melewatkan pesan ini, namamu akan dihapus dr daftar messenger. sudah banyak messenger yang terhapus. klik kanan pada nama contact di list anda, kirim email ini ke seluruh messenger yg ada dalam contact name… ini Anna Rubenecia president Yahoo, memberitahukan bahwa Yahoo telah memiliki anggota lebih dari 2juta. jika kamu ingin tetap memiliki account gratis kirimkan email ini ke siapapu yg ada dalam daftar kontak anda. dengan cara ini kami dapat mengetahui account mana saja yang masih digunakan dan account mana yang bisa kami hapus. kirim pesan