1Z0-048 試験問題を無料オンラインアクセス

Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.)

• A.the VJSQL CURSOR view
• B.the V$SQL_PLAN view
• C.the VJSQL view
• D.the VJSQLTEXT view
• E.the VJSQLAREA view

View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. You entered the host name but you are not sure about the port number. Thefollowing is the list of port numbers from the host ed-otraclin17b.us.oracle.com:

• A.3938
• B.5561
• C.1521
• D.4889
• E.1158

In which directory should you put your callout scripts on your RAC nodes?

• A.JORACLE_HOME/racg/usrco/
• B.$ORA_CRS_HOME/opmn/conf/
• C.$ORACLE_HOME/opmn/conf/
• D.$ORA_CRS_HOME/racg/usrco/

You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.)

• A.Use symbolic links to simplify recovery of the voting disk.
• B.You can determine the voting disks currently used by CSS with the command crsctl query ess votedisk.
• C.To back up the voting disk, use the command ocrconfig -export.
• D.If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware.
• E.Backup can be performed online.

You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX- index contention on page one under the category op 5 Timed Events.
Further study finds an unusually high number of c buffer busy waits in the Wait Events section.
Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits.
Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index products_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention.
Which three actions would you recommend to reduce the overheads? (Choose three.)

• A.Encourage shorter transactions.
• B.Set _lm_msg_batch_size to a higher value.
• C.Set fast_start_mttr_target to a higher value.
• D.Re-create the index as a global hash partitioned index.
• E.Re-create the table using a natural key instead of a surrogate key.
• F.Increase the sequence cache size if retaining the sequence.