to ruihuahan 不是批量插入to hjx000 database buffer已经调到300M了
查看一下dba_tablespaces,比如: snoopy@cwgl94>select TABLESPACE_NAME,EXTENT_MANAGEMENT,ALLOCATION_TYPE,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;TABLESPACE_NAME EXTENT_MAN ALLOCATIO SEGMEN ------------------------------ ---------- --------- ------ SYSTEM LOCAL SYSTEM MANUAL UNDOTBS1 LOCAL SYSTEM MANUAL TEMP LOCAL UNIFORM MANUAL CWMLITE LOCAL SYSTEM AUTO DRSYS LOCAL SYSTEM AUTO EXAMPLE LOCAL SYSTEM AUTO INDX LOCAL SYSTEM AUTO ODM LOCAL SYSTEM AUTO TOOLS LOCAL SYSTEM AUTO USERS LOCAL SYSTEM AUTO XDB LOCAL SYSTEM AUTO CWGLTS LOCAL SYSTEM MANUAL已选择12行。
我的结果如下,有问题吗TABLESPACE_NAME EXTENT_MAN ALLOCATIO SEGMEN ------------------------------ ---------- --------- ------ SYSTEM DICTIONARY USER MANUAL UNDOTBS LOCAL SYSTEM MANUAL CWMLITE LOCAL SYSTEM MANUAL DRSYS LOCAL SYSTEM MANUAL EXAMPLE LOCAL SYSTEM MANUAL INDX LOCAL SYSTEM MANUAL TEMP LOCAL UNIFORM MANUAL TOOLS LOCAL SYSTEM MANUAL USERS LOCAL SYSTEM MANUAL MYORACLE LOCAL SYSTEM MANUAL已选择10行。
不是批量插入to hjx000
database buffer已经调到300M了
snoopy@cwgl94>select TABLESPACE_NAME,EXTENT_MANAGEMENT,ALLOCATION_TYPE,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;TABLESPACE_NAME EXTENT_MAN ALLOCATIO SEGMEN
------------------------------ ---------- --------- ------
SYSTEM LOCAL SYSTEM MANUAL
UNDOTBS1 LOCAL SYSTEM MANUAL
TEMP LOCAL UNIFORM MANUAL
CWMLITE LOCAL SYSTEM AUTO
DRSYS LOCAL SYSTEM AUTO
EXAMPLE LOCAL SYSTEM AUTO
INDX LOCAL SYSTEM AUTO
ODM LOCAL SYSTEM AUTO
TOOLS LOCAL SYSTEM AUTO
USERS LOCAL SYSTEM AUTO
XDB LOCAL SYSTEM AUTO
CWGLTS LOCAL SYSTEM MANUAL已选择12行。
------------------------------ ---------- --------- ------
SYSTEM DICTIONARY USER MANUAL
UNDOTBS LOCAL SYSTEM MANUAL
CWMLITE LOCAL SYSTEM MANUAL
DRSYS LOCAL SYSTEM MANUAL
EXAMPLE LOCAL SYSTEM MANUAL
INDX LOCAL SYSTEM MANUAL
TEMP LOCAL UNIFORM MANUAL
TOOLS LOCAL SYSTEM MANUAL
USERS LOCAL SYSTEM MANUAL
MYORACLE LOCAL SYSTEM MANUAL已选择10行。
减少些REDO生成,逻辑读也大量下降。如果确实是索引影响太大,能不能先删索引,插入后再重建索引。