Oracle OpenWorld 2014 : Wednesday

Another early start on Wednesday. I headed down to meet the Dbvisit gang for breakfast. FYI: I’m not paid to keep mentioning them and I don’t work for them. They are just a great group of people who I really like, so when I get a chance to meet up with them I do. :)

From there it was on to Moscone where I bumped into Eric Yen. We’ve known each other for years on the interwebs, so it was nice to spend some face-to-face time. I also bumped into Daniel De Meda again. We chatted for a while the previous day, so when we met today we did a selfie. From there it was off to the demo grounds again, then I met up with Sve Gyurov for lunch.

IMG_20141001_123115

If you’ve ever met Sve, you will realise that I am on tiptoes and he is crouching when we took this shot, otherwise this would be a picture of my head and his chest. :)

After lunch I had a major attack of lethargy, so I headed back to the hotel for a rest, which I’ve just surfaced from at 20:00. :( I’m going to duck out of the evening events as well…

So this really marks the end of OpenWorld for me, because I leave tomorrow morning. It’s been a really strange one for me this year. I enjoyed the ACE Director Briefing and felt like I was coping really well, then I kind-of crashed once OOW actually started. What with being ill for the 3 weeks prior to the event, then having to deal with the jet lag, I really had no reserves to fall back on this year. I feel a bit disappointed with myself as it feels like a wasted opportunity, but you can only do so much…

I’ll write a wrap-up post about the whole event when I get back.

Cheers

Tim…

Oracle OpenWorld 2014 : Tuesday

Tuesday started early with 5 hours in the hotel lobby. The plan was to catch up on my blogging using the free wifi. I hadn’t blogged for a couple of days, which prompted an email from my mom to see if I was OK. :)

It took about 5 hours to complete two blog posts, because every 30 seconds someone new walked by and I was “forced” to speak to them. :)

That done, I headed down to Moscone South to check out the Dbvisit stand. I mentioned a few weeks ago that I had never tried a Twinkie, so Chris Lawless went to work correcting that state of affairs by bringing a box of Twinkies to their stand. You can see me trying my first Twinkie here!

I didn’t record me eating my second Twinkie. :)

From there is was a visit to the demo grounds again, then up to the OTN lounge to chat with a few people about the ACE Program, life the universe and everything. After a quick lunch with Vikki from the ACE Program, I hooked up with Steven Feuerstein to chat about his YesSQL initiative. Soon after that it was across to the ODTUG gathering briefly, before heading off to the SQL and PL/SQL Performance Panel, which featured Jagan Athreya, Dad (Graham Wood), Tom Kyte and Steven Feuerstein.

After popping back to the hotel to dump my bag, it was back down to Howard Street to the attend the evening festivities. I spent most of the evening with Doug Burns and one of his colleagues called Seamus. I even had a drink. Who’da think it?

Tiredness is still a big problem for me. The day is starting so early that I feel like the living dead most of the day.

Cheers

Tim…

Oracle OpenWorld 2014 : ACE Director Briefing – Day 2

Day 2 of the ACE Director Briefing followed a similar format to day 1. Lots of things we are not allowed to talk about and a few things we can.

Of the things we can talk about:

  • The release schedule for 12cR2 (12.2) was mentioned. It was published a few weeks ago. It’s tentatively listed as 1HCY2016. You can read it for yourself in MOS Note 742060.1.
  • Dan Mcclary‘s session on Oracle Big Data SQL seemed to win over even the most cynical in the room. It was a really interesting session on something I know virtually nothing about. :) Having external tables pointing to Hive and NoSQL sources, allowing SQL queries and joins across multiple data stores is pretty cool.
  • The JSON support in 12.1.0.2 looks pretty cool.  Some more goodies related to APIs for this functionality are on their way in Oracle REST Data Services (APEX Listener).
  • David Peake previewed Live SQL. It’s still under construction at the moment, but it looks like it’s going to be a useful resource for people learning SQL or sharing examples with each other. Kind-of like SQL Fiddle on steroids, with an emphasis on learning through tutorials and example code etc. The aim being to reduce the barrier to entry.
  • Wim Coekaerts gave an overview of what’s going on in the Linux and virtualization world. I’m a total fanboy, so I loved it. :)
  • Steven Feuerstein spoke about his new initiative to revitalise the SQL and PL/SQL communities in Oracle. It’s still in the early stages, but it will be interesting to see how this develops. Obviously I have a vested interest in anything that makes the database look cool! :)

Of the things we can’t talk about:

  • We can’t take about them. :)

Overall I thought this was a really great briefing. There was a lot of stuff on the agenda that didn’t relate to my core skill set, but I still got drawn in. It’s good to be aware of what’s happening around you, even if you will never get chance to get on top of it. Big thanks to the Oracle ACE Program and OTN for getting this organised for us!

After a bit of socialising, it was on to the coach to drive from Redwood Shores to San Francisco. We are now all in the Hilton and waiting for OOW to start tomorrow.

This morning I did my first proper gym visit of the trip. I hit the weights and did some stretching. I’ve just got to avoid food for the next 6 months and I’ll be buff! :)

Cheers

Tim…

Oracle OpenWorld 2013 : Thursday

I got up late, so I missed the morning gym session.

When I got to Moscone at about 08:30, I headed straight for the speakers room to play catch-up on emails, questions, blog posts and work emails. I expected that to take a few minutes, but it actually took me up to midday. It’s crazy how much time we spend on this community stuff. :)

I spent most of the afternoon in the OTN Lounge geeking out with a variety of people. I was initially expecting to spend the whole day in presentations, but it turned out I didn’t manage to get to a single one. I spent some time chatting with the ladies and gents from the RAC SIG about ideas for future directions for user groups and collaborative efforts like RAC Attack. It’s interesting to hear the different opinions and motivations of the people involved.

I had an interesting chat with Lenz Grimmer about a number of Linux related things. He was kind enough to help me out a few months ago with some clarifications on my Oracle Linux : Frequently Asked Questions post and was asking how I was getting on with the Oracle Linux migrations at my current company, which spawned a few ideas for some followup posts about the process we’ve gone through to move a variety of systems from RHEL, Solaris and HP-UX to Oracle Linux on VMware. Watch this space! :)

From the OTN Lounge the next stop was the “It’s a Wrap” party, where I had an emotional reunion with my dad.

IMG_20130926_172805

I’m still waiting for the 44 years worth of birthday and Christmas presents he owes me!

I’m back at the hotel now, feeling totally burnt out. I know it’s not very rock-n-roll, but I think I’m going to bed. :) I’m flying back home tomorrow, so I’ll get back on Saturday UK time. Next week I’m back to work during the day and back to learning 12c during the evenings. Thank goodness for insomnia…

Cheers

Tim…

Oracle OpenWorld 2013 : Wednesday

A familiar morning. Up at silly o’clock, went to the gym, then read in my room for a while…

The plan for Wednesday was pretty much the same as Tuesday. Most of the day was spent at RAC Attack. I thought we were meant to be helping people install RAC on their laptops, but I quickly came to understand this was a cover for watching Yuri take photos of people jumping in the air… :)

A big thank you to all the people involved in making RAC Attack happen again! A lot of people helped in making the new 12c install notes. Lots of people dedicated two days of OOW2013 to this, rather than watching presentations or swanning off to the boat racing. Thanks also to the OTN crowd for giving up so much space to us.

After RAC Attack I popped in to see John Beresniewwicz and Kellyn Pot’Vin presenting, “Active Session History Deep Dive: Advanced Performance Analysis Tips”. I like listening to both these speakers!

From there it was back to the exhibition stands to hook up with the DBVisit guys, before returning to the OTN Lounge for the “Meet the ADF Team” session. David Peake was lurking there, pretending to be part of the ADF team. There’s a rumour there that is just begging to be started! :)

Then it was back to the hotel to dump my stuff before heading off to the Bloggers Meetup. I was only there for about 2 minutes, before I had to leave for the appreciation event, so sorry if I missed anyone. Having spent so much time in the OTN Lounge this year, I doubt there is anyone I’ve not met already. :)

This year I got to do the appreciation event in style as a VIP, thanks to an invite by the DBVisit guys. We were in the New Zealand suite at the top of the stadium, so I was an honorary Kiwi for the night. :) I had a few drinks and ate vast quantities of food, without having to fight it out with the crowds. It was great! I’m always bigging up the DBVisit folks, but they really are a great group of people. Chris Lawless (formerly of the Oracle GoldenGate team) is a great addition to the team. He cracked me up all night. To show my support, I put some “temporary” Dbman tattoos on my arms. Turns out they are not so temporary after all. Two showers and some scrubbing and they are still with me. :) You can see a picture of them here. I love that picture because it makes me look skinny! :)

During the event, I managed to find Nemo and watch Maroon 5 and The Black Keys. Adam Lavine from Maroon 5 has a really strange voice. When he sings it sounds fine, but when he talks he sounds like he’s been hitting the helium balloons. It’s like Alvin and the Chipmunks. Very odd. I’m not a fan of Maroon 5, so I was surprised that I recognised all but one of the songs they played. They were really good. The Black Keys where a lot heavier than I expected. I knew I had heard some of their stuff, but I wasn’t sure how much I would recognise. I think there were three songs I definitely recognised. Pretty cool.

I got back to the hotel at about 01:00, so this morning was a later start for me. Someone has been shopping again. Lots of boxes outside their room again this morning! :)

Cheers

Tim…

Oracle OpenWorld 2013 : Tuesday

Another “groundhog day” morning. Up at silly o’clock, went to the gym, then read in my room for a while…

Tuesday was the first day of RAC Attack proper. We had 3 tables at the OTN lounge, all of which were full. There were a few teething problems with the new set of instructions, but we muddled through. In some ways, this is more fun than if things go too smoothly. :) RAC Attack took pretty much the whole day. I hoped to go and see my adopted dad (Graham Wood) in the Real World Performance Group session, but that never happened.

I left RAC Attack and headed down to the demo grounds to have a bit of a moan at the Cloud Control guys. To my delight the stand was being manned by Pete Sharman. I’ve “known of” Pete for many years, but our paths have never crossed before today. It was a pleasure to meet him at last, but that didn’t stop me from having a moan about some bits of Cloud Control. :)

As I was leaving the Cloud Control stand I bumped into Jacco Landlust. When he’s not offending Cary Millsap and Tom Kyte, Jacco skates the fine line between being a DBA and WebLogic administrator. Being a WebLogic newbie, I always like hooking up with Jacco to pick his brains and validate that I’ve not screwed things up too badly. After pumping him for information, I now feel like I’ve graduated to post-newbie status. :) Of course the big news is he’s the latest Oracle ACE to become an Oracle employee. It’s starting to feel like a recruitment program. :)

Next I headed up to the OTN Meetup, like I hadn’t spent enough time in the OTN Lounge already. :) I spent some time talking to Connor McDonald, Chris Muir, Lonneke Dikmans, Marcelle Kratochvil, Doug GaultScott Spendolini and Liron Amitzi, to name but a few. I’d like to say I was intelligent and insightful, but I had drunk 3 beers and felt extremely merry, so I’m guessing I was talking complete nonsense, nothing new there. :)

As the OTN meetup drew to a close I walked back to the hotel with Liron Amitzi. He’s in the room opposite to me and I keep ribbing him about permanently having the “Do not disturb” sign on the door. We were discussing some of the installation oddities we’ve seen, as well as the Larry Ellison key note, that Larry didn’t turn up to

I had a quick chat to John Scott and Roel Hartman in the lobby of the hotel as they left for the APEX Meetup.

So that’s another day done. Tomorrow is the second day of RAC Attack.

Cheers

Tim…

Oracle OpenWorld 2013 : Monday

Monday started in a similar way to Sunday. I woke up at silly o’clock, went to the gym, then read in my room for a while.

Monday morning was spent flitting between the demo grounds and the OTN Lounge. I also filmed a short interview for OTN, which will probably appear at some point. It was a one-take thing, so it will annoy the hell out of me when I watch it back 75,000 times. :)

Later in the day I went to the Real World Performance Group session, then it was back to the OTN lounge to for some more networking/chatting. :)

On the way back to the hotel I popped into a bar to meet the AppsLab guys and David Haimes, who filmed my abortive attempt at using Anthony’s Google Glass here. It’s tricky when you have glasses. You either have to balance them outside your glasses, or not wear your glasses, so everything is blurred. It helps if you are not in a noisy bar when you are trying them. :)

I got back to the hotel and found my credit cards had been blocked. I tried and failed to get them unblocked, which led to a few very angry tweets!

Being tired and rather angry, I just went to bed rather than going to the “Friends of Pythian” event.

Cheers

Tim…

 

Oracle OpenWorld 2013 : Sunday

I arrived in San Francisco on midday Saturday. I basically lost a nights sleep, all but 1 hour, so I was not feeling on top of the world. I got some food and went to bed for the rest of the day. I started Sunday at 00:30, so Sunday was going to be a looooonnnnggggg day. :)

After getting breakfast at 03:00, hitting the gym and reading for a while, I ventured down to the conference.

The first session I went to was “Carry Millsap – Thinking Clearly About Performance”. I’ve seen variations on this session a number of times and I’ve been on a one day course with Cary, but it’s still nice to hear this stuff again. Every time you pick up something new. I already have a copy of Mastering Trace Data from when I did his course, but I ordered the revised version from Amazon.

Next up was “Kyle Hailey – Oracle Instant Database Cloning”. The Delphix virtual database stuff looks amazing! I thought I was down with the whole database cloning thing (duplicate, clonedb, clone PDB), but this stuff is another level. Wow!

After Kyle’s session I was part of an IOUG panel session called “What I wish I knew before I became a DBA”. I found it fun. I hope the audience did too. I ended up speaking to some people for about an hour after the session ended.

From there it was off to the OTN Lounge to do the “RAC Attack” introduction. I had to explain a little about the history of RAC Attack. I’m sure you will see a number of embaressing Ninja photos coming out. I am the fat ninja. :)

Then it was off to the Oracle ACE dinner at the Walt Disney Museum. It’s great to hook up with people I’ve not seen in a while. Put me in a room with geeks and I’m in my element!

I got back to my room at about 22:00 and basically passed out… As I expected, it was a long day! :)

Cheers

Tim…

Challenge: Most stupid exhibition freebie you can find at OOW2013

I’ve been challenged by Doug Burns to find the most stupid exhibition freebie as a present for Andy Cowling. I am of course going to cheat as much as possible to win this challenge, so if you see something particularly stupid, can you let me know so I can snag one. Needless to say, keep it a secret from Doug too. :)

If you are an exhibitor and you happen to have a particularly stupid exhibition freebie, feel free to contact me. Once again, make no attempt to contact Doug Burns… :)

Cheers

Tim…

PS. Anything really cool, like a free Exadata, might accidentally get kept for myself…

 

Oracle OpenWorld 2012 : Day 5

Day 5 was a presentations day for me.

I tried to make as many notes as I could, but you will see the quality and accuracy of the notes tail off as the day went along… :)

Tom’s Top 12 Things About the Latest Generation of Database Technology

My bullets don’t quite match Tom’s, which is why I have more than 12 things listed. :)

  • Functions (and procedures used within those functions) can be defined in the WITH clause. Performance boost compared to regular unit defintion. Pragma to allow regular functions to benefit from these performance benefits.
  • Default value of column can use a sequence.nextval.
  • Identity columns : Multiple levels of control of how it is used. Can use simple or more complex syntax.
  • Metadata only default of optional columns. Previous versions this was possible only for mandatory columns.
  • VARCHAR2(32767) in the database. Less than 4K is stored inline. More than 4K is stored out of line, similar to LOB, but simpler. Not available by default.
  • Top-N now using Row limiting clause eg. “OFFSET 10 ROWS FETCH FIRST 10 ROWS ONLY”. Similar to mySQL syntax.
  • Row pattern matching. Quite a lot of new analytic syntax here.
  • Partitioning Improvements:
    – Asynchronous Global Index maintenance for DROP and TRUNCATE. Command returns instantly, but index cleanup happens later.
    – Cascade for TRUNCATE and EXCHANGE partition.
    – Multiple partition operations in a single DDL
    – Online move of a partition(without DBMS_REDEFINTIION).
    – Interval  + Reference Partitioning.
  • Adaptive Execution Plans:
    – If the optimizer notices the cardinality is not what is expected, so the current plan is not optimal, it can alter subsequent plan operations to take allow for the differences between the estimated and actual cardinalities.
    – The stats gathered during this process are persisted as Adaptive Statistics, so future decisions can benefit from this.
    – You will see STATISTICS COLLECTOR steps in the SQL Trace. Can make the trace harder to read as it can contain information about the expected plan and the actual plan.
  • Enhanced Statistics:
    –  Some dynamic sampling operations are persistent, so they are not lost when the SQL is aged out.
    – Hybrid histograms. When the number of distinct values is greater than 254, “almost popular” values can get “lost” in the mix. A single bucket can now store the popularity of than value, effectively increasing the number of buckets, without actually increasing it.
    – Possible the max number of buckets can be increased based on a parameter. (demo grounds)
    – Statistics gathered during loads. CTAS and INSERT … SELECT automatically compute stats.
    – Global temporary tables can have “session private statistics”. Previously, we had one-size-fits-all.
  • Temporary Undo (ALTER SESSION SET temp_undo_enabled=true):
    – UNDO for temporary tables can now be managed in TEMP, rather than the regular UNDO tablespace.
    – Reduces contents of regular UNDO, allowing better flashback operations.
    – Reduces the size of redo associated with recovering the regular UNDO tablespace.
  • Data Optimization:
    – Information Lifecycle Management: Uses heat map. Colder data is compressed and moved to lower tier storage. Controlled by declarative DDL policy.
  • Transaction Guard:
    – If a failure happens, your application may not know the actual status of a transaction. If it was successful, issuing it again could cause a duplication transaction.
    – In these cases, you can mark a transaction with an “unknown” state (as far as the application is concerned) as failed, so even though they may have been successful, it will never be considered, or recovered. You’ve guaranteed the outcome.
  • Pluggable database:
    – Oracle provided metadata and data is kept in the container database (CDB).
    – User metadata and data is kept in the plugable database (PDB) .
    – One container can have multiple plugable databases.
    – No namespace clashes. Allows public synonyms and database links at the PDB level, rather than the CBD level.
    – Cloning is quick and simple as only user metadata and data needs to be cloned.
    – Upgrades have the potential to just unplug from old version (12cR1) to new version (2cR2).
    – Reduce total resource usage is reduced on lower use databases.

Oracle Database Optimizer: An Insider’s View of How the Optimizer Works

Oracle database 12c is the first step on the way to making an adaptive, or self-learning optimiser.

Alternative subplans are precomputed and stored in the cursor, so no new hard parsing will be needed as part of the adaption of an already executing plan. Statistics collectors are included in the plan execution. If the collectors cross a threshold, the plan might switch during execution from a nested loops to a hash join.

You can see information about the adaptive actions that have occurred using the DBMS_XPLAN package, with the format of “+all_dyn_plan +adaptive”. If a plan has been adapted, you will see it indicated in the  v$sql.is_resolved_dynamic_plan column.

If this functionality scares you, you can turn it off using the OPTIMIZER_APADPTIVE_REPORTING_ONLY parameter. Same work is done, but no actual adaptive action is taken.

During parallel execution, collectors can influence the distribution method (HASH > Distribution). Shown in the plan as the HYBRID HASH operations.

Dynamic statistics replace dynamic sampling. The resulting stats are cached as SHARED DYNAMIC STATS specific for the statement, including the bind values. This information is used for any session using the same statement.

Cardinality feedback can be used to re-optimize subsequent operations. Join statistics are monitored. Works with adaptive cursor sharing. Persisted on disk. New column v$sql.is_reoptimizable shows that a subsequent run will take this into consideration. Collectors are kept, even if the SQL statement is killed part way through. The plan shows that cardinality feedback is used.

SQL Plan Directives are based on a SQL phrase (a specific join) rather than the whole statement. Cached in the directive cache, but persisted in the SYSAUX tablespace. Managed using the DBMS_SPD package.

Information gathered by the optimizer, may prompt automatic creation of column groups, so next time stats are gathered, the extended stats will be gathered.

What’s New in Security in the Latest Generation of Database Technology

  • Privilege Analysis:
    – Track direct privileges and privileges via roles being used, so you can determine the least privileges needed.
    – Monitoring controlled using DBMS_PRIVILEGE_CAPTURE.
    – Report what is used and what is not used.
  • Data Redaction: A variation in column masking of VPD, but it doesn’t just blank the value and still allows queries against the column in the WHERE clause.
  • Enhanced Security of Audit Trail:
    – Single unified audit trail.
    – Extension of the audit management package.
    – Multiple audit management privileges.
  • Encryption Enhancements:
    – Allow SQL creation and management of wallets, rather than command line utilities. Allows easier remote management.
    – Export and import wallets/keys between plugable databases.
    – Storage of wallets in ASM.
    – Much more…
  • Code-Based Access Control (CBAC):
    – A PL/SQL unit can have roles granted to it.
    – When the unit runs, any dynamic SQL running can have the privileges granted via the role.
    – Doesn’t affect compile time, so focussing very much on dynamic SQL.
    – Useful on invoker rights, since now the PL/SQL can run with user privileges and explicitly granted roles for the unit.
  • Invoker Rights:
    – INHERITED RIGHTS : Control accidental privilege escalation when a privileged user calls an invoker rights unit containing malicious code.
    – Invokers rights for views.
  • Separation of Duties:
    – SYSDBA – God
    – SYSOPER – More limited than SYSDBA, but still very powerful.
    – SYSBACKUP – Just enough to do a backup.
    – SYSDG – Just enough for data guard administration.
    – SYSKM – Just enough to perform basic key management tasks.
    – Roles for audit management.

The Hives

The wrap up party was probably the highlight of the week, thanks to The Hives. They were freakin’ awesome. The front man is a scream. Very funny when he interacts with the audience. Makes me want to be in a band again!

I’ll follow this series up with a wrap-up post.

Cheers

Tim…