网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

YourSPFILEcontainsthefollowingparametersettings：

SGA_TARGET=8G

DB_CACHE_SIZE=4G

SHARED_POOL_SIZE=2G

LARGE_POOL_SIZE=512M

JAVA_POOL_SIZE=512M

LOG_BUFFER=100M

SGA_MAX_SIZE=10G

YouquerytheV$SGA_DYNAMIC_COMPONENTSdynamicperformanceviewanddiscoverthatthelargepoolcomponentiscurrentlysizedat1G.YouwantthevalueoftheSGA_TARGETinitializationparameterto10G，butinsteadofspecifyingavalueof10GfortheSGA_TARGETinitializationparameter，youerroneouslyexecutethefollowingstatement：

SQL>ALTERSYSTEMSETSGA_TARGET=0SCOPE=BOTH；

Whatistheresultofthisstatement？（）

参考答案

更多 “ YourSPFILEcontainsthefollowingparametersettings：SGA_TARGET=8GDB_CACHE_SIZE=4GSHARED_POOL_SIZE=2GLARGE_POOL_SIZE=512MJAVA_POOL_SIZE=512MLOG_BUFFER=100MSGA_MAX_SIZE=10GYouquerytheV$SGA_DYNAMIC_COMPONENTSdynamicperformanceviewanddiscoverthatthelargepoolcomponentiscurrentlysizedat1G.YouwantthevalueoftheSGA_TARGETinitializationparameterto10G，butinsteadofspecifyingavalueof10GfortheSGA_TARGETinitializationparameter，youerroneouslyexecutethefollowingstatement：SQLALTERSYSTEMSETSGA_TARGET=0SCOPE=BOTH；Whatistheresultofthisstatement？（） ” 相关考题
热门标签
最新试卷