-
Hi,
I am killing oracle sessions but Oracle is not giving up the
memory.It still shows up as a killed session in v$session.
Some body suggested I use orakill and I am trying to automate the query using
select 'orakill'...................
where v$session.status='KILLED' and
v$session.paddr=v$process.addr
/
but the query is not returning any rows.
Any ideas ?
Thanks,
Copernicus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|