Chapter 5 and Chapter 6 contain the information you will need to put extended SQL trace data to use, as soon as you're ready for it. Chapter 8 provides some guidance for you in the domain of Oracle's V$ data sources. I do not discuss in this text how to obtain performance information directly from an Oracle SGA. Very few of the people who have figured out how to map the Oracle SGA are willing to talk about it publicly . Kyle Hailey is one professional who has figured it out and who has been willing to describe the process [Hailey (2002)]. As a technician, I find the subject of direct Oracle SGA memory access to be irresistible. However, as a practitioner and a student of optimization economics, I have found Oracle extended SQL trace data absolutely unbeatable.
Top |