count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute callAs you can see, consistent reads are reported as "query."
As for how to decrease that value, I'm tempted to say "by reducing the number of database block visits your query...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
requires." There is no one way to reduce logical I/O. Experiment with different approaches, represented by different SQL, to a problem; the best-performing solution is usually the one that requires the fewest database block visits.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.