You work as a database administrator to manage an online transaction processing (OLTP)
system.The application code was recently tuned for optimum performance and users
acknowledged the performance improvement. However, the users are now again complaining that
the application response time has gone down considerably.
You used a few queries to investigate the problem and a couple of important queries are shown in
the Exhibit. View the Exhibit and analyze the output shown.
Which actions would improve the performance? (Choose all that apply.)

• A. decreasing the size of the database buffer cache
• B. increasing the size of the database buffer cache
• C. decreasing the value set to the FAST_START_MTTR_TARGET parameter
• D. increasing the number database writers
• E. decreasing the number of database writers

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP)
system.The applications running on the database use connection pooling to connect to the
database to perform transactions.
The company wants to upgrade the CPU and the memory for the machine on which the production
database is running. To test the realistic workload on the new machine with increased CPU and
memory, you identified the peak workload time for the database and captured the workload on the
production system. You set up the test machine with the upgraded CPU and memory, and
performed the following operations for replay:
1) You preprocessed the captured workload.
2) You restored the replay database to match the capture database at the start of the workload
capture.
3) You resolved all external references.
4) You set up replay clients.
You have the following replay considerations:
1) load testing to be performed
2) all the sessions to connect immediately
3) user waits between issuing calls to be kept to a minimum
What replay options would you choose to accomplish the replay?

• A. SYNCHRONIZATION = FALSE, THINK_TIME_SCALE = 0, CONNECT_TIME_SCALE = 0 and THINK_TIME_AUTO_CORRECT = FALSE
• B. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 0 and THINK_TIME_AUTO_CORRECT = FALSE
• C. SYNCHRONIZATION = FALSE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 100 and THINK_TIME_AUTO_CORRECT = TRUE
• D. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 100 and THINK_TIME_AUTO_CORRECT = FALSE

You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database.Which two options describe what these wait events indicate? (Choose two.)

• A. Latch:cache buffer LRU chains - indicates excessive block replacement
• B. Latch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is presently being read into the buffer cache by another session
• C. Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
• D. Latch:cache buffer LRU chains - indicates insufficient size of application cursor cache

You are working on an online transaction processing (OLTP) system. You are investigating the
reasons for performance degradation in the database.
View the Exhibit named TOP5EVENTS and note the top five events.

View the Exhibit named TOPSQL and note the problems related to these statements.

Which two are appropriate solutions to improve performance? (Choose two.)

• A. Keep the long tables in the keep buffer pool.
• B. Enable the large pool.
• C. Set the CACHE property on the table for the short tables.
• D. Set the CACHE property on the table for the long tables.
• E. Keep the short tables in the keep buffer pool.

You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query: SQL> show parameter shared_pool_reserved_size NAME TYPE VALUE
shared_pool_reserved_size big integer 6920601 SQL> SELECT free_space, used_space, request_misses, request_failures from V$SHARED_POOL_RESERVED; FREE_SPACE USED_SPACE REQUEST_MISSES REQUEST_FAILURES
6469776 555528 0 113
You observed that REQUEST_FAILURES is 113 but not increasing, and also that
REQUEST_MISSES is not increasing.
What would you interpret from this?

• A. The reserved pool is large and has free space to satisfy requests. Consider reducing the size of the reserved pool.
• B. The reserved pool is very large. Consider reducing the size of the shared pool.
• C. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the shared pool.
• D. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the reserved pool.