Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Dba_ddl_locks

SQL>  create or replace  procedure p as  begin null;  end;   2  / SQL> SQL> exec p PL/SQL procedure successfully completed. SQL> SQL> select * from dba_ddl_locks; SESSION_ID OWNER                          NAME                           TYPE                             MODE_HELD MODE_REQU ---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------         20 RNTSOFT                         NAMED_BLOCK                    Table/Procedure/Type                 Null          None         20 SYS                            DICTIONARY_OBJ_OWNER           Table/Procedure/Type                 Null          None         20 SYS                            DBMS_STANDARD                  Table/Procedure/Type                 Null          None         20 XDB                            DBMS_XDBZ0                     Body                                 Null          None         20 RNTSOFT                         P_SPLIT                        Table/Procedure/Type                 Null          None         20 RNTSOFT                         P                              Table/Procedure/Type                 Null          None         20 SYS                            DBMS_SYS_SQL                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_OUTPUT                    Body                                 Null          None         20 RNTSOFT                         UPDATE_EMP                     Table/Procedure/Type                 Null          None         20 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None         20 RNTSOFT                         CHANGEPRICE                    Table/Procedure/Type                 Null          None         20 SYS                            DICTIONARY_OBJ_TYPE            Table/Procedure/Type                 Null          None         20 SYS                            DBMS_UTILITY                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_WARNING                   Table/Procedure/Type                 Null          None         20 RNTSOFT                         AUTHORS_SEL                    Table/Procedure/Type                 Null          None         20 RNTSOFT                         COMPUTE_DISCOUNTS              Table/Procedure/Type                 Null          None         20 SYS                            DATABASE                       18                                   Null          None         20 SYS                            DBMS_SQL                       Body                                 Null          None         20 SYS                            DBMS_OUTPUT                    Table/Procedure/Type                 Null          None         20 RNTSOFT                         AUTHOR_SEL                     Table/Procedure/Type                 Null          None         20 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None         20 SYS                            STANDARD                       Body                                 Null          None         20 SYS                            AW_DROP_PROC                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_WARNING                   Body                                 Null          None         20 RNTSOFT                         P_HELLOTO                      Table/Procedure/Type                 Null          None         20 RNTSOFT                         MEASURE_USAGE                  Table/Procedure/Type                 Null          None         20 RNTSOFT                         RNTSOFT                         18                                   Null          None         20 SYS                            DBMS_SQL                       Table/Procedure/Type                 Null          None         20 RNTSOFT                         MY_FIRST_PROC                  Table/Procedure/Type                 Null          None         20 RNTSOFT                         TEST_TIME                      Table/Procedure/Type                 Null          None         20 SYS                            DBMS_ROWID                     Table/Procedure/Type                 Null          None         20 RNTSOFT                         P_HELLO                        Table/Procedure/Type                 Null          None         20 XDB                            DBMS_XDBZ0                     Table/Procedure/Type                 Null          None         20 SYS                            DBMS_UTILITY                   Body                                 Null          None         20 RNTSOFT                         EMP_CHANGE_S                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None         20 SYS                            DICTIONARY_OBJ_NAME            Table/Procedure/Type                 Null          None         20 SYS                            DBMS_ROWID                     Body                                 Null          None         20 RNTSOFT                         BIND_TEST                      Table/Procedure/Type                 Null          None         20 SYS                            DBMS_SPACE                     Body                                 Null          None         20 RNTSOFT                         EMPLOYEE_COUNT                 Table/Procedure/Type                 Null          None         40 SYS                            AQ$_ALERT_QT_E                 10                                   Null          None         40 SYS                            DBMS_HA_ALERTS_PRVT            Body                                 Null          None         40 SYS                            DBMS_RCVMAN                    Table/Procedure/Type                 Null          None         40 SYS                            DBMS_PRVT_TRACE                Table/Procedure/Type                 Null          None         40 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None         40 SYS                            DBMS_HA_ALERTS_PRVT            Table/Procedure/Type                 Null          None         40 SYS                            DBMS_PRVT_TRACE                Body                                 Null          None         40 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None         40 SYS                            STANDARD                       Body                                 Null          None         40 SYS                            ALERT_QUE                      10                                   Null          None         40 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None         40 SYS                            DBMS_BACKUP_RESTORE            Body                                 Null          None         40 SYS                            ALERT_QUE_R                    23                                   Null          None         40 SYS                            DBMS_BACKUP_RESTORE            Table/Procedure/Type                 Null          None         40 SYS                            DBMS_RCVMAN                    Body                                 Null          None         41 SYS                            SCHEDULER$_INSTANCE_S          Table/Procedure/Type                 Null          None 58 rows selected. SQL> alter procedure p compile; SP2-0805: Procedure altered with compilation warnings SQL> SQL> select * from dba_ddl_locks; SESSION_ID OWNER                          NAME                           TYPE                             MODE_HELD MODE_REQU ---------- ------------------------------ ------------------------------ ---------------------------------------- --------- ---------         20 RNTSOFT                         NAMED_BLOCK                    Table/Procedure/Type                 Null          None         20 SYS                            DICTIONARY_OBJ_OWNER           Table/Procedure/Type                 Null          None         20 SYS                            DBMS_SYS_SQL                   Body                                 Null          None         20 XDB                            DBMS_XDBZ0                     Body                                 Null          None         20 SYS                            DBMS_SYS_SQL                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_OUTPUT                    Body                                 Null          None         20 RNTSOFT                         UPDATE_EMP                     Table/Procedure/Type                 Null          None         20 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None         20 RNTSOFT                         CHANGEPRICE                    Table/Procedure/Type                 Null          None         20 SYS                            DICTIONARY_OBJ_TYPE            Table/Procedure/Type                 Null          None         20 SYS                            DBMS_UTILITY                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_WARNING                   Table/Procedure/Type                 Null          None         20 RNTSOFT                         AUTHORS_SEL                    Table/Procedure/Type                 Null          None         20 RNTSOFT                         COMPUTE_DISCOUNTS              Table/Procedure/Type                 Null          None         20 SYS                            DATABASE                       18                                   Null          None         20 SYS                            DBMS_SQL                       Body                                 Null          None         20 SYS                            DBMS_OUTPUT                    Table/Procedure/Type                 Null          None         20 RNTSOFT                         AUTHOR_SEL                     Table/Procedure/Type                 Null          None         20 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None         20 SYS                            STANDARD                       Body                                 Null          None         20 SYS                            AW_DROP_PROC                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_WARNING                   Body                                 Null          None         20 RNTSOFT                         P_HELLOTO                      Table/Procedure/Type                 Null          None         20 RNTSOFT                         MEASURE_USAGE                  Table/Procedure/Type                 Null          None         20 RNTSOFT                         RNTSOFT                         18                                   Null          None         20 SYS                            DBMS_SQL                       Table/Procedure/Type                 Null          None         20 RNTSOFT                         MY_FIRST_PROC                  Table/Procedure/Type                 Null          None         20 RNTSOFT                         TEST_TIME                      Table/Procedure/Type                 Null          None         20 SYS                            DBMS_ROWID                     Table/Procedure/Type                 Null          None         20 RNTSOFT                         P_HELLO                        Table/Procedure/Type                 Null          None         20 XDB                            DBMS_XDBZ0                     Table/Procedure/Type                 Null          None         20 SYS                            DBMS_UTILITY                   Body                                 Null          None         20 RNTSOFT                         EMP_CHANGE_S                   Table/Procedure/Type                 Null          None         20 SYS                            DBMS_SPACE                     Table/Procedure/Type                 Null          None         20 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None         20 SYS                            DICTIONARY_OBJ_NAME            Table/Procedure/Type                 Null          None         20 SYS                            DBMS_ROWID                     Body                                 Null          None         20 RNTSOFT                         BIND_TEST                      Table/Procedure/Type                 Null          None         20 SYS                            DBMS_SPACE                     Body                                 Null          None         20 RNTSOFT                         EMPLOYEE_COUNT                 Table/Procedure/Type                 Null          None         40 SYS                            AQ$_ALERT_QT_E                 10                                   Null          None         40 SYS                            DBMS_HA_ALERTS_PRVT            Body                                 Null          None         40 SYS                            DBMS_RCVMAN                    Table/Procedure/Type                 Null          None         40 SYS                            DBMS_PRVT_TRACE                Table/Procedure/Type                 Null          None         40 SYS                            PLITBLM                        Table/Procedure/Type                 Null          None         40 SYS                            DBMS_HA_ALERTS_PRVT            Table/Procedure/Type                 Null          None         40 SYS                            DBMS_PRVT_TRACE                Body                                 Null          None         40 SYS                            DBMS_APPLICATION_INFO          Table/Procedure/Type                 Null          None         40 SYS                            STANDARD                       Body                                 Null          None         40 SYS                            ALERT_QUE                      10                                   Null          None         40 SYS                            DBMS_APPLICATION_INFO          Body                                 Null          None         40 SYS                            DBMS_BACKUP_RESTORE            Body                                 Null          None         40 SYS                            ALERT_QUE_R                    23                                   Null          None         40 SYS                            DBMS_BACKUP_RESTORE            Table/Procedure/Type                 Null          None         40 SYS                            DBMS_RCVMAN                    Body                                 Null          None         41 SYS                            SCHEDULER$_INSTANCE_S          Table/Procedure/Type                 Null          None 57 rows selected.