Access Path Scientific Analysis Part V – Identifying Top Resource Consumers Using SQL Statements
Now that we are ready to continue our discussion on access path scientific analysis, we need to begin identifying some representative queries that we can monitor and tune. There are numerous ways to identify the top resource consumers for a given instance. We’ll learn that both the10G and 11G DB Consoles are both able to [...]
Read the rest of this entry »
