单项选择题
Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.
You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA,
which configuration would you set to support more than 1,500 connections at a time()
A.You would configure more listeners for the database.
B.You would configure the database in shared server mode to use the connection pooling feature.
C.You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D.You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
相关考题
-
单项选择题
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database()
A.Cluster
B.Database link
C.Mapping table
D.Materialized view -
单项选择题
Inwhichsituationwouldyouusestaticdatabaseregistrationforalistener()
A.when multiple databases are to be registered with the listener
B.when DBAs need to connect remotely to start up the database instance
C.when users need to connect the database instance using the host naming method
D.when the database instance that is to be registered with the listener is configured in shared server mode -
多项选择题
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener()
A.The ORCL instance is registered dynamically with the listener.
B.The ORCL instance is registered statically in the listener.ora file.
C.The number of current client connections handled by the service handler is two.
D.The total number of client connections handled so far by the service handler is two.
