-
编辑 删除
linux安装10g/11g
一、操作系统准备 首先virtual box安装加强功能，把操作系统分辨率提高。mount Oracle Linux 5.7的iso文件作为yum源，我的做法如下：[root@db media]# mount/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)proc on /proc type proc (rw)sysfs on /sys type sysfs (rw)devpts on /dev/pts type devpts (r...
-
编辑 删除
oracle执行计划--003
SH: sale historyexplain plan forSELECT prod_category, AVG(amount_sold)FROM sh.sales s, sh.products pWHERE p.prod_id = s.prod_idGROUP BY prod_category;select * from table(dbms_xplan.display);select * from table(dbms_xplan.display('',null,'ALL'));select * from table(dbms_xplan.display('',null,'basic +cost +predicate'));select * from table(dbms_xplan.display('',null,'typical -cost -bytes'));select * from table(dbms_xplan.display('',null,'basic +note'));
-
编辑 删除
oracle执行计划--002
SH: sale historyexplain plan forSELECT prod_category, AVG(amount_sold)FROM sh.sales s, sh.products pWHERE p.prod_id = s.prod_idGROUP BY prod_category;select * from table(dbms_xplan.display);select * from table(dbms_xplan.display('',null,'ALL'));select * from table(dbms_xplan.display('',nul...
-
编辑 删除
oracle执行计划-001
查看数据库执行计划：参考资料：http://www.jb51.net/article/30465.htmhttp://www.cnblogs.com/jianggc/articles/2029854.html1，pl/sql developer f52, sqlplusSQL>EXPLAIN PLAN FOR SELECT * FROM SCOTT.EMP; SQL>SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);3, autotraceset autotrace traceo...
-
编辑 删除
分页查询，分页列最好非空且创建索引。
11:34:48 SQL> set autot off11:34:51 SQL> set autot traceonly11:34:56 SQL> drop table t;表已删除。已用时间: 00: 00: 01.0311:35:22 SQL> purge recyclebin;回收站已清空。已用时间: 00: 00: 00.5411:35:36 SQL> set time on timing on11:36:05 SQL> create table t as select ...
