Re: Oracle Compile Question........

amerar_at_iwc.net wrote:
> Hi All,
>
>
> We are running Oracle 9.2.0.7. We have a number of jobs running in the
> queue. A few things have become an issue here.
>
> First, if we need to re-compile a stored procedure that is being used
> by one of the jobs, the job must first be stopped. Strangely enough,
> even if we want to issue a simple grant to a table or on a procedure,
> we cannot as long as the object is being used......?? Why???
>
> However, even if we use DBMS_JOB.REMOVE to remove the job from the
> queue, for some reason the JQ locks are never released, and thus I
> cannot comple or grant. I need to manually go and kill the
> session........
>
> Any thoughts or ideas?
>
>
> Thanks!

Grants are DDL statements and like all DDL statements require an exclusive lock on the target object for a microsecond or so. DML activity requires that an object structure not change while the statement is executing so the session takes a TM lock on the object preventing the DDL session from grabbing an exclusive lock.

Why not just wait until the job completes?

HTH -- Mark D Powell -- Received on Fri Aug 11 2006 - 08:33:42 CDT