Solution : https://service.sap.com/sap/support/notes/1002840 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues with the new space statistic monitor not displaying data or showing outdated data despite having activated the new collector (SAP Note 868063). Key transactions and terms mentioned include RSORACOL, DB02, DBACockpit, and others. The solution involves a multi-step check list, including verifying support package levels, ensuring the SAP_COLLECTOR_FOR_PERfMONITOR job runs hourly, confirming entries in tables TCOLL and ORA_MON_DBCON, and checking collector modules' status in DB02_COLL_PLAN. Additional steps include monitoring short dumps in ST22 and potentially upgrading the DBACockpit/DB02N if necessary, while ensuring the DB connection is properly registered and active.
Key words :
collect data 1064524 db02 itab_duplicate_key 1064524 db02 itab_duplicate_key 1066044 compute_bcd_overflow, data upload exceeded fixed limit 32 submonitor deactivated, db02->additional functions->collector logs->click, 000 log life 100 description remote oracle databasenote, 000 log life 100 description local oracle databasenote, altsy dayow xxxxxxx timod xxxxxxxxxxxxxxxxxxxxxxxxfor, component bc-ccm-mon-ora, db02n refresh 1042725 db02 refresh terminates, con_name = <db connection> operatio = createafter, con_name = <db connection> operatio = delete 2
Related Notes :
| 1482296 | DVM Service: analysed data volume incorrect (Oracle) |
| 1072066 | DBA Cockpit: New function for DB monitoring |
| 868063 | Database space statistics monitor for Oracle |