정짱의 작은 도서관

[Oracle] 점검하기 Library Cache Miss RatioExecutions - The number of times a pin was requested for objects of this namespace.Cache Misses - Any pin of an object that is not the first pin performed since the object handle was created, and which requires loading the object from disk. Hit Ratio 1% 미만이어야 한다. 그렇지 않으면 init.ora 에서 SHARED_POOL_SIZE 가 증가한다. SQL> SELECT sum(PINS) Executions, sum(RELOADS) cach..