Your database supports many applications running on the middle tier. Many applications users
create jobs for which you want to statistically measure workload as a part of performance
management.What would you do to accomplish the task?
A.
Assign resource consumer group to jobs while creating the jobs.
B.
Create services for the applications and create jobs by using the DBMS_JOBS PL/SQL
package.
C.
Query v$SESSION to gather statistics of the individual sessions for the workload created by the
jobs.
D.
Create services for the applications, create job class associated with the service, and then
create jobs by using the job classes.
A is wrong.
Resource Consumer Groups are not assigned to anything.
Things that are assigned to Resource Consumer Groups.
C is wrong, V$SESSION does not provide any statistics.
D can be implemented as follows:
(RAC Example)
1st – Create a service
$ srvctl add service -d ORCL -s OLTP_SERVICE -r ORCL1,ORCL2
$ srvctl start service -d ORCL -s OLTP_SERVICE
$ srvctl status service -d ORCL
$ srvctl config service -d ORCL
2nd – Create Job Class
BEGIN
DBMS_SCHEDULER.create_job_class(job_class_name => ‘OLTP_JOB_CLASS’,
service => ‘OLTP_SERVICE’);
END;
/
3rd – Create Job and assign it
BEGIN
sys.dbms_scheduler.create_job(
job_name => ‘”OLTP_JOB”‘,
program_name => ‘my_oltp_procedure’,
start_date => systimestamp’,
job_class => ‘OLTP_JOB_CLASS’,
comments => ‘This job will run on ORCL1 and ORCL2 instances’,
auto_drop => FALSE,
enabled => TRUE);
END;
create service and link to job class
D is right