For the archives: From another list, found out there is a known bug: It's a known problem with Forms 6 vs Oracle9i. See Oracle MetaLink bug number 2052790.
It hasn't been updated since February but it references bug 2166890 which I cannot access. DDL COMMAND HANGS IN SQL*PLUS IF THE TABLE IS USED IN A FORM >To: [EMAIL PROTECTED] >From: Deborah Lorraine <[EMAIL PROTECTED]> >Subject: ORA 4021 when .fmb with library is opened > >We have a database problem caused by an .fmb open in developer 6i. I can >now consistently reproduce the following scenario that generates ORA 4021, >timeout occurred trying to lock a library object: > >1. Developer A opens xxx.fmb in form builder, goes for a cup of coffee >2. DBA attempts to grant a privilege against any table in the library >invoked by xxx.fmb, and fails after 5 minutes with ORA 4021. > >In fact, any DDL, including a scenario where DEVELOPER B tries to create >his own table with the same table locked by Developer A, but DIFFERENT >columns, he will get ORA 4021 also. The table name itself is locked! > >I first noticed this problem when my dynamically-generated grant scripts >repeatedly failed with 4021's after upgrading to 9iR2. Never had that >problem before. The only way I could give developer grants was to >shutdown the database and restrict access! I thought it was related to >pinned packages but that was not the case. Each time, I traced the >problem to a pin lock held by an inactive developer session with an open >.fmb. > >Developers are using Developer 6i patch 5a and some use patch 10 (doesn't >matter) connecting client/server. > >I wonder if there some setting in Developer 6i that could be causing >it? I'm suspicious, because the problem consistently happens with three >of our 15 developers. I don't want to join a developer list to post this >question, and really, I believe the problem is in the database. > >Any ideas? > >Thanks, > >Debi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deborah Lorraine INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
