| Query to kill inactive sessions |
| Thursday, June 26, 2008 |
Query to kill inactive sessions:
-----------------------------------
SELECT 'ALTER SYSTEM KILL SESSION '||''''||sid ||','|| serial#||''''||' immediate;'
FROM v$session
WHERE status ='INACTIVE';
Save this query output as .sql format. Then connect to sql prompt and execute this .sql file. It'll kill
all inactive sessions.
|
posted by Senthil Kumaran @ 9:15 PM   |
|
|
|
