Re: oradebug dump processstate 10
- From: rjamya <rjamya@xxxxxxxxx>
- To: Muqthar.Ahmed@xxxxxxxxxxxxxxxxx
- Date: Thu, 9 Jun 2005 10:26:39 -0400
What ithis means is someone is executing a process that is executing
get_utl_dir package.
Raj
On 6/9/05, Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx> wrote:
>
> Hi,
>
> I have a function called GET_UTL_DIR and currently it is locked in the
> database. When I try to re-compile it I get the following error:
> ORA-04021: timeout occurred while waiting to lock object GET_UTL_DIR
>
>
> I have verified in v$lock but no user is locking. Therefore, I have used
> oradebug command to get more info:
>
>
> ******************** Cursor Dump ************************
> Current cursor: 1, pgadep: 0
> pgactx: 7000000182800f0 ctxcbk: 700000018280540 ctxqbc: 1104fdd30 ctxrws:
> 0
> Cursor Dump:
> ----------------------------------------
> Cursor 1 (1104d8a68): CURBOUND curiob: 1104e2aa8
> curflg: 4c curpar: 0 curusr: 0 curses 7000000129fcfa0
> cursor name: alter function get_utl_dir compile
> child pin: 700000014013d98, child lock: 700000014d3d630, parent lock:
> 700000015013a68
> xscflg: 2264, parent handle: 70000001c220800, xscfl2: c000400
> nxt: 1.0x00000168
> Cursor frame allocation dump:
> frm: -------- Comment -------- Size Seg Off
> End of cursor dump
> ***************** dump of cursor xsc=1104e2aa8 **********************
>
> Can anyone let me know what is PARENT LOCK???????
>
> Note: If I bounce the database, I can re-compile the function. But I would
> like to find out the cause.
>
> Muqthar
>
>
>
> * * * * * * * * *
>
> The information contained in this E-mail message is privileged,
> confidential, and may be protected from disclosure; please be aware that any
> other use, printing, copying, disclosure or dissemination
> of this communication may be subject to legal restriction or sanction. If
> you think that you have received this E-mail message in error, please reply
> to the sender and delete it from your computer. T
> hank you.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
