Solution : https://service.sap.com/sap/support/notes/706927 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the execution of SQL scripts necessary for the proper functionality of Oracle Performance Monitors in ST04N and DBACockpit transitions starting from Oracle 9i/RAC. The note specifies the use of a SQL package containing create.sql among other scripts for setting up necessary database environments, including the recreation of snapshot tables with enabled compression and creating SAP-specific views and synonyms for Oracle Database. It instructs on executing these scripts with SYSDBA privileges and the requirement for higher versions to use specific dbmon.CAR packages tailored for Unicode and non-Unicode systems.
Key words :
sqlthe script creates sap_$ views, system deletes snapshot tables, existing snapshot information, oracle 9i/rac, compress option set, sap$kvit solution, sap db user', sql script create, oracle performance monitor, sqlor oraadm> sqlplus
Related Notes :
| 1540222 | DBA Cockpit: Monitoring non-ABAP/Java Oracle databases |
| 969519 | 6.20/6.40 Patch Collection Installation : Oracle/UNIX |
| 927295 | FAQ: Oracle system statistics |
| 921402 | Problem in snapshot creation with GVD_SPPARAMETER in st04n. |
| 851169 | (Outdated)Inst: SAP NetWeaver2004s - UNIX:Oracle |
| 838725 | Oracle dictionary statistics and system statistics |
| 785921 | SAP Web AS 6.40 SR1 Installation on UNIX: Oracle |
| 752982 | ST04N: Can't create oracle snapshot |
| 716000 | Database monitor for Oracle 9/Oracle RAC SAP Release 6.X |
| 705608 | Database monitor for Oracle 9/Oracle RAC |
| 731 | Collective note: ORA-00904 |