Fwd: ORA 4021 when .fmb - it's a bug

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: oracle-l_at_fatcity.com
>From: Deborah Lorraine <dlorraine_at_ucdavis.edu>
>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: dlorraine_at_ucdavis.edu

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: ListGuru_at_fatcity.com (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).