Slow Oracle query and USER_IO_WAIT_TIME
We have a slow query that has a low optimizer_cost value but a very high user_io_wait_time value. Does this just indicate that there is an I/O bottleneck? Should we allocate more memory to Oracle? Get faster disks? Note: the stats were gathered by querying V$SQL ...