Seitenhistorie

...

Und Oracle arbeitet nicht mehr dauernd im Hintergrund.

Außerdem:

Speziellen laufenden Oracle Process abstellen:

1) Show Active Processes:

select S.USERNAME, s.sid, s.osuser, t.sql_id, sql_text
from v$sqltext_with_newlines t,V$SESSION s
where t.address =s.sql_address
and t.hash_value = s.sql_hash_value
and s.status = 'ACTIVE'
and s.username <> 'SYSTEM'

USERNAME SID OSUSER
------------------------------ ---------- ------------------------------
SQL_ID SQL_TEXT
------------- ----------------------------------------------------------------
QQRFT0 133 oracle
dxs63gfzjmqjc select inline#, textspos, textlen, hashval, instance#, rowid, q

2) Show data for process to be killed:

select inst_id,sid,serial# from gv$session where sid = 133;

INST_ID SID SERIAL#
---------- ---------- ----------
1 133 9

3) Kill Process:

alter system kill session '133,9,@1';

ORA-00031: session marked for kill

4) Silence