敗家貓

測試環境
os:win2k
oracle:10.0.2

...繼續閱讀

os:win2000
oracle:10.0.2 ...繼續閱讀

損壞:只有datafile損壞
os:win2000
oracle:10.0.2 ...繼續閱讀

Windows does not implicitly support inheritance of network endpoints. To do this, the registry entry USE_SHARED_SOCKET must be set to TRUE to allow multiple connections to use a single socket. When the value is FALSE (default), bequeath connections are not possible so a redirect session is initiated instead. If the USE_SHARED_SOCKET entry is set to TRUE, Windows can initiate bequeath connections but there are some caveats to consider. If a number of connections are initiated and for some reason the listener is stopped, the listener will not be able to be restarted until the connections are cleared. This is because the existing connections are using the same port number that the listener needs to listen on. This is a limitation with Microsoft’s implementation of TCP/IP using Windows Sockets API (WINSOCK2).

...繼續閱讀

我只貼出重點，全文請到原作那裏看

數據導入方法	總體導入時間(秒)	導入進程佔用CPU時間(秒)
逐條數據插入INSERT	172	52
逐條數據插入INSERT，表暫無索引	130	35
批量插入，表暫無索引	14	7
Create As Select，使用Oracle9i的External Table	15	8
INSERT Append as SELECT，使用Oracle9i的External Table	15	8
SQL*Loader conventional path 缺省導入選項	81	12
SQL*Loader direct path 導入選項	9	3

...繼續閱讀

使用時機多半是用來把其他的資料庫的資料、文字檔匯入oracle中，或是把較舊的oracle板本裡的資料匯入較新的板本中

測試環境
OS:win2000
ORACLE:10.0.2

操作重點
1、確認執行動作的用戶有權限進行
2、目地table要先建立
3、control檔內容要正確 ...繼續閱讀

fast_start_mttr_target允許DBA指定數據庫進行崩潰恢復需要的秒數。
實際上這個參數被轉化為設置參數FAST_START_IO_TARGET,LOG_CHECKPOINT_INTERVAL兩個參數。這個特性大大簡化了限定數據庫恢復時間，並增加了準確性。ast_start_mttr_target是一個動態參數，可以在線修改。例如：
alter system set fast_start_mttr_target =60;
在一個單實例數據庫配置中fast_start_mttr_target的值是一個估測的崩潰平均恢復時間。在rac裡。最壞的情況下，實例崩潰恢復時間是所有的在open
(read/write open)狀態的實例的fast_start_mttr_target參數值的和。但是實際的恢復時間會少一些因為初始化和文件打開只需要做一次。 ...繼續閱讀

os:win2000
oracle:10.0.2

...繼續閱讀

 os:win2000
oracle:10.0.2
...繼續閱讀

os:win2000
oracle:10.0.2
...繼續閱讀