单项选择题

A.V$SESSION B.V$SYSSTAT C.DBA_SEGMENTS D.V$SORT_USAGEYo……

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

A.V$SESSION
B.V$SYSSTAT
C.DBA_SEGMENTS
D.V$SORT_USAGE

<上一题目录下一题>

热门试题

单项选择题Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?（）

A.DBA_TABLESPACES
B.DBA_TABLES
C.DBA_SEGMENTS
D.DBA_FREE_SPACE

单项选择题Bydefault,checkpointshappenatleastasoftenas（）.

A.Redo log switches.
B.UPDATE statements are issued against the database.
C.The SYSTEM tablespace is accessed.
D.SMON coalesces free space in a tablespase.

单项选择题Whichofthefollowingchoicesidentifiesadatabasecomponentthatwillbeusedfor multiplexingcontrolfiles?（）

A.V$CONTROLFILE
B.V$DATABASE
C.init.ora
D.DBA FILES

单项选择题Flushingdirtybuffersoutofthebuffercacheisinfluencedtothegreatestextentbywhichofthefollowingprocess?（）

A.ARCH
B.SMON
C.LGWR
D.SERVER

单项选择题WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）

A.Buffer cache
B.Redo log buffer
C.Private SQL area
D.Library cache
E.Row cache