Skip navigation.

Feed aggregator

Query result cache in oracle 11g

Adrian Billington - Tue, 2014-06-24 16:58
Oracle adds a new cache for storing the results of queries. December 2007 (updated June 2014)

External table enhancements in 11g

Adrian Billington - Tue, 2014-06-24 13:55
Encryption, compression and preprocessing for external tables in Oracle 11g. September 2009 (updated June 2014)

OBIEE Training Site

Abhinav Agarwal - Tue, 2014-06-24 12:33
I was contacted by Seth Williams, who pointed me to this OBIEE training site - http://www.fireboxtraining.com/obiee-training, and asked if I would link to it. There is a an online tutorial, as well as a video, on how to create KPIs using OBIEE - How To Use KPIs | OBIEE Online Training Tutorial
I think this is useful, so am posting it to my blog - which, by the way, you would have seen is not being updated regularly. Feel free to browse to the site. Do let Seth and the people at Firebox know what you think of the site and the tutorial.
Disclaimer: I am not endorsing the site or the trainings. But you know that.

OTN DBA/DEV Watercooler - NEW Blog!

OTN TechBlog - Tue, 2014-06-24 11:35

Laura Ramsey, OTN Database Community Manager, has just launched the OTN DBA/DEV Watercooler.  This blog is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.

Find out more about what you might hear around the OTN DBA/DEV Watercooler in Laura's inaugural post. 

Happy Reading!

Integration Hub – Branding

Kasper Kombrink - Mon, 2014-06-23 04:57
The Integration Hub has come a long way since I first saw it as the Enterprise Portal 8.8. The biggest selling point in my opinion has always been the branding features. Even though the options never really changed, they did evolve

Continue reading

Customize OBIEE login page

Kasper Kombrink - Thu, 2014-06-19 05:15
A login window never really meets requirements (or they are just plain ugly to look at). The typical PeopleSoft login window is one of them, all the languages you will never install is the most heard remark by (super)users. Another

Continue reading

BGOUG Spring 2014 : Summary

Tim Hall - Mon, 2014-06-16 11:30

I know I keep calling it the “spring” conference, but in my mind the two BGOUG conferences are always spring and autumn. This year the “spring” conference was a little late, hence my apparently strange blog titles. :)

I was initially planning to get a taxi from Sandanski to Sofia airport. Fortunately Sve and Mimi were driving back at the same time, so I got a lift with them, which was much better company.

The flight from Sofia to Munich went as planned. After a 110 minute layover in Munich, it was time for the last leg of the journey to Birmingham. Once again, so drama there.

So now I’m home and my 5th BGOUG conference is over. Once again, Melina and the BGOUG team did a great job. No offence to any other user group, but BGOUG is still my favourite conference of the year!

Thanks to everyone at BGOUG for making this run so smoothly. Thanks to the Oracle ACE Program for letting me “fly the flag” for the program. Your support is much appreciated! Thanks to all the other speakers. Your advice and support is always welcome. Of course, thanks to all the attendees who came to my sessions and made me feel so welcome. I look forward to seeing you all again next year.

I’ve shared a few photos on Google+.

Cheers

Tim…

 

 

BGOUG Spring 2014 : Summary was first posted on June 16, 2014 at 6:30 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.

BGOUG Spring 2014 – Day 2

Tim Hall - Sat, 2014-06-14 22:06

The Day 1 evening festivities consisted of lots of food, followed by a group doing a display of traditional dances. Once they had finished it was up to me to teach the Bulgarians how their local dances should really be done. Needless to say I smashed it! :)

Day 2 started with a swim and breakfast. When I say swim, I really mean gentle floating, wishing I was still in bed.

The first session I went to was Joel Goodman‘s session on “RAC Global Resource Management”. Lot’s of good stuff! Joel is like a walking Oracle encyclopedia.

Next up was “Oracle 12c Automatic Data Optimization” by Joel Goodman. Nice feature. Once again, another thing added to my to-do list. I think the developers have done a really bad job of naming the views and some of the procedures for this feature. I would have abbreviated words and added underscores to stay under the object name size limit. The naming feels like “Peter and Jayne do programming”. Ugly, ugly, ugly! In terms of the feature itself, the main issue here is ILM doesn’t work with the multitenant option. I’m sure this will be fixed in future, but for now it is a big flaw. Even so, lots of potential here.

After lunch it was “Utilizing new CBO features after upgrade to 12c – Practical example” by Joze Senegacnik. I have to admit, I turned up late for this one. Very sorry mate! The part of this session I saw focussed on a specific customer upgrade from 11g to 12c.

I ducked out of the last session on the day and headed back to my room. During the day I had been asked a few questions I did not know the answer to, but I know other people who probably do, so I pinged out a few emails.

In the evening we took a quick sightseeing trip to Melnik. We had a walk through the town and did a quick tour of a famous winery.

From there is was back to the hotel to get some food, then bed.

I’ve got an early start this morning to begin my trip home. I’ll write a summary post when I get back.

Cheers

Tim…

BGOUG Spring 2014 – Day 2 was first posted on June 15, 2014 at 5:06 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.

BGOUG Spring 2014 – Day 1

Tim Hall - Fri, 2014-06-13 11:32

The morning started out with a family swim with the wife and daughter.

The first session I attended was “Auditing in Oracle Database” 12c by Maja Veselica. I haven’t spent any time looking at 12c auditing yet, so this was a great introduction. I think I’m going to need to spend some time on this stuff. It looks like there are quite a number of changes to auditing in Oracle 12c.

My first session came next. The room was quite full, which was nice. It’s good to see such a good turnout for PL/SQL. Together we are strong! :)

After lunch I went to watch “Understanding Oracle GoldenGate” by Svetoslav Gyurov. I’ve had GoldenGate on my to-do list since it was aquired by Oracle and I’ve still not got round to using it, so it was cool to see an introductory session on it. Sve can reach the top of the screen, even without a ladder. :)

Next up was “Do Oracle Cloud Applications stack up?” by the wife. You’ve gotta show some support or they just go on at you! This focussed on a customer story about how Fusion Apps on the Cloud was the correct choice. Many of the points raised were true of a variety of cloud solutions. Resistance is futile. We will all be water droplets in the cloud soon!

Next up was my introductory WebLogic session. I think it went down quite well. There were some nice messages/retweets on Twitter. :)

The final session of the day was “Real-World DataGuard” by Yavor Ivanov. The introduction part of the talk covered familiar ground for me, but as the session progressed there were a number of thing mentioned that were new for me. I’ve put another note in my to-do list to spend some more time of data guard, especially in 12c.

So I’m back in my room, writing up this blog post before the evening meal and dancing. I don’t have any presentations to give tomorrow, so I can relax and enjoy other people’s sessions.

As always, a great first day at the BGOUG conference!

Cheers

Tim…

BGOUG Spring 2014 – Day 1 was first posted on June 13, 2014 at 6:32 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.

BGOUG Spring 2014 – Day -1

Tim Hall - Fri, 2014-06-13 11:23

The flight from Birmingham Airport to Frankfurt went to plan. The landing was quite possibly the smoothest one I had ever experienced. Very impressive. I got off the plane to find my connecting flight had been moved to another terminal. I was pretty worried by this as Frankfurt is a massive airport and I already had a short connection time. Luckily I made it. The flight to Sofia went without a hitch.

On arrival, I met up briefly with some of the other speakers before we were whisked away to Sandanski. It was a 3 hour drive, but I was chatting with the wife all the way, so it went quickly.

Once we got settled, we took a quick tour of the hotel spa. It was then I remembered I had no swimming gear. A quick shopping trip down the road and I had swimming shorts and some goggles. Then it was off to the pool, so I could float around and complain about the possibility of sunburn. :)

In the evening we met up with some of the other speakers and the BGOUG folks for dinner in a restaurant right next to the hotel. After that it was back to the room to get some much needed sleep. What with the 03:30 start, two flights, a 3 hour drive and a quick session in the pool I was completely knackered.

Cheers

Tim…

BGOUG Spring 2014 – Day -1 was first posted on June 13, 2014 at 6:23 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.

BGOUG Spring 2014 – The Journey Begins

Tim Hall - Wed, 2014-06-11 22:39

I’m sitting at Birmingham airport, waiting to start my journey to Sandanski. I’ve got a flight to Frankfurt, a sprint to the flight for Sofia, then a 2-3 hour drive to Sandanski. It’s going to be a long day. :)

The airport is really busy. It seems lots of flights leave between 05:00-06:00 on a Thursday. One of the food places is playing plinky-plinky music and I’ve just had to listen to some racist a-holes spreading their uneducated garbage. Very annoying…

Can you tell I am tired and in a bad mood? :)

It’s going to be worth the hassle though. I’m going to be reunited with my wife and daughter. Unfortunately Dad can’t make it to this conference. We will all meet up at OOW this year, where I think we should recreate this family photo.

Cheers

Tim…

BGOUG Spring 2014 – The Journey Begins was first posted on June 12, 2014 at 5:39 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.

Red Hat Enterprise Linux (RHEL) 7 Released

Tim Hall - Tue, 2014-06-10 15:03

It feels almost like heresy to discus something that isn’t Oracle-related on the day that Oracle announced the new In-Memory Database Option, but something else was also released today. Red Hat gave birth to Red Hat Enterprise Linux (RHEL) 7.

I’m a big fan of all things Linux. I’m typing this blog post on a Fedora 20 desktop at home. I’m a rabid fan of Oracle Linux for servers at home and at work. As a result, the birth of RHEL7 is a pretty big deal for me.

I’ve been playing with the Oracle Linux 7 betas for a while (OL7 Install, DB 11gR2 Install, DB 12c Install). I expect we will see the birth of Oracle Linux 7 pretty soon, which is where it gets really interesting for me.

I’m sure it’s going to take quite a long time for Oracle to start supporting their products on RHEL7/OL7, but this is the future, so you’ve for to get your skates on! :)

Cheers

Tim…

Red Hat Enterprise Linux (RHEL) 7 Released was first posted on June 10, 2014 at 10:03 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.

Enterprise Manager Cloud Control 12c Release 4 (12cR4) Articles

Tim Hall - Mon, 2014-06-09 01:26

I’ve started to play around with Enterprise Manager Cloud Control 12R4. The clean installations on Oracle Linux 5 and Oracle Linux 6 were really easy. You can see how I did them here.

I used 11.2.0.4 as the database repository. I’ll probably have a go with a 12c database in future, which is now supported, but my main focus this time was to check out something similar to what I have at work. Forgive my caution, but I’ll not be using 12c database for my EM repository for a while yet. Cloud Control is too important to risk…

I wasn’t going to bother with an upgrade article because  wrote a good blog post about the upgrade here. Whilst going through the upgrade, there were a few things I needed to make extra notes on, since I have an terrible memory, so it ended up as a separate article.

Ultimately, you are going to need to read the upgrade docs because there are lots of caveats to think about, depending on what options you use.

Previous upgrades at work were a pain, but we had a more complicated installation with multiple management servers and a separate database. More recently we switched to running a simple configuration (DB and OMS on the same server) on an Oracle Linux VM. That makes doing a trial run of the upgrade at home a more realistic test. Whether it’s an improved Cloud Control upgrade process or the fact this is a single machine setup, the upgrade was really easy. Now that I’ve practiced the upgrade at home, I’m feeling relatively confident doing the upgrade in production. I’ll probably leave it until I get back from Bulgaria (BGOUG). It’s not really fair to change everything and then leave the country… :)

Cheers

Tim…

Enterprise Manager Cloud Control 12c Release 4 (12cR4) Articles was first posted on June 9, 2014 at 8:26 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.

What happens if you try it?

Tim Hall - Fri, 2014-06-06 08:00

 

QuestionI get asked a lot of questions about Oracle! I find it amazing how often people will fire a question to a forum or social media and wait for response, rather than try the thing out for themselves. My response is often, “What happens if you try it?”. In some cases, their response to that is, “I don’t want to risk it on my production environment”.

It’s incredible how many people are running applications in production without development and test/UAT environments. Even 3rd party apps need a testing ground! Even if you don’t have a formal dev and test environment, the ease of creating a test environment on your PC using virtualization means there are very few grunt DBA tasks you can’t practice before you attempt them for real!

Thanks to the influence of people like Tom Kyte, I learnt early on that I need to test stuff for myself. If you want to progress in IT, you will do it a lot quicker by trying stuff out for yourself…

Cheers

Tim…

 

What happens if you try it? was first posted on June 6, 2014 at 3:00 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.

Fame at last!

Tim Hall - Wed, 2014-06-04 14:22

Someone, who shall remain nameless (Eric Yen), just pointed me to this example of creating a credential in the 12c manual.

Looks kind-of familiar! :)

I mentioned in my 12c scheduler article that the DBMS_CREDENTIAL package is used in pretty much the same way as the old credential procedures in the DBMS_SCHEDULER package. So much so that someone has taken the example from my 11g article (here), replaced the package name and put it in the 12c documentation.

I think this is really funny. I hope they don’t “amend” it. :)

I’ve seen this happen in MOS notes a number of times, but I’ve never seen it in the manuals before. Fame at last!

Cheers

Tim…

 

 

Fame at last! was first posted on June 4, 2014 at 9:22 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.

Oracle Enterprise Manager 12c Release 4

Tim Hall - Tue, 2014-06-03 10:48

Funny how there is no mention of the name “Cloud Control” in the latest announcement. Does that mean we are back to calling it just Enterprise Manager again?

Anyway, the latest instalment of EM has been born. The downloads are available on OTN.

I’ve got mine downloading. The past few versions have been relatively easy to install on a clean system, but the upgrades have been a total pig. I’m hoping this one is going to be significantly easier… Sucker… :)

Cheers

Tim…

 

Oracle Enterprise Manager 12c Release 4 was first posted on June 3, 2014 at 5:48 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.

Hot off the press : Latest Release of Oracle Enterprise Manager 12c (R4)

Pankaj Chandiramani - Tue, 2014-06-03 06:53

Read more here about the PRESS RELEASE:  Oracle Delivers Latest Release of Oracle Enterprise Manager 12c


Richer
Service Catalog for Database and Middleware as a Service; Enhanced
Database and Middleware Management Help Drive Enterprise-Scale Private
Cloud Adoption


In coming weeks  , i will be covering latest topics like :



  1. DbaaS Service Catalog incorporating High Availability and Disaster Recovery

  2. New Rapid Start kit

  3. Other new Features 


Stay Tuned !

Categories: DBA Blogs

Edge of Tomorrow

Tim Hall - Sun, 2014-06-01 12:31

I went to see Edge of Tomorrow today.

You will see reviews that say it’s a Sci Fi version of Groundhog Day, and that is kind-of true, but in a good day.

It’s not overly endowed with plot, but it’s a pretty good Sci Fi flick. I think from now on Emily Blunt should be in every film!

Cheers

Tim…

Edge of Tomorrow was first posted on June 1, 2014 at 7:31 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.

UKOUG Operating System and Storage Event : Summary

Tim Hall - Wed, 2014-05-28 15:19

Today was the UKOUG Operating System and Storage Event. I was a tourist for this event, as I didn’t have any presentations to do. Added to that, I’m a grunt DBA, so I wasn’t too sure what would be waiting for me at an OS and storage event… :)

Thanks to the miracles of Google Maps, I managed to be late for the event, so I missed the first session. Why is it I can get to foreign countries on time, but I can’t get to something that is pretty much in my own city without getting lost?

I bumped into a few people I know there, including Jason Arneil and Martin Nash and a couple of my colleagues. :)

First up (for me) was “Patching Linux with Spacewalk and Ksplice” by Wayne Lewis and friends. Spacewalk looks kind-of neat. It’s a free open source product, with Oracle’s version of it available from public-yum.oracle.com. Basically, it allows you to easily set up a local repositories, manage and track OS package updates across your Linux infrastructure. You can use it for free, or if you want you can choose to buy support from Oracle. The choice is yours. The second half of the session was on Ksplice, which I’ve known about for a long time. As it turns out, my understanding of what Ksplice actually does was quite off the mark, so it was good to be educated… :)

Second up was “Bringing OpenStack to the Cloud” by Stephen Bourke and friends. OpenStack is used to build public and private clouds. That is honestly as much as I actually know about it. :) This session discussed what OpenStack is and talked about Oracle’s implementation of OpenStack. You can read more about it here:

What was most refreshing about Oracle’s implementation of OpenStack is they are keeping it open. At a time when other OpenStack vendors might be trying to provide ClosedStack, Oracle are staying true to cause.

Next up was “Dtrace in Linux and Solaris” by Mike Carew. I’m not one of those guys that spends my life using Dtrace, strace or systemtap, but occasionally you have to get down-and-dirty, so it is good to keep on top of this stuff. Some great strides have been made to bring Dtrace to Linux, but it is still quite limited in comparison to the Solaris implementation. Perhaps as it matures we might get a feature like this on Linux, which I learnt about for the first time today!

“Virtualisation Case Study – How Not To Do It!” by Philip Brown was interesting as it was almost the polar opposite to my feelings about virtualisation. In fairness to him, this was a presentation of how not to do it and ultimately he did make the point that if you do it badly you are going to have a bad experience, which is definitely true. My counter to this is, if you do it well you are going to have a good experience. :) It’s all about using virtualisation where it is appropriate and knowing what you are getting into before you make that leap. Due to me not being able to keep my gob shut, there was a prolonged discussion about this topic after the session, which was fun. You can of course read my thoughts on virtualisation in this article.

I really enjoyed the day! Well done UKOUG and to everyone I saw presenting today. I certainly came away with a lot of good stuff to think about…

Cheers

Tim…

 

UKOUG Operating System and Storage Event : Summary was first posted on May 28, 2014 at 10:19 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.

Godzilla

Tim Hall - Mon, 2014-05-26 17:01

OMG (Oh My Godzilla)! What a total pile of steaming, festering dog crap! It is incredible how they managed to spend $160 Million and produce something with less credibility than Sharknado, which only cost $250,000!

I really don’t think it has any redeeming qualities. How, in a world that brought us Cloverfield and Monsters, can so much money be spent on such a worthless pile of guff like Godzilla. In my Cloverfield review I mentioned how bad the previous spin of Godzilla was. This respin is no better.

I really can’t be bothered to explain why it was such a putrid pile of excrement. Who the hell gave this 7.3 on IMDB? I would rather watch Pacific Rim, and that was total toilet as well…

Cheers

Tim…

Godzilla was first posted on May 27, 2014 at 12:01 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.