scriptfile - Cheeky Cockatoo

user_stats.sql

Download Script

set pages 100
select sum(SHARABLE_MEM),sum(PERSISTENT_MEM),sum(RUNTIME_MEM),
sum(SORTS),sum(VERSION_COUNT),sum(LOADED_VERSIONS),sum(OPEN_VERSIONS),
sum(EXECUTIONS),sum(LOADS),sum(INVALIDATIONS),sum(PARSE_CALLS),
sum(DISK_READS),sum(BUFFER_GETS),sum(ROWS_PROCESSED),sum(KEPT_VERSIONS)
from v$sqlarea, dba_users u
where PARSING_USER_ID=u.user_id
and u.username='&username';