1. 切换至grid用户[root@Zracnode1 ~]# su - grid2.查看CRS状态(目前Oracle11GR2官方文档,不建议用如下命令检测了,等我有时间在整理补充)[grid@Zracnode1 ~]$ crs_stat -tName Type Target State Host &n...【阅读全文】
网上很多关于这个错误的文章,有些还引用了Oracle文档中的说明。Setting Memory Target at Instance Startup on Linux Starting with Oracle Database 11g Release 1 (11.1), Oracle provides the option of automatically managing SGA and PGA with a combined MEMORY_TARGETparameter without having to set SGA_...【阅读全文】
转载: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,...【阅读全文】
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(*) ...【阅读全文】