http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_ddl_locks
Oracle PL/SQL/System Tables Views/dba ddl locks - История изменений
2026-04-04T02:28:02Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_ddl_locks&diff=2228&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_ddl_locks&diff=2229&oldid=prev
Admin: 1 версия
2010-05-26T10:01:13Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query dba_ddl_locks table before and after recompile a procedure==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create or replace procedure p as begin null; end;<br />
2 /<br />
Procedure created.<br />
SQL><br />
SQL> exec p;<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL> select * from dba_ddl_locks;<br />
SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br />
---------- ------------------------------ -------------------- ---------------------------------------- --------- ---------<br />
40 SYS AQ$_ALERT_QT_E 10 Null None<br />
40 SYS DBMS_HA_ALERTS_PRVT Body Null None<br />
40 SYS DBMS_RCVMAN Table/Procedure/Type Null None<br />
40 SYS DBMS_PRVT_TRACE Table/Procedure/Type Null None<br />
40 SYS PLITBLM Table/Procedure/Type Null None<br />
40 SYS PLITBLM Table/Procedure/Type Null None<br />
40 SYS DBMS_HA_ALERTS_PRVT Table/Procedure/Type Null None<br />
40 SYS DBMS_PRVT_TRACE Body Null None<br />
40 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
40 SYS STANDARD Body Null None<br />
40 SYS ALERT_QUE 10 Null None<br />
40 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
40 SYS DBMS_BACKUP_RESTORE Body Null None<br />
40 SYS ALERT_QUE_R 23 Null None<br />
40 SYS DBMS_BACKUP_RESTORE Table/Procedure/Type Null None<br />
40 SYS DBMS_RCVMAN Body Null None<br />
29 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br />
29 SYS DBMS_SYS_SQL Body Null None<br />
29 XDB DBMS_XDBZ0 Body Null None<br />
29 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br />
29 SYS DBMS_OUTPUT Body Null None<br />
29 sqle ADDRESS Table/Procedure/Type Null None<br />
29 SYS PLITBLM Table/Procedure/Type Null None<br />
29 SYS DATABASE 18 Null None<br />
29 SYS DBMS_SQL Body Null None<br />
29 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
29 sqle GETEMPBLDGNAME Table/Procedure/Type Null None<br />
29 SYS STANDARD Body Null None<br />
29 SYS AW_DROP_PROC Table/Procedure/Type Null None<br />
29 SYS IDGEN1$ Table/Procedure/Type Null None<br />
29 sqle sqle 18 Null None<br />
29 sqle ASSIGNEMPTOBLDG Table/Procedure/Type Null None<br />
29 SYS DBMS_SQL Table/Procedure/Type Null None<br />
29 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br />
29 sqle ADDRESS Body Null None<br />
29 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
29 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br />
23 sqle PRINT_TABLE Table/Procedure/Type Null None<br />
23 SYS DBMS_RANDOM Table/Procedure/Type Null None<br />
23 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br />
23 SYS DBMS_STANDARD Table/Procedure/Type Null None<br />
23 XDB DBMS_XDBZ0 Body Null None<br />
23 sqle DEPT_SEQ Table/Procedure/Type Null None<br />
23 sqle P Table/Procedure/Type Null None<br />
23 SYS XML_SCHEMA_NAME_PRES Table/Procedure/Type Null None<br />
ENT<br />
23 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br />
23 SYS DBMS_OUTPUT Body Null None<br />
23 XDB XDuubYCRNYQDOCOoaecR 25 Share None<br />
Uoig==<br />
23 SYS PLITBLM Table/Procedure/Type Null None<br />
23 SYS XML_SCHEMA_NAME_PRES Body Null None<br />
ENT<br />
23 SYS ORA_PLAN_ID_SEQ$ Table/Procedure/Type Null None<br />
23 SYS UTL_RAW Body Null None<br />
23 SYS UTL_RAW Table/Procedure/Type Null None<br />
23 V1 43 Null None<br />
23 SYS DICTIONARY_OBJ_TYPE Table/Procedure/Type Null None<br />
23 SYS DBMS_ASSERT Body Null None<br />
23 SYS DBMS_SYS_ERROR Table/Procedure/Type Null None<br />
23 sqle VIRTUAL_TABLE Table/Procedure/Type Null None<br />
23 SYS DBMS_UTILITY Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_UTIL Table/Procedure/Type Null None<br />
23 sqle PIVOT Table/Procedure/Type Null None<br />
23 SYS DBMS_FLASHBACK Body Null None<br />
SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br />
---------- ------------------------------ -------------------- ---------------------------------------- --------- ---------<br />
23 SYS DATABASE 18 Null None<br />
23 SYS DBMS_SQL Body Null None<br />
23 XDB XD8Vf3vgTDR1aSQOGkEt 25 Share None<br />
R2uQ==<br />
23 SYS DBMS_OUTPUT Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_INT Body Null None<br />
23 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
23 SYS STANDARD Body Null None<br />
23 XDB XDh1jUheYAR5PgNAgAIL 25 Share None<br />
JCxg==<br />
23 SYS AW_DROP_PROC Table/Procedure/Type Null None<br />
23 SYS DBMS_LOB Table/Procedure/Type Null None<br />
23 SYS IDGEN1$ Table/Procedure/Type Null None<br />
23 XDB XDbD/PLZ01TcHgNAgAII 25 Share None<br />
egtw==<br />
23 sqle sqle 18 Null None<br />
23 XDB XDB$EXTNAME2INTNAME Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA Table/Procedure/Type Null None<br />
23 SYS DBMS_SYS_ERROR Body Null None<br />
23 SYS DBMS_SQL Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_UTIL Body Null None<br />
23 SYS DBMS_XPLAN Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA Body Null None<br />
23 SYS DBMS_FLASHBACK Table/Procedure/Type Null None<br />
23 sqle COMPANY_LISTING Table/Procedure/Type Null None<br />
23 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br />
23 SYS DBMS_XPLAN Body Null None<br />
23 SYS DBMS_UTILITY Body Null None<br />
23 SYS XMLTYPE Table/Procedure/Type Null None<br />
23 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
23 sqle EMP_SEQ Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_INT Table/Procedure/Type Null None<br />
23 SYS OBJECT_GRANT Table/Procedure/Type Null None<br />
23 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br />
23 SYS XMLTYPE Body Null None<br />
23 sqle REMOVE_CONSTANTS Table/Procedure/Type Null None<br />
23 SYS DBMS_LOB Body Null None<br />
23 SYS DBMS_ASSERT Table/Procedure/Type Null None<br />
97 rows selected.<br />
SQL><br />
SQL> alter procedure p compile;<br />
Procedure altered.<br />
SQL><br />
SQL> select * from dba_ddl_locks;<br />
SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br />
---------- ------------------------------ -------------------- ---------------------------------------- --------- ---------<br />
40 SYS AQ$_ALERT_QT_E 10 Null None<br />
40 SYS DBMS_HA_ALERTS_PRVT Body Null None<br />
40 SYS DBMS_RCVMAN Table/Procedure/Type Null None<br />
40 SYS DBMS_PRVT_TRACE Table/Procedure/Type Null None<br />
40 SYS PLITBLM Table/Procedure/Type Null None<br />
40 SYS PLITBLM Table/Procedure/Type Null None<br />
40 SYS DBMS_HA_ALERTS_PRVT Table/Procedure/Type Null None<br />
40 SYS DBMS_PRVT_TRACE Body Null None<br />
40 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
40 SYS STANDARD Body Null None<br />
40 SYS ALERT_QUE 10 Null None<br />
40 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
40 SYS DBMS_BACKUP_RESTORE Body Null None<br />
40 SYS ALERT_QUE_R 23 Null None<br />
40 SYS DBMS_BACKUP_RESTORE Table/Procedure/Type Null None<br />
40 SYS DBMS_RCVMAN Body Null None<br />
29 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br />
29 SYS DBMS_SYS_SQL Body Null None<br />
29 XDB DBMS_XDBZ0 Body Null None<br />
29 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br />
29 SYS DBMS_OUTPUT Body Null None<br />
29 sqle ADDRESS Table/Procedure/Type Null None<br />
29 SYS PLITBLM Table/Procedure/Type Null None<br />
29 SYS DATABASE 18 Null None<br />
29 SYS DBMS_SQL Body Null None<br />
29 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
29 sqle GETEMPBLDGNAME Table/Procedure/Type Null None<br />
29 SYS STANDARD Body Null None<br />
29 SYS AW_DROP_PROC Table/Procedure/Type Null None<br />
29 SYS IDGEN1$ Table/Procedure/Type Null None<br />
29 sqle sqle 18 Null None<br />
29 sqle ASSIGNEMPTOBLDG Table/Procedure/Type Null None<br />
29 SYS DBMS_SQL Table/Procedure/Type Null None<br />
29 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br />
29 sqle ADDRESS Body Null None<br />
29 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
<br />
SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQU<br />
---------- ------------------------------ -------------------- ---------------------------------------- --------- ---------<br />
29 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br />
23 sqle PRINT_TABLE Table/Procedure/Type Null None<br />
23 SYS DBMS_RANDOM Table/Procedure/Type Null None<br />
23 SYS DICTIONARY_OBJ_OWNER Table/Procedure/Type Null None<br />
23 SYS DBMS_SYS_SQL Body Null None<br />
23 XDB DBMS_XDBZ0 Body Null None<br />
23 SYS XML_SCHEMA_NAME_PRES Table/Procedure/Type Null None<br />
ENT<br />
23 SYS DBMS_SYS_SQL Table/Procedure/Type Null None<br />
23 SYS DBMS_OUTPUT Body Null None<br />
23 XDB XDuubYCRNYQDOCOoaecR 25 Share None<br />
Uoig==<br />
23 SYS PLITBLM Table/Procedure/Type Null None<br />
23 SYS XML_SCHEMA_NAME_PRES Body Null None<br />
ENT<br />
23 SYS ORA_PLAN_ID_SEQ$ Table/Procedure/Type Null None<br />
23 SYS UTL_RAW Body Null None<br />
23 SYS UTL_RAW Table/Procedure/Type Null None<br />
23 V1 43 Null None<br />
23 SYS DICTIONARY_OBJ_TYPE Table/Procedure/Type Null None<br />
23 SYS DBMS_ASSERT Body Null None<br />
23 SYS DBMS_SYS_ERROR Table/Procedure/Type Null None<br />
23 sqle VIRTUAL_TABLE Table/Procedure/Type Null None<br />
23 SYS DBMS_UTILITY Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_UTIL Table/Procedure/Type Null None<br />
23 SYS DBMS_RANDOM Body Null None<br />
23 sqle PIVOT Table/Procedure/Type Null None<br />
23 SYS DBMS_FLASHBACK Body Null None<br />
23 SYS DATABASE 18 Null None<br />
23 SYS DBMS_SQL Body Null None<br />
23 XDB XD8Vf3vgTDR1aSQOGkEt 25 Share None<br />
R2uQ==<br />
23 SYS DBMS_OUTPUT Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_INT Body Null None<br />
23 SYS DBMS_APPLICATION_INF Table/Procedure/Type Null None<br />
O<br />
23 SYS STANDARD Body Null None<br />
23 XDB XDh1jUheYAR5PgNAgAIL 25 Share None<br />
JCxg==<br />
23 SYS AW_DROP_PROC Table/Procedure/Type Null None<br />
23 SYS DBMS_LOB Table/Procedure/Type Null None<br />
23 SYS IDGEN1$ Table/Procedure/Type Null None<br />
23 XDB XDbD/PLZ01TcHgNAgAII 25 Share None<br />
egtw==<br />
23 sqle sqle 18 Null None<br />
23 XDB XDB$EXTNAME2INTNAME Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA Table/Procedure/Type Null None<br />
23 SYS DBMS_SYS_ERROR Body Null None<br />
23 SYS DBMS_SQL Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_UTIL Body Null None<br />
23 SYS DBMS_XPLAN Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA Body Null None<br />
23 SYS DBMS_FLASHBACK Table/Procedure/Type Null None<br />
23 sqle COMPANY_LISTING Table/Procedure/Type Null None<br />
23 XDB DBMS_XDBZ0 Table/Procedure/Type Null None<br />
23 SYS DBMS_XPLAN Body Null None<br />
23 SYS DBMS_UTILITY Body Null None<br />
23 SYS XMLTYPE Table/Procedure/Type Null None<br />
23 SYS DBMS_APPLICATION_INF Body Null None<br />
O<br />
23 sqle EMP_SEQ Table/Procedure/Type Null None<br />
23 SYS DBMS_METADATA_INT Table/Procedure/Type Null None<br />
23 SYS OBJECT_GRANT Table/Procedure/Type Null None<br />
23 SYS DICTIONARY_OBJ_NAME Table/Procedure/Type Null None<br />
23 SYS XMLTYPE Body Null None<br />
23 sqle REMOVE_CONSTANTS Table/Procedure/Type Null None<br />
23 SYS DBMS_LOB Body Null None<br />
23 SYS DBMS_ASSERT Table/Procedure/Type Null None<br />
96 rows selected.<br />
SQL><br />
SQL> --<br />
</source></div>
Admin