Oracle 캐시 적중률 측정
Computer/IT/DBMS 2007/10/10 15:29 |SELECT 1 - (phy.value - lob.value - dir.value)
/ ses.value "CACHE HIT RATIO"
FROM v$sysstat ses, v$sysstat lob,
v$sysstat dir, v$sysstat phy
WHERE ses.name = 'session logical reads'
AND dir.name = 'physical reads direct'
AND lob.name = 'physical reads direct (lob)'
AND phy.name = 'physical reads'
/
'Computer/IT > DBMS' 카테고리의 다른 글
| KEEP 버퍼풀 지침 (0) | 2007/10/10 |
|---|---|
| Oracle 영역별 HIT RATIO (0) | 2007/10/10 |
| Oracle 캐시 적중률 측정 (0) | 2007/10/10 |
| Northwind and pubs Sample Databases for SQL Server 2000 (0) | 2007/10/09 |
| [ORACLE] SharedServer 및 Dispatchers 확인 (0) | 2007/03/19 |
| ORACLE 에서 잠긴 계정 풀기 (1) | 2007/03/16 |
TAG oracle 9
댓글을 달아 주세요