You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area (PGA): SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area (SGA) is currently sized at 4G. What is the total PGA memory allocated across all database server processes?()
A、 10M
B、 400M
C、 600M
D、 800M
相关试题
-
A user cannot ping any other hostnames from an AIX machine. The error received is "host name earth NOT FOUND". Which of the following files is most likely configured incorrectly?()
A、/etc/resolv.conf
B、/etc/rc.tcpip
C、/etc/aliases
D、/etc/hosts.equiv
-
A client has a temporary deployment of a new static application that needs to run for a short period of time and is not going to change. How can this deployment be achieved with a minimum of effort and time?()
A、Run a system WPAR and deploy the application.
B、Create a new LPAR and deploy the application.
C、Create an application WPAR to deploy the application.
D、Create an LPAR hosted by a VIO server and deploy the application.
-
在查询中执行数据过滤是通过查询语句的()子句来完成的,通过过滤数据,可以只查询满足要求的数据,减少数据查询的量,提高查询性能。
A、WHERE
B、FROM
C、SUQUERY
D、JOIN
-
SQL的数据更新命令中不包含( )。
A、SET
B、WHERE
C、REPLACE
D、UPDATE
-
根据跨境数据安全保护的要求。因业务需要,确需向境外提供的,不需要经过安全评估。
A、对
B、错