| dba [message #53859] |
Tue, 15 October 2002 08:51  |
kmy
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
hi,
i wuold like to know how to kill inactive processes in 8i database,what is the query used to see the inactive processes.
|
|
|
|
| Re: dba [message #53861 is a reply to message #53859] |
Tue, 15 October 2002 08:57  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
That would be a query against the V$SESSION view:
SQL> select sid, serial#, username, status from v$session;
SID SERIAL# USERNAME STATUS
---------- ---------- ------------------------------ --------
1 1 ACTIVE
2 1 ACTIVE
3 1 ACTIVE
4 1 ACTIVE
5 1 ACTIVE
6 1 ACTIVE
30 2969 SYSTEM INACTIVE
54 62514 MARIK INACTIVE
74 53375 SYSTEM ACTIVE
86 60034 MARIK INACTIVE
10 rows selected.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: dba [message #53863 is a reply to message #53859] |
Tue, 15 October 2002 09:05 |
kmy
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
hi,
ok fine i got how to query,but i want to know how to kill the inactive processes permenantly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
