Ana Sayfa > İpucuOraclePL/SQL > Oracle – Session Sayısı

Oracle – Session Sayısı

select count(*) "Toplam session", 
(select count(*) from gv$session where type != 'BACKGROUND' ) "Toplam Session (Oracle Hariç)", 
(select count(*) from gv$session where status = 'ACTIVE' and inst_id=1 and type != 'BACKGROUND' ) "Aktif Session"
 from gv$session group by 1,2,3

Both comments and pings are currently closed.

Yorumlar kapalı.