Who's online

There are currently 0 users and 27 guests online.

Recent comments

Oakies Blog Aggregator

Oracle OpenWorld 2015 : Wednesday

Wednesday started early. I was invited over to breakfast with the Dbvisit crew, which was a great start to the day. I met Arjen years ago and the Dbvisit team have continued to be good people ever since. It’s always good when I get to meet up with them!

After breakfast I headed over to the OTN Lounge and just parked there for a big chunk of the day. Having the lounge in the main concourse of Moscone South is great as there is a constant flow of people to meet, but it does mean that someone like me who likes to chat will get stuck there for hours. :) Every time I meant to leave, someone interesting would come along. As a result I missed all the sessions I was meant to go to. :)

At about 16:00 I walked over to the “Optimizing SQL for Performance and Maintainability” session. The panel was made up of Mohamed Zait, John Clarke, Connor Mcdonald and me, with Gerard Laker keeping the show running. The quality of the other panelists and the fact I was the only non-Oracle person made it a little daunting. Looking out on the audience didn’t help much either, as there was a who’s who of people you really don’t want to embarrass yourself in front of. :) I think collectively, we handled the questions pretty well, but I left the hard ones to the clever people. :) I like to think I represented the average-Joe DBA/Developer. Connor and I hung around for a while after the session to continue answering questions.

From there, it was across to the Bloggers Meetup, which was a great opportunity to hook up with all the people I had not already seen during the week so far. I got to have a good chat with Robyn Sands, who said some nice things about my comments during the panel session, which was a relief. Not surprisingly, I also got to film a few more “.com” clips. :)

As people started to leave for the Appreciation Event, I planned to head back to the hotel to crash, but I was easily persuaded to go for a curry with Jeff Smith, Scott Spendolini, Mike Hichwa, Kris Rice, Colm Divilly and Todd Trichler.

After that, it was back to the hotel to reflect on another rather random, but enjoyable, day…



Oracle OpenWorld 2015 : Wednesday was first posted on October 30, 2015 at 4:59 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

IT Analytics- Global Database Performance

This is one of about 40 blog posts I’ve been eagerly awaiting for permission to post on the Oracle Management Cloud, (OMC)!  There are three main products that will be offered initially through the Oracle Management Cloud

  • Application Performance Monitoring, (APM)
  • Log Analytics
  • IT Analytics

This post will focus on one area of the third offering of IT Analytics–  Database Performance Analytics.

How can advanced IT Analytics investigate database performance at the cloud level vs. on premise?  We’ll take a look deeper into this Oracle Management Cloud feature today and hopefully give you just a taste of this incredible upcoming suite of products from Oracle.

In the IT Analytics Dashboard, we can click on Database and we’ll be brought to the Performance Analytics:  Database page.  The view, unlike what we are accustomed to in Enterprise Manager, introduces us to a global view of performance activity.

Database Dashboard


Now this may seem very foreign to what the database administrator is accustomed to viewing, but just as one acclimates to viewing performance for any given database, the DBA will acclimate to viewing performance at this new global view.  The nuances of performance changes will be noticed soon enough and the DBA will find peace knowing that the global view allows them to inspect their entire database environment vs. just a single one.


The DBA can focus on any day or performance by hovering their cursor on the Database Activity graph and the overall wait hits will be demonstrated.  It’s very clear that on Sept. 10th, a high amount of IO waits were experienced across the database environment.

If you were interested in CPU or other wait type, notice that where you hover makes a difference:



Below the Top Activity, the most impacting SQL is displayed by SQLID and then the change in response time is shown in variations of red to green, red signifying larger percentages of change in performance impact.


This redistributes the tuning exercise from the database level to the global SQL level.  Although the SQL identified with ‘bqvs6ypax0dtn’ and ‘gm6py648gu6x5’ may be very good statements for overall tuning, the SQL identified with ‘4ztz048tq32s’ is most likely to result in user complaint due to recent performance degradation from the most number of users.


Now IT Analytics offers incredible opportunities at this global view, but this may be where the DBA wishes to dig into the issue on-premise.  IT Analytics Database Performance ensured the DBA was able to quickly identify where their time could be allocated with the most value for a performance tuning exercise and now the DBA may wish to proceed to a trusty AWR SQL specific report or SQL ID details information or Search SQL for the SQLID identified Oracle Management Cloud IT Analytics, thanks to Database Performance Analytics.






Copyright © DBA Kevlar [IT Analytics- Global Database Performance], All Right Reserved. 2015.

SQL Monitoring in Oracle Database 12c

Here’s my latest OOW presentation – SQL Monitoring in Oracle Database 12c:

[direct link]

You can download all my scripts from



NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!

Auto optimizer stats after CTAS or direct loads in #Oracle 12c

Less famous 12c New Feature: If you do Create Table As Select (CTAS) or a direct load into an empty table, we will automatically collect optimizer statistics:

SQL> select banner from v$version;

Oracle Database 12c Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production

SQL> create table nu as select * from sales where rownum<=100000; 
Table created.
SQL> select num_rows,blocks from user_tables where table_name='NU';

---------- ----------
    100000        695

SQL> truncate table nu;
Table truncated.

SQL> insert /*+ append */ into nu  select * from sales where rownum<=200000; 
200000 rows created. 

SQL> commit;
Commit complete.

SQL> select num_rows,blocks from user_tables where table_name='NU';

---------- ----------
    200000       1379

If the table is not empty, the statistics are not updated:

SQL> insert /*+ append */ into nu  select * from sales where rownum<=100000; 
100000 rows created. 

SQL> commit;
Commit complete.

SQL> select num_rows,blocks from user_tables where table_name='NU';

---------- ----------
    200000       1379

You see that the previous statistics have not been changed here.
If it is a conventional insert:

SQL> truncate table nu; 
Table truncated. 
SQL> insert into nu select * from sales where rownum<=100000; 
100000 rows created. 
SQL> commit; 
Commit complete. 
SQL> select num_rows,blocks from user_tables where table_name='NU'; 
---------- ---------- 
    200000       1379

Again, the statistics have not been maintained automatically either. Can be done manually still, of course:

SQL> exec dbms_stats.gather_table_stats('ADAM','NU')

PL/SQL procedure successfully completed.

SQL> select num_rows,blocks from user_tables where table_name='NU';

---------- ----------
    100000        748

So knowing that, you may be able to skip some manual statistics collections that you may have done in the past after CTAS or bulk loads :-)

Tagged: 12c New Features

Oracle OpenWorld 2015 : Tuesday

The day started in the normal way, with a quick blog post about the previous day and a visit to the gym.

The original plan for the day was to hit the demo grounds again. I popped into OakTable World for the quick chat with a few folks and ended up staying for quite while. I watched some of the Ted-style talks, specifically Tim Gorman, Jonathan Lewis and Martin Klier. I then got chatting to some folks outside, before heading back in to see Gwen Shapira do a session on Kafka.

Whilst I was there I got to film a few “.com” clips for my videos, with funniest setup being Tanel Poder. He saw me filming some other folks and just launched in, not knowing what was going on and struck a pose. It took a bit of prompting before he realised he had to say something. You’ve got to love the enthusiasm. :)

GrahamWoodI got to admire Connor’s t-shirt and most importantly, I got to meet up with my dad!

From there I headed off to the demo grounds, where I inevitably ended up at the SQL Developer stand, speaking to Kris Rice and who turns up but Connor McDonald. :)

From the demo grounds I went to grab some food with Connor, then I headed back to the hotel to crash out.

It was a good day, which goes to prove my point, you’ve just got to go with the flow when you are at OOW. Plans are good, but don’t worry if they don’t work out.



Oracle OpenWorld 2015 : Tuesday was first posted on October 28, 2015 at 2:29 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Connecting Hadoop and Oracle

Here are the slides of my yesterday’s OakTableWorld presentation. They also include a few hints about what our hot new venture Gluent is doing (although bigger annoucements come later this year).

[direct link]

Also, if you are at Oracle OpenWorld right now, my other presentation about SQL Monitoring in 12c is tomorrow at 3pm in Moscone South 103. See you there!


NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!

The “as a Service” paradigm.

For the last few days I have been at Oracle Open World 2015 (OOW15) learning about the future plans and directions for Oracle. I’ve come to a striking realisation, which I will reveal at the end.

The message being pressed forward very hard is that of compute services being provided “As A Service”. This now takes three flavours:

  1. Being provided by a 3rd party’s hardware via the internet, ie in The Cloud.
  2. Having your own hardware controlled and maintained by you but providing services with the same tools and quick-provisioning ideology as “cloud”. This is being called On Premise (or just “On Prem” if you are aiming to annoy the audience), irrespective of the probably inaccuracy of that label (think hosting & dedicated compute away from head office)
  3. A mix of the two where you have some of your system in-house and some of it floating in the Cloud. This is called Hybrid Cloud.

There are many types of  “as a Service offerings, the main ones probably being

  • SaaS -Software as a Service
  • PaaS – Platform as a Service
  • DBaas – Database as a a Service
  • Iass – Infrastructure as a Service.

Whilst there is no denying that there is a shift of some computer systems being provided by any of these, or one of the other {X}aaS offerings, it seems to me that what we are really moving towards is providing the hardware, software, network and monitoring required for an IT system. It is the whole architecture that has to be considered and provided and we can think of it as Architecture as a Service or AaaS. This quick provisioning of the architecture is a main win with Cloud, be it externally provided or your own internal systems.

We all know that whilst the provision time is important, it is really the management of the infrastructure that is vital to keeping a service running, avoiding outages and allowing for upgrades. We need a Managed Infrastructure (what I term MI) to ensure the service provided is as good as or better than what we currently have. I see this as a much more important aspect of Cloud.

Finally, it seems to me that the aspects that need to be considered are more than initially spring to mind. Technically the solutions are potentially complex, especially with hybrid cloud, but also there are complications of a legal, security, regulatory and contractual aspect. If I have learnt anything over the last 2+ decades in IT it is that complexity of the system is a real threat. We need to keep things simple where possible – the old adage of Keep It Simple, Stupid is extremely relevant.

I think we can sum up the whole situation by combining these three elements of architecture, managed infrastructure and simplicity into one encompassing concept, which is:




And yes, that was a very long blog post for a pretty weak joke. 5 days of technical presentations and non-technical socialising does strange things to your brain

Oracle OpenWorld 2015 : Monday

Monday started with a trip to the gym, where I met Scott Spendolini. At the end on the session, we were sitting on bikes next to each other chatting, whilst peddling at an incredibly slow rate. After getting cleaned up, we headed over to Lori’s Diner and ate more calories than be burned at the gym. :)

From there we headed down to the conference. I spent some time chatting to folks at the OTN Lounge, where I met one of my former colleagues Ian MacDonald. He had just come out of an Oracle Forms 12c session and I had a bunch of questions to ask also, so we headed down to the demo grounds to find the Oracle Forms stand, where then spent ages talking to Michael Ferrante about life, the universe and everything Forms related. :)

As I mentioned the other day, the installation and configuration of Forms and Reports has changed in 12c. During my first run through I noticed the Web Tier that links everything together was present in the domain, but not configured during the process. I was curious if I had done something wrong, if it was expected behaviour or if it was an implied statement of direction. I guess the web tier is surplus to requirements for many people if they are fronting their infrastructure with a reverse proxy or a load balancer. It turned out to be expected behaviour, and we discussed the configuration of the web tier, which is very simple. Just amend a couple of files and copy them to the “moduleconf” directory under the OHS instance. Happy days.

We also got a demo of the installation of the Forms Builder on Windows, which no longer needs a WebLogic installation, making it a much smaller footprint for developer machines. Our developers still use Forms 10g Builder. We then take the finished forms, move them to the server and recompile to 11gR2. It’s a pain, but simpler than putting Forms Builder 11gR2 on their PCs. If we can move to 12c Forms, they should be able to use the latest builder again. :)

From there I moved on to the SQL Developer demo stand, where I got to speak to Kris Rice and Jeff Smith, who are always good value. While I was there Jagjeet Singh, Sanjay Kumar and Baljeet Bhasin came up to say hello to me, which was really nice. Of course, I filmed them doing a group “.com”… :)

After that it I did a tour of the exhibition stands looking for things of interest. I used the GoPro to film a walk around some of the exhibition. I’ll see if I can make a little montage out of that…

Next, I went back to the OTN Lounge and spoke to a whole bunch of people, and filmed a load of “.com” cameos for forthcoming YouTube videos. :)

Then it was the weary walk back to the hotel, where I crashed for the night.

I think tomorrow may well be another demo grounds day…





Oracle OpenWorld 2015 : Monday was first posted on October 27, 2015 at 6:21 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Live Streaming Oaktable World!

UPDATE: recorded videos now available

If you can’t make it in person to Oaktable World, check it out via live streaming !


here is the agendaScreen Shot 2015-10-02 at 11.05.49 AM

Screen Shot 2015-10-07 at 2.15.55 PM

Oracle OpenWorld 2015 : User Group Sunday

My wake up times are getting gradually later and later. That’s a good thing for now, but will make the journey home harder. :)

The day started with a bit of work on those articles I mentioned yesterday, with the inevitable trip to Lori’s Diner for breakfast of course.

I headed off to the gym, which felt super-hard. I’m trying to get some cardio in every day, in addition to the weights. I enjoy lifting weights, but if you are fat it just makes you look bigger, so in clothes you look even fatter. I despise cardio, but it is a necessary evil. I’ve been pretty good on the exercise front since I’ve been away. Not so good on the eating front though… :)

During the day we had the EMEA User Group Community session called “More Than Another 12 on Oracle Database 12c”. I was one of the 16 speakers, which included:

We each got 7 minutes for our particular topic and a buzzer went off when your time was up, so there was no over-running. :) Some were much quicker than others, but that’s all good. We had a 2 hour block and we finished at about 1 hour and 45 minutes, so we I think we did pretty well.

I really like this format. If there is a topic you are not into, you are only 7 minutes away from the next speaker. It also forces you to be extremely specific and direct your talk. You can get a lot done in 7 minutes if you need to. I’ve uploaded a video of my section of the talk.

I hope the audience enjoyed it as much as the speakers. Please send your feedback, so we know if we should do this sort of thing again next year…

After the session, I chatted to a few people, including Gilbert Standen. You may have seen me tweet about some of the Oracle RAC on Ubuntu stuff he does. It’s pretty interesting and far more geeky than the stuff I do. :) He gave me a t-shirt and swag, which I’ll hopefully remember to wear at my session on Wednesday. :)

After chatting to a few folks, I hooked up with Jonathan Lewis and we went off to Ghirardelli to eat ice cream and chat about the stuff that had happened so far this year at San Francisco. I didn’t realise he was an ice cream fiend. :)

After that, we headed back to the OTN lounge for the group photo, but found we were too late, so when you are looking at it, imagine were are there too. :) Then it was back to the hotel to dump our stuff before heading to the Oracle ACE dinner.

This years ACE dinner was really nice, although semi-clad dancing girls, contortionists and silks performers were conspicuous by their absence. :) Jokes aside, what made it nice was it was great for mingling. Everyone was on their feet, moving round the room chatting to each other. As well as all the usual suspects, I got to speak to a bunch of people from the OTN tours I’ve been on. It’s always good to reconnect and talk about the next visit. :) I also got to speak to Liron Amitzi about his recent move to Vancouver, which is a pretty interesting life change! You also get to meet some people in person for the first time. I was really happy to finally meet Mahir M. Quluzade in person. I feel like I already know him, but now we have met. :)

At about 22:00 we got on the bus and headed back to the hotel, where I completely zonked out!

All in all, it was a good day!

This morning is the start of the main OOW15 conference and I’m already knackered. :)



Oracle OpenWorld 2015 : User Group Sunday was first posted on October 26, 2015 at 3:21 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.