DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM

You can get the “DB Statistics on ORACLE Databases” error while executing RTCCTOOL on your SAP system with the DVM subject and the following details.

You can get the below report output via executing the RTCCTOOL on your SAP system

SE38 –> RTCCTOOL

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

In this case, you need to check “Collector Logs” for INACTIVE status values ;

DB02 –> Space –> Additional Functions –> Collector Logs –> open the “Modules” tab –> Search for “I” for the “Status” Column

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

Also you can make this check via controlling the table “DB02_CALL_PLAN”

DB16 –> DB02_CALL_PLAN

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

Search the “I” values for the area “Status” like below and execute

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

You can get the same list which we already got from DB02, important information is the DB Connection name

In our example DB Connection name is DEFAULT

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

To solve the issue, execute the following steps ;

SE38 –> RSORACUP

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

COM_NAME : DEFAULT

OPERATIO : DELETE

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

F8 – Execute

Continue with –> “NO” for the below question screen

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

Execute the program again with the below values ;

COM_NAME : DEFAULT

OPERATIO : CREATE

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

Now you can check the result again with executing the report RTCCTOOL

DB Statistics on ORACLE Databases - RTCCTOOL Error for DVM

 

One Response to "DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM"

  1. David says:

    Hello and thank you. This was very helpful. I’ve done it before but your notes were more succinct then chasing down notes. Just a couple things:
    Where you write DB16 –> DB02_CALL_PLAN it should be SE16 (Not DB16) and DB02_COLL_PLAN (Not DB02_CALL_PLAN).
    I also do a refresh on the DBACOCKPIT >> Space Overview screen (Starts job REFRESH SPACE STATISTIC:DEFAULT) and recheck the collector logs to see that they ran before doing RTCCTOOL again.
    Well, thanks again!
    David

Leave a Reply


3 × six =

Blogroll