單項(xiàng)選擇題

View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities：
SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0；
What do you infer from this（）

A.The database instance is running with manual PGA management.
B.The database instance is running with manual shared memory management.
C.The database instance has the MEMORY_TARGET value set to a nonzero value.
D.All sessions are connected to the database instance in dedicated mode， and no RMAN or parallelquery operations have been performed.

你可能感興趣的試題

單項(xiàng)選擇題

Automatic Shared Memory Management （ASMM） has been enabled for your database instance.
Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；
Which statement is true in this scenario（）

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

單項(xiàng)選擇題

View the Exhibits and examine lock waits.

Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）

A.Kill the session of the user SCOTT with session ID118.
B.Issue manual checkpoint using the ALTER SYSTEM command.
C.Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
D.Flush the Shared Pool to remove the SQL statement causing "wait" in memory.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response. Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

View the Exhibits and examine lock waits.

Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）