Oracle和MySQL - 博客园

CRS-4258: Addition and deletion of voting files are not allowed because the voting files are on ASM

摘要：客户的一套11.2.0.1 RAC系统采用ASM diskgroup 存放ocr和votedisk，该REG diskgroup中的某个LUN disk由于硬件的原因损坏了，导致冗余的votedisk表决磁盘有一个处于OFFLINE状态，客户希望能删除该OFFLINE的votedisk并新增一个可用的。在删除该votedisk文件时出现了CRS-4258的错误，错误如下:crsctl query ... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(982) 评论(0) 推荐(0)

OPatch工具相关的环境变量

摘要： ORACLE_HOME - This is the Oracle home location. OPATCH_DEBUG - This is the log level that specifies the amount of logging OPatch should perform. OPATCH_PLATFORM_ID - This is the unique platform ID. P... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(269) 评论(0) 推荐(0)

Script:列出用户表空间的定额

摘要：以下脚本用于列出用户表空间的使用量和定额:PROMPT Print the details of the Users Tablespace QuotasTTITLE left _date center ' Database Users Space Quotas by Tablespace' skip 2 Quotas by Tablespace"COL un format a25... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(190) 评论(0) 推荐(0)

利用ProcDump工具诊断Windows平台上的Oracle数据库性能

摘要： ProcDump与Procexp一样是Windows平台上的内部调试工具，Procexp采用图形界面体现系统整体及个别进程的性能信息，而ProcDump则与我们在Unix平台上使用的性能分析工具类似使用CLI命令行界面。Procdump目前的版本号为3.04，可以从其Homepage上下载到该工具，该监控软件由Mark Russinovich开发，是一款Free Software。其官方介绍如下:... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(348) 评论(0) 推荐(0)

Restore Production Database to Development Platform A step-by-step example

摘要： Overview of setup and configuration Oracle Enterprise Edition 11gR2. 11.2.0.1.0 Linux RH5 NetBackup 6.5.5 Identical environments: Identical versions of Oracle. Same ORACLE_HOME and ORACLE_BASE. The ar... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(141) 评论(0) 推荐(0)

Buffer Cache Hit Ratio

摘要： 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... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(166) 评论(0) 推荐(0)

Cardinality

摘要： 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... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(193) 评论(0) 推荐(0)

Oracle Compressed Indexes

摘要： 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... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(147) 评论(0) 推荐(0)

DB Commit Time

摘要： 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... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(206) 评论(0) 推荐(0)

DFS lock handle等待事件

摘要： 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... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(649) 评论(0) 推荐(0)