ONãæå®ããã¨ããªã«ããªæã«å¿ è¦ãªã¢ã¼ã«ã¤ãREDOãã°ã»ãã¡ã¤ã«ã®ããã©ã«ãã®ãã¡ã¤ã«åãèªåçã«é©ç¨ããããã«RECOVERã³ãã³ããè¨å®ããã¾ãã
ONãæå®ããã¨ããªã«ããªæã«å¿ è¦ãªã¢ã¼ã«ã¤ãREDOãã°ã»ãã¡ã¤ã«ã®ããã©ã«ãã®ãã¡ã¤ã«åãèªåçã«é©ç¨ããããã«RECOVERã³ãã³ããè¨å®ããã¾ãã
ãããã®é ç®ã«åºåãããå¤ã¯ã親ã¹ãããï¼SORTå¦çï¼ã®å¤ã¨åã¹ãããï¼TABLE ACCESSå¦çï¼ã®å¤ã¨ã®åè¨å¤ã«ãªãã¾ãããã®ãããåã¹ãããã§ã®å¦çæéãã¢ã¯ã»ã¹ããããããã¯æ°ãªã©ã®æ å ±ã¯ãã¹ããããã¨ã®å·®åããèªã¿åãå¿ è¦ãããã¾ãã å³1ã®ï¼10ï¼ããtimeãã®å¤ãä¾ã«æãã¦èª¬æããã¨ãæåã®ã¹ãããã§ããTABLE ACCESS FULLã¯ãã60530996ãã§ããããã®å¤ãå ¨è¡¨ã¹ãã£ã³ã«ããã£ãæéã«ãªãã¾ããæ¬¡ã®ã¹ãããã§ããSORT GROUP BYã¯ãã62654805ãã¨ãªã£ã¦ãã¾ããããã®å¤ã«ã¯åã¹ãããã®TABLE ACCESS FULLã®å¤ãå«ã¾ãã¦ãã¾ãããã®ãããç´ç²ãªSORT GROUP BYã®çµéæéã¯ãã62654805 - 60530996 = 2123809ããããªãã¡ç´2.1ç§ã§ãã£ããã¨ãåããã¾ãã TKPROFå®è¡æã®å®è¡è¨ç»ã®è¦
æè¿ã¯ã¹ãã¢ãããã·ã¼ã¸ã£ãªã©ã®éçºã«ã¯å°ãOBJECT BROWSERã使ç¨ãã¦ããã®ã§ãSQLã§ã¹ãã¢ãããã·ã¼ã¸ã£ã®ã½ã¼ã¹ã確èªããæ¹æ³ãªã©ãã£ããå¿ãã¦ãã¾ã£ã¦ãã¾ããã 人ã«èããã¦æ¹ãã¦èª¿ã¹ã¦ã¿ãã®ã§ããã以ä¸ã®SQLãå©ãã¦ãã£ã¯ã·ã§ããªãåç §ãããããªãããã§ãã ï¼SQL*Plusã®ã³ãã³ãããã£ããããªæ°ãããã®ã§ããï¼ï¼ï¼ããã¯æ°ã®ããã ã£ãããã§ããï¼ SQLã§ããã·ã¼ã¸ã£ã®ã½ã¼ã¹ã確èªãã select text from {all_source|dba_source|user_source} where name = procedure_name order by line; ä¾ãã°ã以ä¸ã®ããã«ç¢ºèªãã¾ãã SQL> select text from user_source where name = 'TEST_PROC' order by line; TEX
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ãç¥ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}