摘要:
(非归档模式下)创建表T01:SQL> create table t01 as select * from dba_objects where 1=2;Table created.(非归档模式下)查看当前redo大小:SQL> select value 2 from v$mystat,v$statn... 阅读全文
摘要:
1、在pl/sql中打开cmd命令容器2、在cmd命令窗口中输入:explain plan for select * from t;3、查看sql语句的执行计划:select * from table(dbms_xplan.display);MISSES IN library cache durin... 阅读全文