摘要： Oracle virtualboxe1 View more documents from Maclean Liu 阅读全文

摘要： SolutionBy itself, the buffer cache hit ratio is not very meaningful except for databases with undersized data buffer cache (db_cache_size parameter).Oracle provides the data buffer cache advisory uti... 阅读全文

摘要： The terms "high cardinality" and "low cardinality" are frequently used when discussing table columns. A high cardinality column means that a column has many unique values. For example, a primary key c... 阅读全文

摘要： Key compressed indexes are a way to index a low cardinality column without talking up as much space storing the repetitive values. Please view the Oracle Manuals for a full description on implementing... 阅读全文

摘要： Average number of milliseconds waiting for the "log file sync" event, indicating commit times for this database. SolutionsIf this is high, review solutions presented in the help file for "log file syn... 阅读全文

摘要： The session waits for the lock handle of a global lock request on the distributed file system (DFS). It is most common in a parallel server situation. SolutionsDuring a period of wait, use the followi... 阅读全文

摘要： Improve DBWR ThroughputTo improve DBWR's throughput, consider the following: Disk capabilities and setup (stripe size, speed, controllers etc...) Using raw devices instead of File System files -- depe... 阅读全文

摘要： To change an init.ora parameter, follow these steps. Open the file called init.ora. For example, if the database is called oraprod, then the file would be called initoraprod.ora. The file can be in a ... 阅读全文

摘要： 得闲做了一个给初学者和开发人员介绍基础概念的PPT,本来还想把前前后后写的SMON功能的帖子汇总到一个PPT里，但是现在要开始忙婚礼的事了，估计这半年里是没空了。。 Basic oracle for developer&beginner View more presentations from Maclean Liu 阅读全文

摘要： 如何重装10g clusterware集群软件?一般情况下我会说把DB、CRS停掉,手动删除ORA_CRS_HOME及/etc(或者/opt)目录下的ora*配置文件，使用dd命令清理LUN的头部。再重装一般就没有问题了，但实践过程中往往会因为清理地不够彻底而出现问题。今天同事问我有没有彻底卸载CRS的文档，到metalink上搜了一圈结果还真没有，最后从Alejandro Vargas' Blo... 阅读全文