Unformatted text preview: view would show contention for
V$QUEUE view is used show contention for server processes in MTS configuration.
B: V$CIRCUIT view is not used to show contention for server processes. This view shows
information for users with shared server connections.
C: V$SESSION view lists session information for each current session. Links SID to other
session attributes. Contains rows lock information.
D: DBA_USERS view shows information about all users of Oracle database.
E: There is no V$CONNECTION view in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 858-859.
Chapter 18: Tuning Memory and Operating System Use
Which class of data describes to Oracle Expert how the database is used in daily
A. Schema class
B. Workload class
C. Instance class
D. Environment class
Workload class in Oracle Expert describes how the database is used in daily operations.
A: Schema class is used to describe schema structure, not database daily operations usage.
C: Instance class is not used for these purposes.
D: Environment class of Oracle Expert is not used for these purposes. Actualtests.com - The Power of Knowing 1Z0-024
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 961-968.
Chapter 20: Tuning Other Areas of the Oracle Database
On a database that is running Multithreaded server, which view would you query to get
information for users with shared server connections?
V$CIRCUIT view shows information for users with shared server connections
B: DBA_USERS view shows information about all users of Oracle database.
C: There is no DBA_CIRCUIT view in Oracle.
D: V$DISPATCHER_USERS view does not exist in Oracle.
E: There is no DBA_DISPATCHERS_USERS view in Oracle.
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide