show_users.sql

July 30, 2012 admin Oracle, Scripts

column mu format a40 heading “Machine – User”
select machine||’ – ‘||nvl(username,'[BKGD PROCESS]’) mu, count(*)
from v$session
group by machine||’ – ‘||nvl(username,'[BKGD PROCESS]’);
select count(*) “Total Count of Sessions”
from v$session;

Data pump export (expdp) and import (impdp) examples Test speed of disks – write a 1GB file and time it.