把语句提取后,加入些提示,让解析器重新执行SELECT /*+ gather_plan_statistics test111 */ ...执行2分钟后 Ctrl +C 中断 ##获取SQL_IDset linesize 200 pagesize 100select sql_id,sql_text from v$sqlarea where sql_text like '%test111%' and sql_text not like '%sqlarea%'; ##打印执...【阅读全文】
1、构造测试环境SYS@vbox66in>create table test1 ( 2 id number not null, 3 num number, 4 val varchar2(100));表已创建。SYS@vbox66in>SYS@vbox66in>create table test2 ( 2 id number not null, 3 t1_id number not null, 4 num number, 5 val varchar2(100));表已创建。SYS@vbox66in> SYS@vbox66in>exec...【阅读全文】
3、Which structure can span multiple data files?A) a permanent tablespaceB) a bigfile tablespaceC) a temporary tablespaceD) a segmentE) an extentAnswer:ACD【阅读全文】
2、Which two are true about Optimizer Statistics?? A) They do not persist across Instance restarts.? B) They are automatically updated when DDL statements execute.? C) They are gathered by the Manageability Monitor (MMON) background process.? D) They can be gathered by executing th...【阅读全文】