⌘KCtrl+K 快速搜索

> 文章列表 / Page 263

2011-08-08

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. Solutions During a period of wait, use the...
#POST 2 MIN READ
2011-08-08

DB Commit Time

Average number of milliseconds waiting for the "log file sync" event, indicating commit times for this database. Solutions If this is high, review solutions presented in the help file for "log ...
#POST 1 MIN READ
2011-08-08

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...
#POST 1 MIN READ
2011-08-08

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...
#POST 3 MIN READ
2011-08-08

Buffer Cache Hit Ratio

Solution By 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 u...
#POST 1 MIN READ
2011-08-08

enq: JI - contention等待事件

Sessions waiting on this event are waiting on locks held during materialized view operations (such as refresh, alter) to prevent concurrent operations on the same materialized view. Solutions A materi...
#POST 3 MIN READ
2011-08-06

【日常管理】Asm Diskgroup增加磁盘add disk

show parameter power alter system set asm_power_limit=0; alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA28'; alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/...
#POST 3 MIN READ
2011-08-05

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

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

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

以下脚本用于列出用户表空间的使用量和定额: PROMPT Print the details of the Users Tablespace Quotas TTITLE left _date center ' Database Users Space Quotas by Tablespace' skip 2 Quotas by Tablespace" COL un format a25 headi...
#POST 4 MIN READ