| Auszug |
|---|
|
Identify and stop an Oracle process with permanent CPU load: show active sessions, kill the session and remove the root cause. |
Language: Deutsch · English
Stop a high-CPU Oracle process
When an Oracle background process pins the CPU: detect it, kill the session and prevent it from returning.
| Status |
|---|
| colour | Blue |
|---|
| title | Operations |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
| Hinweis |
|---|
|
These steps come from maintaining the old development VM and are very Oracle-specific. Use with care on production systems. |
1. Show active processes
| Codeblock |
|---|
|
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'; |
2. Get session data
| Codeblock |
|---|
|
SELECT inst_id, sid, serial# FROM gv$session WHERE sid = 133; |
3. Kill the session
| Codeblock |
|---|
|
ALTER SYSTEM KILL SESSION '133,9,@1'; |
To prevent recurrence, remove the root cause (e.g. a problematic materialized view).
Related pages
