DataPump Not Using Parallel For Non-privileged Users 使用 expdp/impdp 無法執行 parallel 功能
2022-03-24
2022-03-23
oracle expdp/impdp 使用 parfile 做多表匯出/匯入
oracle expdp/impdp 使用 parfile 做多表匯出/匯入
2022-03-18
Oracle 調整 UID GID，導致 listener 啟動時有 TNS-00525 TNS-12560 TNS-12555 問題之解決方式
Oracle 調整 UID GID，導致 listener 啟動時有 TNS-00525 TNS-12560 TNS-12555 問題之解決方式
2022-03-09
ORA-19809 ORA-19804 when clearning logfile
ORA-19809 ORA-19804 when clearning logfile
2022-03-09
ORA-00600 : [kfdvfGetCurrent_baddsk] While adding failed disk into Voting diskgroup
ORA-00600 : [kfdvfGetCurrent_baddsk] While adding failed disk into Voting diskgroup
2022-03-04
Rolling Forward a Physical Standby Using Recover From Service Command in 12c later
Rolling Forward a Physical Standby Using Recover From Service Command in 12c later
2022-03-03
PRCR-1079 CRS-2971 Cannot run resource on server when on quarantined site
PRCR-1079 CRS-2971 Cannot run resource on server when on quarantined site
2022-02-21
Oracle sql trace event 10046
記錄 Oracle sql trace event 10046 用法
2022-02-19
Oracle PL/SQL 基礎用法 教學
記錄會使用到的 pl/sql 寫法與方式
2022-02-18
Oracle Rebuild index & partition index (plsql)
記錄 oracle plsql rebuild index & partition index script
2022-02-17
Oracle Dataguard Using Snapshot Standby Database
記錄設定與操作 Dataguard Snapshot Standby
2022-02-15
Oracle 19c Active Data Guard 重定向增強讀寫分離 DML Operations from a standby to the primary in Oracle Active Data Guard ( ADG_REDIRECT_DML )
記錄設定，技術過程些功能限制 Oracle 19c Active Data Guard ADG_REDIRECT_DML
2022-02-11
Oracle analyze table or analyze index validate structure failed ORA-00054
Oracle analyze table or analyze index validate structure failed ORA-00054
2022-02-08
Oracle ROWID vs ROWNUM io 比較
測試過程
2022-01-20
Oracle RAC uninstall not complete & manually cleanup
記錄手動清除乾
2022-01-20
Oracle Check Alert Log (shell script)
記錄 script 內容，可依自行需求修改
2022-01-20
Oracle Backup Trace File & AlertLog schedule on Everyday (shell script)
記錄script內容
2022-01-20
ORA-48913: Writing into trace file failed, file size limit [10485760] reached
記錄需要調整的地方以及需要注意的地方
2022-01-13
Oracle login new standby instance on Windows ( ORA-12560 ORA-12523 )
記錄操作與解決的過程
2021-12-10
Oracle ACFS Directory not exists ( CLSU-00107 CLSU-00101 CLSU-00104 ACFS-00502 )
記錄處理過程
- 1
- 2
