摘要：
查看sql是否被执行计划绑定select sql_profile,sql_plan_baseline from v$sql where sql_id='xx' declare v_hints sys.sqlprof_attr; cl_sql_text clob; wrong_sql_id varch 阅读全文
摘要：
APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform. SY 阅读全文
摘要：
1、分批UPDATEDROP TABLE T2;CREATE TABLE T2 AS SELECT OBJECT_NAME FROM DBA_OBJECTS;SELECT * FROM T2;SELECT COUNT(*) FROM T2;DECLARE TYPE RIDARRAY IS TABLE 阅读全文