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

  • Performance monitoring and anomalies
  • Memory fragmentation via inode cache growth
  • Memory fragmentation via buffered file I/O
  • Installing R shiny server on OCI compute instance (always free tier)
  • Joins and scalability

Archives

  • 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

  • Performance monitoring and anomalies
  • Memory fragmentation via inode cache growth
  • Memory fragmentation via buffered file I/O
  • Installing R shiny server on OCI compute instance (always free tier)
  • Joins and scalability

Archives

  • 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

  • Performance monitoring and anomalies
  • Memory fragmentation via inode cache growth
  • Memory fragmentation via buffered file I/O
  • Installing R shiny server on OCI compute instance (always free tier)
  • Joins and scalability

Blog Stats

  • 408,060 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

  • 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
  • Swapping (paging) for DBAs
  • High log file sync waits? Check log parallelism!
  • Library cache locks: a case study
  • Troubleshooting network throughput issues in Oracle Data Guard
  • ASH for OS processes
  • Querying trace files
  • Log buffer space
  • AWR analysis: another case study

Top Posts & Pages

  • Memory fragmentation: the silent performance killer
  • AWR reports: interpreting CPU usage
  • Swapping (paging) for DBAs
  • High log file sync waits? Check log parallelism!
  • Library cache locks: a case study
  • Troubleshooting network throughput issues in Oracle Data Guard
  • ASH for OS processes
  • Querying trace files
  • Log buffer space
  • AWR analysis: another case study
Blog at WordPress.com.