For information on our 2012 Webinar Series!
From the Centroid Blog
February 23rd, 2012
Written by John Clarke
First things First ... Most savvy Oracle performance folks know about the 10046 extended trace file. If not, just Google "10046 trace" and you'll learn all you need to know from a variety of sources. Oracle's tkprof utility provides a means to read the trace file and provide meaningful output, and recently (10g+) it's had some nicer summary information on a per-cursor and per-session basis at the end of it. What a tkprof report won't give you though is any...
February 21st, 2012
Written by John Clarke
You've taken the plunge and are planning on moving your Oracle EBS environment to Exadata. In this post, I'll talk about some of the things you should think about with Oracle EBS and Exadata Smart Scan What is Smart Scan? Smart Scan is probably the most important software feature on Exadata with respect to being able to provide extreme performance. Smart Scan processing is one of the components of Exadata Cell Offload Processing whose goal is to offload processing to...
February 18th, 2012
Written by John Clarke
Average Active Sessions, or AAS is one of the most important metrics to look at from a database performance perspective. There are many good resources that talk about AAS metrics, including: http://karlarao.tiddlyspot.com/#%5B%5BAAS%20investigation%5D%5Dhttp://karlarao.wordpress.com/2010/07/25/graphing-the-aas-with-perfsheet-a-la-enterprise-manager/www.perfvision.com/papers/02_asl_golden_metric.ppthttps://sites.google.com/site/embtdbo/wait-event-documentation/aas---...
