Help - Search - Members - Calendar
Full Version: How to get more detail information with procedure in AWR report?
Oracle DBA Forums > Oracle > Oracle Forum
VanessaHung
Dear all..
We have an RAC env with 10gR2 on AIX server.
Everytime when cpu loading high, we always can found some procedure with high buffergets shown in AWR report. But it can't get more detail information in AWR sql report.

Our programmers say it hard to debug, because it hard to verify which SQL in this procedure really get problem. Any sugguestion to help them ?? Is there any utility or tool can drill down the more detail( beffergets / cpu usage .... ) of procedure/function??
SteveC
That's right - the AWR report is a high-level report. That's wrong - it is relatively easy to debug, you just have to apply a bit more effort and use other tools.

You know when the snapshot is taken or what timeframe it covers, right? You can figure out who/which program/module is running, have a decent idea of what code is being used, and then you start tracing. Top-level tool --> drill down using a more fine-grained tool. Elementary exercise.

http://www.dba-oracle.com/t_tracing_oracle_sessions.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.