jump to navigation

Next Round Of ANZ “Let’s Talk Database” Events (July/August 2016) June 20, 2016

Posted by Richard Foote in Let's Talk Database, Oracle Indexes.
trackback

I’ll be presenting the next round of “Let’s Talk Database” events around Australia and NZ this winter in July/August 2016. These are free events but due to limited places have often “sold out” in the past, so booking early is recommended to avoid disappointment.

All events run between 9:00am – 12:30pm and are followed by a networking lunch.

We always have a fun time at these events and feedback suggest everyone learns something, so I hope if you’re lucky enough to be in the ANZ region, you can make it to your local event🙂

Currently, the confirmed events and topics are as follows:

  • Sydney – Wednesday, 20 July 2016: Let’s Talk Oracle Database: Intro To CBO Costings, Database Futures. To register, email: mitch.foster@oracle.com
  • Melbourne – Thursday, 21 July 2016: Let’s Talk Oracle Database: Performance Diagnostics – How To Correctly Use AWR Reports. To register, email: johanne.sergeant@oracle.com SOLD OUT !!
  • Canberra – Thursday, 28 July 2016: Let’s Talk Database: Oracle Database 12c – Built for Data Warehousing. To register, email: richard.foote@oracle.com
  • Wellington –  Wednesday, 10 August 2016: Let’s Talk Oracle Database: Performance Diagnostics – How To Correctly Use AWR Reports. To register, email: tanya.fea@oracle.com
  • Auckland – Thursday, 11 August 2016: Let’s Talk Oracle Database: Performance Diagnostics – How To Correctly Use AWR Reports. To register, email: tanya.fea@oracle.com
  • Perth – Wednesday, 17 August 2016: Let’s Talk Database: Intro To CBO Costings, Database Futures. To register, email: dennis.ward@oracle.com
  • Adelaide – Thursday, 18 August 2016: Let’s Talk Database: Oracle Database 12c – Built for Data Warehousing. To register, email: brodie.james@oracle.com
  • Brisbane: Wednesday, 24 August 2016: Let’s Talk Oracle Database: Intro To CBO Costings, Database Futures. To register, email: gordon.laing@oracle.com

 

Details of sessions.

Performance Diagnostics – How To Correctly Use AWR Reports

I often get called in by customers to determine and address the root cause of database performance issues. Depending on the issue, a request for a simple Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem(s). However, many DBAs find AWR reports daunting as they contain so much database diagnostic information, they don’t even know where to begin to find the truly useful information.

In this session, I begin by discussing the basic concepts of response times, DB times, the Oracle Wait Interface and how to focus on what is truly important. I then look at how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures one can quickly determine whether an AWR report will indeed be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues. We’ll go through a number of actual “real-life” examples that highlight various performance issues and how one accurately determines the actual root issues through an appropriate AWR report.

Time permitting, we’ll go through some other useful diagnostic tools such as the AWR Warehouse, Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH)  and SQL Extended Tracing and scenarios when they can prove to be invaluable in addressing database performance issues.

 

Introduction Into The CBO (Why Is The CBO doing a Full Table Scan?)

A common issue is confusion on why the Oracle Cost Based Optimizer (CBO) has made the decision the use a full table scan or use that index and not the one that appears more appropriate. The costing figures that the CBO derives and displays in execution plans are often viewed as cryptic, which is unfortunate as these costings are key to CBO decisions. Often the attempt to resolve such issues is to set inappropriate database parameters that introduces as many issues as it tries to resolve. This session looks under the covers of the CBO to see how it precisely derives its various costings and hence how to correctly troubleshoot and resolve inefficient queries when they arise. Bring a calculator, it might come in handy🙂

Database Futures – Exadata Secret Sauce and Software on Silicon

Oracle has recently released the new generation of the Exadata machine, the X6-2. Not only is it bigger and faster but also has a host of features and capabilities that is unique to the Exadata storage platform including Smart Scans, Storage Indexes, Exafusion, Smart Fusion Block Transfer, Dual Format Columnar Flash Cache, I/O Latency Capping, Hybrid Columnar Compression, Sparse Snapshots and In-Memory Database Fault Tolerance. All these unique features and their enhancements with the new X6-2 will be discussed. Additionally, Oracle’s Software-in-Silicon features extend the concepts of co-engineering hardware and software inherent in engineered systems such as the Exadata. Embedding software which has traditionally sat in the database layer into the hardware layer can yield both performance and security beyond that available of a traditional CPU. This presentation also covers how Oracle Database 12c can leverage Software-in-Silicon features, where the Oracle Database is heading in the future and why you should care.

 

Oracle Database 12c – Built for Data Warehousing

The Oracle Database is the leading database in market but it might come as a surprise to some that it’is also the leading database with respect to Data Warehousing in terms of both sales and analyst rankings. The focus today is a detailed look at all the special database capabilities that makes the Oracle Database the perfect platform for Data Warehouse type applications.

We explore the overall Data Warehousing Information Management architecture and how it relates to both data warehouses and data reservoirs. We then deep dive into standard database features such as Materialized Views, Dimensions, Bitmap Indexes, Query Re-Write, JSON in the database, Partitioning, Parallel Processing, Compression, Attribute Clustering and SQL for analysis, reporting, aggregation and pattern matching.

We then discuss more advanced Oracle database capabilities such as Data Mining, Predictive Analytics, R in the database, Database In-Memory, Big Data SQL, Spatial & Graph and the specific engineered systems capabilities that makes Oracle such an effective Data Warehouse platform, especially when combined with the enterprise capabilities already associated with the Oracle Database such as security, high availability, scalability and manageability.

Comments»

1. Noons - June 20, 2016

Unless Oracle NSW changes the idiotic visitor parking policy they have, you can count me out!
(not that it would matter one bit, would it? 🙂 )

Richard Foote - June 20, 2016

Come on Noons, we both know it just wouldn’t be the same without you there. As I only catch a taxi to get to/from the office I have no idea what parking policy they have at North Ryde.

What’s the issue, is this something I can take up with folks there ?

Noons - June 21, 2016

Very simple: the car park only opens to visitors at 9am.
Kind of useless for something that starts at 9am, when that is the peak traffic hour in the area.
Until 9am, if you press the button you get a recorded message asking you to call reception on an undisclosed number. Likely very informative for those working there.
But for visitors it’s as helpful as sand in the middle of the desert…
I’ve complained many times before but apparently the simple exercise of checking it out is too much for Oracle’s NSW facilities management. Likely they only start at 9am, so they never see the problem.
Listening to a visitor complaint and fixing the problem?
Narh, their heads might explode, no way!…🙂

2. Richard Foote - June 22, 2016

Hi Noons

OK I’ve just been informed the boom gate into the level 3 carpark is available from 8am onwards.

You need to enter from Richardson Place and turn into the Oracle driveway and take a sharp right towards the open air carpark. Press the green button and security/reception will open the boom gate. Unfortunately you’ll then need to walk back up to the reception entrance to get in the building but the car is parked without time limit on Oracle’s premises. When you leave, the boom gate will open automatically.

You’ve got no excuse now🙂

3. Noons - June 22, 2016

“You’ve got no excuse now”
OMG, what have I done!
(I really hope I won’t get an imperial march fanfare on the speaker when I press the button!…) 🙂
Anyways, I sent an email a coupla days ago to Mitch Foster asking him to book me into the 21st. No reply yet, but no problem: I’m quite sure he’ll get into it once we get nearer to the date.
Looking forward to this one – might bring a few examples of “nasties” to talk about. I reckon there is no such thing as too much AWR! 😉

4. Mrugesh Bhagat - July 7, 2016

Looking forward to attend your presentation scheduled in Melbourne, have emailed Johanne about it. I enjoy reading your posts and have heard good feedback of your AWR session from my Sydney friends- David and Bowie🙂

Richard Foote - August 2, 2016

Hi Mrugesh

Hope you enjoyed it and got value from the session🙂

5. Peter - August 11, 2016

Hi Richard,

Thanks for running the session in Wellington yesterday. It was really useful and informative. Obviously I ran back to my desk after lunch and started running AWR reports on everything in sight, and have found something very odd that perhaps you have seen before.

For a specific database that has one busy period over the weekend when loading data; When the database is quiet, the sum of the % DB Time in the Top 5 Foreground Events generally adds up to close to 100%. When it is really busy, the sum of the % DB Time can add up to as little as 12%.

This is on an AIX LPAR. I think it’s related to the virtual nature of the CPU being presented throwing off the AWR numbers when AIX chooses to go over entitlement for the LPAR. Basically, for the busy period I did DB Time over Elapsed Time and got a number higher than NUM_LCPUS x NUM_VCPUS.

Have you ever seen anything like this?

I have found some articles on this on the web, but wondered if you would be interested in it as a cautionary tale when using AWR.

Thanks
Peter

Richard Foote - September 1, 2016

Hi Peter

Yes, I remember a customer here in Canberra having issues trying to reconcile the amount of CPU actually being used vs. being accounted on AIX.

Here’s an interesting article: http://oracleprof.blogspot.com.au/2013/02/oracle-on-aix-wheres-my-cpu-time.html

Having said all that, there are other reasons for non-accounted time in AWR reports (such a rounding errors with massive numbers of very small wait times, again an issue I’ve a number of times).

For the session, I tried not to confuse matters too much with these more edge cases🙂 Glad you enjoyed it.

6. Muditha - August 23, 2016

Hi Richard,

Thank you so much for the session in Auckland. It was very informative and for me, it was well-timed as I was going through lots of performance issues after 12c upgrade.

Looking forward to your session on CBO. Thanking you again..

Richard Foote - September 1, 2016

Thanks Muditha. Hope to get back to NZ as soon as I’m able🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: