Skip to content

Oracle Diagnostician

Performance troubleshooting as exact science

Month: February 2012

Reading AWR reports

Since this is a very popular subject on the OTN forum, I decided to put together a few points about analyzing AWR reports. Continue reading “Reading AWR reports” →

savvinov AWR Leave a comment February 22, 2012August 13, 2012 3 Minutes

Recent Posts

  • Use of packet capture and other advanced tools in network issues troubleshooting
  • Increase in physical writes due to a plan flip
  • Log file sync and and LGWR redo wait for copy wait events
  • Full table scan burning CPU
  • Performance issues around GTT in 19c

Archives

  • September 2022
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • November 2020
  • October 2020
  • July 2020
  • June 2020
  • October 2019
  • July 2019
  • April 2019
  • February 2019
  • December 2018
  • July 2017
  • March 2017
  • January 2017
  • December 2016
  • June 2016
  • May 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • December 2013
  • November 2013
  • October 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012

Categories

  • ASH
  • AWR
  • bugs
  • case study
  • DML
  • internals
  • log writer
  • neat tricks
  • Oracle
  • SQL plans
  • tools
  • Uncategorized

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Recent Posts

  • Use of packet capture and other advanced tools in network issues troubleshooting
  • Increase in physical writes due to a plan flip
  • Log file sync and and LGWR redo wait for copy wait events
  • Full table scan burning CPU
  • Performance issues around GTT in 19c

Archives

  • September 2022
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • November 2020
  • October 2020
  • July 2020
  • June 2020
  • October 2019
  • July 2019
  • April 2019
  • February 2019
  • December 2018
  • July 2017
  • March 2017
  • January 2017
  • December 2016
  • June 2016
  • May 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • December 2013
  • November 2013
  • October 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012

Categories

  • ASH
  • AWR
  • bugs
  • case study
  • DML
  • internals
  • log writer
  • neat tricks
  • Oracle
  • SQL plans
  • tools
  • Uncategorized

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Recent Posts

  • Use of packet capture and other advanced tools in network issues troubleshooting
  • Increase in physical writes due to a plan flip
  • Log file sync and and LGWR redo wait for copy wait events
  • Full table scan burning CPU
  • Performance issues around GTT in 19c

Blog Stats

  • 458,547 hits

Blogroll

  • Alexander Anokhin
  • Charles Hooper's Oracle Notes
  • Doug's Oracle blog
  • Gokhan Atil's Oracle blog
  • http://flashdba.com Excellent blog about storage
  • Jonathan Lewis
  • Kevin Closson SLOB, storage, I/O, Oracle
  • OraStory (Dom Brook's blog)
  • Tanel Poder
  • Timur Akhmadeev's blog

Archives

  • September 2022
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • November 2020
  • October 2020
  • July 2020
  • June 2020
  • October 2019
  • July 2019
  • April 2019
  • February 2019
  • December 2018
  • July 2017
  • March 2017
  • January 2017
  • December 2016
  • June 2016
  • May 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • December 2013
  • November 2013
  • October 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012

Categories

  • ASH
  • AWR
  • bugs
  • case study
  • DML
  • internals
  • log writer
  • neat tricks
  • Oracle
  • SQL plans
  • tools
  • Uncategorized
web 
stats

Top Posts & Pages

  • Memory fragmentation: the silent performance killer
  • AWR reports: interpreting CPU usage
  • Finding the root cause of "CPU waits" using stack profiling
  • Swapping (paging) for DBAs
  • Troubleshooting network throughput issues in Oracle Data Guard
  • DB time vs duration
  • Full table scan burning CPU
  • CPU starvation disguised as an I/O issue (yet another AWR case study)
  • Installing R shiny server on OCI compute instance (always free tier)
  • Reading AWR reports

Top Posts & Pages

  • Memory fragmentation: the silent performance killer
  • AWR reports: interpreting CPU usage
  • Finding the root cause of "CPU waits" using stack profiling
  • Swapping (paging) for DBAs
  • Troubleshooting network throughput issues in Oracle Data Guard
  • DB time vs duration
  • Full table scan burning CPU
  • CPU starvation disguised as an I/O issue (yet another AWR case study)
  • Installing R shiny server on OCI compute instance (always free tier)
  • Reading AWR reports
Blog at WordPress.com.
  • Follow Following
    • Oracle Diagnostician
    • Join 364 other followers
    • Already have a WordPress.com account? Log in now.
    • Oracle Diagnostician
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar