on 04-29-2007 6:06 AM
Hi
I am learning SAP BASIS
I am not understanding, what can i monitor in Transaction ST02 and DB02, and If any problem observed in these transactions, What is the solution?
Plz kindly give me the solution
In the intial screen of ST02 we can monitor Roll area, Paging area , extended memory and Heap memory.
The roll area is a memory area with a set (configurable) size that belongs to a work process. It is located in the heap of the virtual address space of the work process.
Extended memory is the mail part of memory management system.You can assign the extended memory from a common space to any work process.(We commonly do it when we work with pointers in ABAP).
If a dialog work process has used up the roll area assigned to it and the extended memory, private memory is assigned to the work process. The work process goes into PRIV mode (private).
Missing indexes may occur if you ignore an error message when creating a table or if an index is deleted.You can find the missing indexes in DB02 just by clicking on the missing index area.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
About ST04:
in ST04 you can find unlimited information you can see if tablespaces are in backup mode, and you can get detailed analasys menu and many more.
--Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What swati kumar said was correct.
in ST02 you can find memory utilization: If your swap memory was used abpve thresh hold value then you have to increase buffer, you can do this at SAP via RZ10 and also you can do this by changing instace profile at OS, But for any perameter change, SAP needs to be bounced ( stop and start SAP) to activate changes made to Instance profile.
About DB02:
this will let you know current space utilization of Database, you can find many things like if there were any space cretical objects, curret fill level of all table spaces etc, you have to do refresh to get latest information.
-Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi friend,
st02 is buffer monitor, see swaps in this, if swaps are more (1000) or depend on company maintenance. if any swaps , need to increase that buffer size in RZ10.
and restart instance.
in DB02, check table space grouth (90 %)and increase through sapdba or brtools.
we can monitor sapce critical object ( this objects need more space but space is less). and missing index in db, if u find this need to do "Check and update optimizer statistics" in DB13.
regards,
swathi kumar-k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.