Archive for December 16, 2009

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 »