SQL to get performance metrics shown in EM Express 12C Resources
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