Shulou(Shulou.com)06/01 Report--

View all job

Select from dba_jobs

View job that is running

Select from dba_jobs_running

Select job,log_user,priv_user,schema_user,BROKEN from dba_jobs where job=545

Check the response status of the database establishment

Select sid,serial#,username,program,machine,status

From v$session

Check the sql_id of the corresponding sid

Select * from v$session where sid=2272 or sid=327

Check the sql statement after knowing sql_id

Select SQL_TEXT from v$sql where sql_id='3f18ygbqg41mw'

Empower MESPRD

Grant execute on DBMS_WORKLOAD_REPOSITORY to MESPRD

Kill session

Alter system kill session 'sid,serial#'

Alter system kill session '327pr 8133'

View the spid of a process

Select spid, program from v$process

Where programmers = 'PSEUDO'

And addr not in (select paddr from v$session)

And addr not in (select paddr from v$bgprocess)

And addr not in (select paddr from v$shared_server)

! ps-ef | grep spid | grep-v grep

View the spid of a process

SELECT s.username,s.status

X.ADDR,x.KSLLAPSC,x.KSLLAPSN,x.KSLLASPO,x.KSLLID1R,x.KSLLRTYP

Decode (bitand (x.ksuprflgMagne2), 0recordnullre1)

FROM x$ksupr xrem vandalism session s

WHERE s.paddr (+) = x.addr

And bitand (ksspaflg,1)! = 0

View the spid of a process

Select spid,program from v$process where pid in (327pas 2272)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.