SQL to get performance metrics shown in EM Express 12C Resources I would like to start recording some historical performance metrics on my Oracle database server.  I can use these metrics to evaluate growth of database resource requirements over time.  When it's time to upgrade or replace the server, I can use this data to choose the right sized server.
The important metrics for me to collect are CPU percentage used, memory usage broken out by process, and although it isn't shown in EM, disk latency metrics would also help.  Below is a screenshot:

We don't have any of the additional performance packs licensed, but I have to figure if EM can query it every minute then I should be able to get it too.  Can someone give an example of a query or queries that can provide this data?
STATSPACK comes out of the box with Oracle Database Standard Edition. It works by comparing two snapshots.

https://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html

Install:

cd $ORACLE_HOME/rdbms/admin/
sqlplus "/ as sysdba" @spcreate.sql


Take a snapshot:

sqlplus perfstat/&lt;password&gt;
execute statspack.snap(i_snap_level=&gt;7);


Generate a report:

cd $ORACLE_HOME/rdbms/admin/
sqlplus perfstat/&lt;password&gt; @spreport