SAN FRANCISCO, CA--(Marketwire - Mar 21, 2013) - Embarcadero Technologies announced today it is hosting an on-line event titled "Back to the Future: Oracle SQL Performance Firefighting Using AWR" featuring DBA specialist Karen Morton. Two separate sessions will be held on March 26, 2013.
Most of us have been in the situation where, for no apparent reason, performance for key SQL takes a nose-dive after having previously performed well. So, how do you handle this situation and stabilize performance back to acceptable levels? One approach is to go back in time using execution data stored in AWR (Automatic Workload Repository). In many cases, AWR may contain what you need to revert your problem SQL to a better performing alternative.
Webinar attendees will learn:
- How to mine and analyze AWR data to review the SQL's performance over time
- How to validate that the SQL is using the "good" execution plan
- Tools to accelerate your analysis of AWR data and SQL code
Tuesday, March 26, 2013
7:00 a.m. PDT/ 10:00 a.m. EDT
11:00 a.m. PDT /2:00 p.m. EDT
To register for a webinar session, visit: http://embt.co/KarenMortonAWRevent
About the Presenter
Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a senior DBA performance and tuning specialist. For over 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90s, she began teaching others how to use Oracle over a decade ago. Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network.
About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance, and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. www.embarcadero.com