Re: oracle killed session still holding locks

> Assuming you are supported, you can go to metalink and search for
> notes, or enter a tar, or look for bugs.

i've heard it's "a normal" comportement of oracle ?????

>
>

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1020720.102
>
> You can perhaps also get some information from lock manager in OEM.
>
> select view_name from dba_views where view_name like '%LOCK%';
>
> If all else fails, bounce the db.
>
> >
> > Are there any comands to show me what this session do, how many io, cpu
> > (like sp_monitor in sybase) ?
>
> select view_name from dba_views where view_name like '%SESS%'
> select view_name from dba_views where view_name like '%PROC%'
>
> Or check out performance manager in OEM.
>
> On unix, you can also do stuff like script for process information out
> of Oracle and use unix tools to find interesting information.
>
> See also http://members.cox.net/oracleunix/readme-cdos.htm
>

thx i'll check out this next week at work :) Received on Sat Oct 30 2004 - 06:02:45 CDT