SGA_TARGET Advice

huzhichengforce發表於2013-06-28
SGA_TARGET 
SELECT (
   (SELECT SUM(value) FROM V$SGA) -   (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY)
   ) "SGA_TARGET"
FROM DUAL;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-764997/,如需轉載,請註明出處,否則將追究法律責任。

相關文章