You can query the Dynamic Performance Views

See "Performance Tuning", here: http://docs.oracle.com/en/database/database.html

Any SQL there can be run by DBI as well (and often better/easier than in SQL*plus and similar)