F if the system to user ratio is greater than 4060

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ication code. 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 switching activity. 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 QUESTION 136: 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 system? A. ext3 B. ReiserFS C. ext2 D. Oracle Cluster File System (OCFS) E. General Parallel File System (GPFS) F. Network File System (NFS) Answer: D QUESTION 137: 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 instance. B. If this command displays low values, then increase the PGA_AGGREGATE_TARGET value. 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. Answer: D QUESTION 138: 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 outlines. 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 QUESTION 139: Which two statements are true about Oracle Clustered File System (...
View Full Document

Ask a homework question - tutors are online