(119)View the Exhibit and examine the output of the query.
What do you infer from this?
A.The SGA_TARGET is a static parameter.
B.The instance is started, but the database is not yet open.
C.The server parameter file (SPFILE) was used to start the instance.
D.The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.
答案:(C)
解析:
V$SPPARAMETER显示关于服务器参数文件的内容. 如果没用使用spfile来启动实例,则在视图的每行的ISSPECIFIED列的值都为FALSE.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1192221/ ,如需转载,请注明出处,否则将追究法律责任。