Statistics obtained from the sar and vmstat commands

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: used by the spcreate.sql script to register the snapshot job. Answer: B,C,D QUESTION 131: Which statistics enable you to view the impact of SQL statements on input/output (I/O) statistics? A. file statistics in Performance Manager B. statistics obtained from the sar and vmstat commands C. sorts and parse calls values in Top SQL D. buffer gets and disk reads values in Top SQL E. CPU chart group in Performance Manager Answer: D QUESTION 132: Which Oracle Net utility or tool is integrated with Oracle Enterprise Manager? A. Oracle Net Configuration Assistant B. Oracle Names Control utility C. Oracle Connection Manager Control utility D. Oracle Net Manager E. Listener Control utility Answer: D QUESTION 133: You have specified the configuration in the sysctl.conf file. However, when you restart Actualtests.com - The Power of Knowing 1Z0-036 the system, Linux does not start. Which statement describes the steps that you would take to troubleshoot the problem? A. Use the root login to access the system in runlevel 6 and edit the /root/.bashrc file. B. Use the root login to mount the file system and edit the sysctl.conf file. C. Use the boot loader to enter the emergency mode and switch to runlevel 3. D. Use the boot loader program to access the available kernels and recompile the kernel. E. Use the single-user mode to access the /proc file system and edit the kernel parameters. F. Use the boot loader program to boot into runlevel 1 and edit the sysctl.conf file. Answer: F QUESTION 134: Which operating system (OS) group normally manages the Oracle database files? A. apache B. oper C. users D. oinstall E. root F. dba Answer: F QUESTION 135: Which two statements are true about %user to %system ratio for Oracle server processes? (Choose two.) A. If the %user to %system ratio is less than 60/40, then you must look for input/output (I/O) or virtual memory problems. B. If the %user to %system ratio is less than 60/40, then you must check sar -wW for swapping activity. C. If the %user to %system ratio is greater than 60/40, then you must tune the appl...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online