Unformatted text preview: ication
D. If the %system to %user ratio is greater than 40/60, then you must measure the data
flow between disk devices.
E. If the %user to %system ratio is greater than 60/40, then you must run vmstat for
F. If the %system to %user ratio is greater than 40/60, then you must check the division
of work within the system.
Answer: A,C Actualtests.com - The Power of Knowing 1Z0-036
You plan to start with an Oracle9i stand-alone database system and then upgrade to a
Real Application Cluster (RAC) environment in the near future. You need to ensure that
the process of migrating an Oracle instance and database to enable RAC goes well.
Which file system would you recommend for the datafiles in the stand-alone database
D. Oracle Cluster File System (OCFS)
E. General Parallel File System (GPFS)
F. Network File System (NFS)
Examine the following SELECT command: SELECT sum(pga_alloc_mem) FROM
V$PROCESS; Which statement about this command is correct?
A. This command displays the PGA size of each process that is started up by the
B. If this command displays low values, then increase the
C. This command displays the size of each SQL workarea that is allocated to an instance.
D. This command displays the Program Global Area (PGA) size allocated to an instance.
Which three methods can you use to correlate Statspack and operating system (OS)
measurements? (Choose three.)
A. Use Oracle Enterprise Manager (OEM) Outline Management to manage plan stability
B. Use the at command to schedule the OS statistics through OEM.
C. Use the cron utility to schedule a job to collect database and OS statistics.
D. Use OEM Performance Manager to view and record OS statistics.
E. Print Statspack reports from sar .
F. Run Statspack and the sar task continuously.
Answer: C,D,F Actualtests.com - The Power of Knowing 1Z0-036
Which two statements are true about Oracle Clustered File System (...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09