1.先去监听日志的目录里面并查看大小 cd $ORACLE_HOME/network/log/ du -sh *2.到listener里面,查看对应的log_file和log_status [oraarp@localhost log]$ lsnrctl LSNRCTL> show log_file &nbs...【阅读全文】
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5753417.html某库数据库检查表空间大小的时候非常慢检查其其执行计划:SQL> set timing onSQL> set autot onSQL> set linesize 120SQL> /Elapsed: 00:01:45.55Execution Plan----------...【阅读全文】
一个朋友问如何设置Oracle闪回区大小,有什么依据没有。查证官方文档,有如下描述For example, if you intend to setDB_FLASHBACK_RETENTION_TARGET to 24 hours, and if the database generates 20 GB of redo in a day, then a rule of thumb is to allow 20 GB to 30 GB disk space for the flashback logs....【阅读全文】
转载: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,...【阅读全文】
环境:RHEL5.8 RAC 11.2.0.3.01:查看ORC和voting disk信息:In 11g Release 2 your voting disk data is automatically backed up in the OCR whenever there is a configuration change.所以恢复时恢复备份OCR即可,这里和10g是不同的,不需要备份voting disk,备份OCR即可2:使用cluvfy 工具检查OCR完整...【阅读全文】