Oracle, PL/SQL
Doňan sessiýany nädip awtomat 'kill' edip bolar? Mysal üçin:
SELECT v.SID, v.SERIAL# serial, v.OSUSER, v.STATUS, w.SECONDS_IN_WAIT , v.MACHINE, v.PROGRAM, v.SCHEMANAME, v.SCHEMA#, v.LAST_CALL_ET, v.MODULE, v.BLOCKING_SESSION_STATUS, v.BLOCKING_SESSIONFROM v$session_wait w, v$session vWHERE v.STATUS NOT IN (IN'ACTIVE') AND v.LAST_CALL_ET > 3600 AND w.SECONDS_IN_WAIT > 600 w.SID = v.sid
Arhiwiň ýagdaýy
● Doly tekst
● 0/0 teswir saklanypdyr
Ýazylan saýty: ertir.com · Çeşme: Web Archive nusgasy — ertir.com, 11 maý 2012 ý. · Asyl sahypany gör ↗
Teswirler 0
Teswir ýok.