单项选择题
Which view will you use to view information regarding the jobs that are currently running in a database？（）
A.DBA_SCHEDULER_RUNNING_JOBS
B.DBA_SCHEDULER_JOB_RUN_DETAILS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG
点击查看答案
相关考题
-
单项选择题
YourecentlycreatedacomplexresourceplannamedDB_PLANthathastwosubplansnamedOLTP_PLANandDSS_PLAN.TheOLTP_PLANandDSS_PLANsubplansareallotted70percentand30percentofthetotalCPUresources，respectively.TheOLTP_PLANsubplanallocates35percentoftheavailableCPUresourcestoaresourceconsumergroupnamedACCT_CLERKS.Accordingtothe OLTP_PLANsubplan，theremaining65percentoftheavailableCPUresourcesisallocatedtoasecondresourceconsumergroupnamedMKT_CLERKS.TheCPUresourcesavailabletotheDSS_PLANsubplanaredividedintotworesourceconsumergroupsnamedMKT_MANAGERSandFIN_MANAGERS.TheMKT_MANAGERSgroupreceives65percentoftheavailableCPUresources，andtheFIN_MANAGERSgroupreceives35percentoftheavailableCPUresources.WhatpercentageofactualCPUresourceswilltheresourceconsumergroup，MKT_CLERKS，receive，iftheDSS_PLANsubplandoesNOTconsumeanyCPUresources？（）
A. 45.5
B. 65
C. 70
D. 100 -
单项选择题
You execute the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN => ’DEPARTMENTS’， CONSUMER_GROUP1 => ’PAYROLLL’， GROUP1_CPU => 50， CONSUMER_GROUP2 => ’SALES’， GROUP2_CPU => 25， CONSUMER_GROUP3 => ’MARKETING’， GROUP3_CPU => 25）； END； SQL>/ What is a prerequisite for using the simple resource plan created by executing the above code？（）
A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan. -
单项选择题
YourecentlyactivatedaresourceplannamedOLTP_PLANinyourdatabase.Severalusersareconcurrentlyrunninglongtransactions.YoudecidetomonitortheresourcemanagertodetermineiftheresourceallocationformulatedintheOLTP_PLANissufficientforpeakdatabasehours.WhichdynamicperformanceviewshouldyouusetodisplaytheCPUtimeconsumedbyallthesessionswithintheresourcegroups？（）
A. V$SYSSTAT
B. V$SESSSTAT
C. V$RSRC_PLAN
D. V$RSRC_CONSUMER_GROUP
