- Nov 03 Mon 2014 08:44
oracle冷備份/熱備份/熱備份還原
- Oct 30 Thu 2014 15:00
oracle EXP/IMP
- Oct 24 Fri 2014 15:02
SQL *LOADER
- Oct 23 Thu 2014 11:25
DBA日常作業--表分析沒有更新造成執行計畫分析錯誤
- Oct 17 Fri 2014 16:39
DBA日常作業--索引重組
- Sep 17 Wed 2014 12:50
DBA日常作業--非完整復原-set until time
- Sep 16 Tue 2014 17:09
ORA-01157、01110問题解决
SQL> startup
ORACLE instance started.
- Sep 13 Sat 2014 17:28
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
修改前的hosts文件内容如下:
[root@ ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
修改后的hosts文件内容如下:
[root@ssm ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 ssm localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
- Sep 13 Sat 2014 14:41
oracle常用指令 參考:http://blog.udn.com/foxtail321/4012997
- Sep 13 Sat 2014 14:40
Oracle Select SQL Tuning 查詢效能調整
參考:http://tomkuo139.blogspot.tw/2009/08/oracle-select-sql-tuning.html
參考:http://nathanmint.pixnet.net/blog/post/167287665-sql---%E5%9F%B7%E8%A1%8C%E6%95%88%E8%83%BD%26%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A0%85%EF%BC%9B%E5%BC%95%E7%94%A8%E6%96%87%E7%AB%A0