转载:http://blog.csdn.net/robinson1988/article/details/7836338性能优化最好的书就是官方文档。官方文档每一句话都值得引起我们深思。Allocation UnitsWhen you create a disk group, you can set the Oracle ASM allocation unit size withthe AU_SIZE disk group attribute. The values can be 1, 2,...【阅读全文】
昨天,一个朋友需要修改Oracle所在服务器的系统时间,问我是否需要重启oracle。我也拿不准,专门去MOS查了查,确实需要重启数据库,不然对sysdate和调度job都有影响。What is the Impact on the Database When Modifying the OS Date? (文档 ID 559660.1)APPLIES TO:Oracle Database - Enterprise Edition - Vers...【阅读全文】
select * from dba_ind_columns where table_owner = 'PIONEER' and table_name in (select table_name from (select table_name,count(*) from dba_ind_columns where table_owner = 'PIONEER' and column_name in (select a.column_name from (select column_name, count(*) ...【阅读全文】
一、原环境点击(此处)折叠或打开OS:Red Hat Enterprise Linux Server release 6.5 (Santiago) 数据库版本:11G R2 11.2.0.4(RAC) 2节点#rac1192.168.2.101 test110.0.0.101 test1priv192.168.2.103 ...【阅读全文】