What is T.code to view oracle Background processor?(such as reco,arch,dbwr,lgwr..). I'm trying to devolop an external interface for monitoring SAP/Oracle database`s performance,such as tablespaces`spaces management. I think that RSORATDB sotres performance`data in MONI,OSMON but i don`t know how SAP do to display statistics using those data!!!
Any one know how the database table MONI is used to manage tablespaces`space? I believe MONI itself does not have any tablespace statistics. IMHO the values displayed in transaction DB02 are ACTUAL values which are generated from the kernel (disp+work) and the dboraslib.sl/so. What are you trying to archive? Maybe there are some function calls that can be used to get those values rather than doing "select from table"..
Thanx in advance.