set linesize 350;PROMPTPROMPT=======================================================PROMPT= Oracle CheakPROMPT=======================================================PROMPTPROMPTPROMPT=======================================================PROMPT= 1. Library Cache Miss RatioPROMPT=======================================================PROMPTselect sum(reloads) MISSES, sum(pins), to _char(sum(reload..
[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..
- Total
- Today