bedbmsguru

Linux Version 가능

http://cavaliercoder.com/libzbxpgsql/

출처:http://oracle.tistory.com/430

1. 세션별 CPU Time, Memory 사용량
 
select s.sid, s.serial#, p.spid as "os pid", s.username, s.module, s.sql_id, event, seconds_in_wait,
st.value/100 as "cpu sec",
round(pga_used_mem/1024/1024) "pga_tot(mb)",
round(pga_used_mem/1024/1024) "pga_per_sess(mb)"
from v$sesstat st, v$statname sn, v$session s, v$process p
where sn.name = 'CPU used by this session' -- cpu
and st.statistic# = sn.statistic#
and st.sid = s.sid
and s.paddr = p.addr
and s.last_call_et < 1800 -- active within last 1/2 hour
and s.logon_time > (SYSDATE - 240/1440) -- sessions logged on within 4 hours
order by st.value

 
 
 
 
2. Client별 Memory 사용량
 
select machine,status,count(*) cnt, 
       round(sum(pga_used_mem)/1024/1024) "pga_tot(mb)",
       round(sum(pga_used_mem)/count(*)/1024/1024) "pga_per_sess(mb)"
from v$session s, v$process p
where 1=1
--and s.status='active'
and s.paddr=p.addr
and type <> 'BACKGROUND'
group by machine,status
order by 1

출처: http://oracle.tistory.com/430 [안나푸르나]

column customizing 포함

$a = @{Expression={$_.SamAccountName}; Label="Column 1"; Width=50},
@{Expression={$_.surName}; Label="Column 2"; Width=50},
@{Expression={$_.Description}; Label="Column 3"; Width=50},
@{Expression={$_.Created}; Label="Column 4"; Width=50},
@{Expression={$_.LastLogonDate}; Label="Column 4"; Width=50}

Get-ADUser -Properties SamAccountName, surName, Description, Created, LastLogonDate -Filter {ObjectClass -eq "user"} -SearchBase "OU=MYOU,DC=mydc,DC=co,DC=kr" | Sort-Object -property SamAccountName | Select-object SamAccountName, surName, Description, Created, LastLogonDate | Format-Table -property $a > d:\aa.txt