Oracle分散问题记录

Oracle 的 RAC方式 在weblogic数据源URL的串：

jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST= 172.25.13.102)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.103)(PORT = 1521))(load_balance=yes)(failover=yes))(connect_data=(service_name= dxoa)(instance_name=dxoa1)(instance_name=dxoa2)))

 

jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST= 172.25.13.102)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.103)(PORT = 1521))(load_balance=yes)(failover=yes))(connect_data=(service_name= dxoa)(instance_name=dxoa1)(instance_name=dxoa2)))

 

Oracle死锁解释：

http://www.itpub.net/thread-1504680-1-1.html

Oracle生成AWR报告：

http://www.rickyzhu.com/421_generate-awr-rpt.html

创建表空间:

create tablespace t9hwzx datafile '+DG1' size 500M  -------- DG1 是存储名称

select name  from  v$datafile;  ----查询表空间的存储列表

Linux下批量杀掉 包含某个关键字的 程序进程:

http://www.myexception.cn/linux-unix/414348.html 

eg:ps -ef|grep LOCAL=NO|grep -v grep|cut -c 9-15|xargs kill -9

 Oracle的sql语句优化：

http://www.doc88.com/p-995525531417.html

plsql误删除表的恢复语句

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;  -- 执行此句查出 original_name

flashback table "BIN$1CCI3RgkGu3gQBmsZQ0kkQ==$0" to before drop;  --- 将original_name 替换引号中的值

 

详细讲解见：http://althars.iteye.com/blog/216164