Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help:ORA-00054: resource busy and acquire with NOWAIT specified

Re: Help:ORA-00054: resource busy and acquire with NOWAIT specified

From: Yong Huang <yong321_at_yahoo.com>
Date: 26 Apr 2002 14:10:59 -0700
Message-ID: <b3cb12d6.0204261310.358112ba@posting.google.com> 





I just want to comment on my own words. ALTER PROCEDURE COMPILE
actually does modify data dictionary. This can be seen by setting
SQL_TRACE to TRUE. But ALTER SESSION does not.



Yong Huang



yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0204260946.4dcf6e81_at_posting.google.com>...


> a row into data dictionary tables. How about ALTER PROCEDURE COMPILE?

> Test it. You'll see it also commits a transaction. How do we explain

> that?

> 

> Yong Huang

Received on Fri Apr 26 2002 - 16:10:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US