Which two are true concerning Columnar Flash Caching?
You are evaluating the performance of a SQL statement that accesses a very large table.You run this query:Identify two reasons why the "cell physical IO interconnect bytes" statistic is greater than the "cell physical IO interconnect bytes returned by smart scan" statistic.
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 ExadataDatabase Machine.You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.You issue this command on the first cell:You examine the output from the first cell which contains:Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?
Which three are true about Exadata Smart Flash Log?
Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 DatabaseMachine?
Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.You decide to use the I/O resource manager.Which is the best way to solve this problem?
