网上很多关于这个错误的文章,有些还引用了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(*) ...【阅读全文】
oracle中查询表的信息,包括表名,字段名,字段类型,主键,外键唯一性约束信息,索引信息查询SQL如下,希望对大家有所帮助:1、查询出所有的用户表select * from user_tables 可以查询出所有的用户表select owner,table_name from all_tables; 查询所有表,包括其他用户表通过表名过滤需要将字母作如下处理se...【阅读全文】