The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective?()
A、set the SESSIONS to 1 in the parameter file
B、grant SINGLE SESSION privilege to all of the users
C、set the SESSIONS_PER_USER to 1 in the users’ profile
D、grant RESTRICTED SESSION privilege to all of the database users
E、create a role with SINGLE SESSION privilege and assign the role to the users
相关问题推荐
-
论述服务提供全过程的三个阶段的质量管理的联系与区别。
-
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()
A、 SET_JOB_ARGUMENT_VALUE
B、 SET_JOB_VALUE_ANYDATA
C、 SET_JOB_ANYDATA_VALUE
D、 SET_SPECIAL_JOB_VALUE
E、 SET_JOB_ANYTYPE_VALUE
-
画一直线的平行线可用多种方法,下列哪种方法不适合()。
A、偏移或直接复制COPY
B、用直线命令画线,使用平行捕捉
C、构造线画线
D、移动
-
什么是数据库营销。
-
设置为默认的打印机其图标()。
A、反向显示
B、左上角有一个标记
C、右上角有一个标记
D、左下角有一个小箭头