âãã¥ã¼ãã³ã°ã®æ¦è¦ ãã¥ã¼ãã³ã°æé ã¯ã è¨è¨ãappãã¡ã¢ãªãI/Oãç«¶åãOSã çµ±è¨æ å ±ã¯V$SYSSTAT, V$SESSTAT, V$MYSTATãV$SYSSTATã¯ã¤ã³ã¹ã¿ã³ã¹èµ·åããã®ç´¯ç© ã¦ã¼ã¶ã¼ã»ãã¬ã¼ã¹ã»ãã¡ã¤ã«ã¯ãµã¼ãã¼ããã»ã¹åä½ã«ä½æããã (ã¦ã¼ã¶ã¼ããã»ã¹åä½ã§ã¯ãªã) å ±æãã¼ã«ãã©ã¼ã¸ãã¼ã«ãJavaãã¼ã«ã®ç©ºãã¡ã¢ãªã®ç¢ºèªã«ä½¿ãã®ã¯ V$SGASTAT V$SESSION_WAITã§WAIT_TIME=0ã®å ´åã¯ç¾å¨å¾ æ©ä¸ããã®æéãåããåã¯SECONDS_IN_WAIT å ±æã¡ã¢ãªãæçåãã¦ããå ±æã¡ã¢ãªãä¸è¶³ã¨ããã¨ã©ã¼ã«ãªãã(ORA-04031) âã¦ã¼ãã£ãªã㣠STATSPACKã§ãã¼ã¯æã«å®è¡ãã¹ãå¦çã¯STATSPACK.SNAP STATSPACKã®çµ±è¨ãåºåããã«ã¯ã PERFSTATã¦ã¼ã¶ã¼ã§spreport.sqlãå®è¡ã
{{#tags}}- {{label}}
{{/tags}}