ORACLE NOTES
文章平均质量分 67
wayne_lau
这个作者很懒,什么都没留下…
展开
-
alter table move的用途
降低HWM,消除行移植和行链接。我们可以用下面的办法来最方便的进行重组,消除row migration: SQL> alter table t add t1 date default sysdate; Table altered. SQL> c/t1/t2 1* alter table t add t2 date default sysdate SQL> / Table altered. SQL>原创 2005-09-20 08:30:00 · 7835 阅读 · 1 评论 -
DBMS_STATS summary
Summary of DBMS_STATS SubprogramsTable 70-1 DBMS_STATS SubprogramsSubprogramDescriptionPREPARE_COLUMN_VALUES ProcedureConverts user-specified minimum, maximum, and histogram endpoint datatype-specifi原创 2005-09-23 22:19:00 · 1638 阅读 · 0 评论 -
CBO Access Path
Access Paths are ways in which data is retrieved from the database.FTS:All adjacent blocks under the HWM are sequentially scanned.Use large I/O calls(DB_FILE_MULTIBLOCK_READ_COUNT).The CBO choose FTS原创 2005-09-19 22:55:00 · 717 阅读 · 0 评论 -
My idea about the organization about block buffer cache
Organization of the Database Buffer Cache The buffers in the cache are organized in two lists: the write list and the leastrecently used (LRU) list. The write list holds dirty buffers, which contai原创 2005-09-15 21:18:00 · 855 阅读 · 0 评论 -
Transport tablespace at OS level
SQL> alter tablespace test_ts read only;表空间已更改。SQL> host exp userid=sys/admin as sysdba transport_tablespace=y tablespaces=test_ts file=test.dmp;Export: Release 9.2.0.1.0 - Production on 星期四 9月 15 1原创 2005-09-15 18:56:00 · 643 阅读 · 0 评论 -
分割字符串的sql
set ver off def Del=@ def String="@0@11@222@3333@44444@555555@6666666@77777777@888888888" select Rownum Row#, SUBSTR(A.Str||&Del , INSTR(A.Str||&Del , &Del, 1, Rownum ) +1 , INSTR(A.Str||&Del原创 2005-09-22 08:26:00 · 1343 阅读 · 0 评论