先查看哪些表被锁住了
    select b.owner,b.object_name,a.session_id,a.locked_mode

    from v$locked_object a,dba_objects b

    where b.object_id = a.object_id;

    OWNER                          OBJECT_NAME                                 SESSION_ID LOCKED_MODE

    ------------------------------ --------------------------------------      -------

    WSSB                           SBDA_PSHPFTDT                               22           3

    WSSB_RTREPOS                   WB_RT_SERVICE_QUEUE_TAB                     24           2

    WSSB_RTREPOS                   WB_RT_NOTIFY_QUEUE_TAB                      29           2

    WSSB_RTREPOS                   WB_RT_NOTIFY_QUEUE_TAB                      39           2

    WSSB                           SBDA_PSDBDT                                 47           3

    WSSB_RTREPOS                   WB_RT_AUDIT_DETAIL                    &nbs