DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Designer problems

  1. #1
    Join Date
    Jul 2000
    Posts
    243
    Hi all

    i ren into this strange problem, looked at the metalink and found no reference. the problem started a few days ago after a long time that i'v used the designer. the problem is: when i start the oracle designer main window it creates a lock on 2 objects - RM$DEFERRED_CHECKS, RM$DEFERRED_QUERIES. when i try to connect to any tool from the main window (say repository manager), it gets stock. looking at the db i found i have another lock on RM$DEFERRED_CHECKS.
    i ren this select:

    select a.object_name, a.status, b.oracle_username, b.os_user_name,c.sid, c.serial#,c.terminal, d.sql_text
    from sys.dba_objects a,
    v$locked_object b,
    v$session c,
    v$sqltext d
    where a.object_id = b.object_id
    and c.sid = b.session_id
    and c.sql_hash_value = d.hash_value

    and found that the statment that created the first lock is:
    begin rmmes.clear; jr_context.set_workarea(:IRID); end;
    the transaction waiting for this look is:
    DELETE FROM RM_DEFERRED_CHECKS

    i also found that if i do alter system kill session for the first session that created the lock, the tool i'm strying to start finally wakes up and i can work with it.

    i'll be thankfull for any lead that will help me find out how to correct this problem.

  2. #2
    Join Date
    Mar 2001
    Posts
    188
    Hi,
    the main question is which Designer do you use.
    If You use the disigner6 than i can tell you this is vvery buggy.
    On Oracle there is an patch for the Designer6
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    Hi tomate

    you are right, i forgot to post the version of the designer. the version is 6.5.40.21.0 and configuration version is 4.0.12

    hope this helps in any way. if some one can tell me the path number for that patchs i need to applay, i'm somewhat confused with the issue.

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width