@Link I guess here you would need to be more specific. Are you specifically looking to get CPU and RAM usage for the Oracle DB? Then I guess you could write a SQL satement in the Monitoring Entries. See below the doc hon how to configure Application Monitoring.

https://docs.ifs.com/techdocs/Foundation1/040_administration/270_monitoring/020_app_mon/120_app_mon/default.htm

You could take a SQL statement from below URL if it matches your requirements.

https://asktom.oracle.com/ords/f?p=100:11:::::P11_QUESTION_ID:9532872700346037612

But for more monitoring options (Application Server / infrastructure / Oracle DB) you would need to access the IFS System Monitoring tool:

https://docs.ifs.com/techdocs/Foundation1/040_administration/270_monitoring/070_system_monitoring/default.htm

Hi @Marcel.Ausan 

I just want to see the capacity utilization of the cpu and ram of the IFS server.

The table DBA_HIST_SERVICE_STAT doesn’t exist in PL/SQL.

It exists, it just isn’t granted to IFSAPP or IFSADMIN etc. Possibly IFSSYS has it, but SYS definitely has it.

Are you Managed Cloud Hosted by IFS, or do you do your own hosting? If you’re cloud managed, you need to raise a case with IFS to ask them that sort of information (AWR Report).

If you’re doing your own hosting, do you (or your IT team) have the password to either SYS or IFSSYS ?