Search

OakieTags

Who's online

There are currently 0 users and 24 guests online.

Recent comments

Oakies Blog Aggregator

Prize Winners : Managing Multimedia and Unstructured Data in the Oracle Database e-book

A couple of weeks ago I started a competition to win 4 copies of Managing Multimedia and Unstructured Data in the Oracle Database byMarcelle Kratochvil. Thanks to Packt for donating the prizes. The competition closed today and the lucky winners are:

  • Kim Berg Hansen
  • Stuart Uren
  • Steve (dnunknown)
  • Bayu Satria Setiadi

Once I’ve published this post I’ll be sending your email address to my contact at Packt, who will contact you to deliver your e-book.

I was severely tempted to award one of the books to Connor McDonald for his ingenious use of death threats in an attempt to sway the judging process. :)

Cheers

Tim…


Prize Winners : Managing Multimedia and Unstructured Data in the Oracle Database e-book was first posted on April 26, 2013 at 10:37 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.

Analysis Challenges

April 25, 2013 Roughly 12 years ago I was attempting to analyze customer order changes that were received through electronic document interchange (EDI), specifically X12 830 documents that show order forecasted demand for specific part numbers.  At the time, the EDI data was partially transformed and inserted into an Oracle 8.0.5 database, while that data […]

Analysis Challenges

April 25, 2013 Roughly 12 years ago I was attempting to analyze customer order changes that were received through electronic document interchange (EDI), specifically X12 830 documents that show order forecasted demand for specific part numbers.  At the time, the EDI data was partially transformed and inserted into an Oracle 8.0.5 database, while that data […]

E4 2013 – Exadata Conference Call for Papers Closing

 

Just a quick note to remind you that the call for papers for E4 is closing in a few days (on April 30).  So if you have anything you think is interesting related to Exadata that you’d like to share we’d love to hear from you. By the way, you don’t have to be a world renowned speaker on Oracle technology to get accepted. You just need to have an interesting story to tell about your experience. Implementations, migrations and consolidation stories are all worthy of consideration. Any interaction between Exadata and Big Data platforms will also be of great interest to the attendees. Of course the more details you can provide the better.

Here’s a link to the submission page:

Submit an Abstract for Enkitec’s Extreme Exadata Expo

Feel free to shoot me an email if you have ideas for a talk that you want to discuss before formally submitting an abstract.

OPT_PARAM Hint saves the day…

One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by this bug:

The workaround in the bug suggested running this ALTER SESSION command.

alter session set "_optimizer_unnest_disjunctive_subq"= FALSE;

Rather than alter the whole session, we used the OPT_PARAM hint, making the subquery look something like this.

(SELECT /*+ OPT_PARAM('_optimizer_unnest_disjunctive_subq' 'FALSE') */ ... FROM ...)

Slap in a comment reminding us to remove the hint when we move to 11.2.0.4 or 12c and job’s a good’un! :)

Cheers

Tim…


OPT_PARAM Hint saves the day… was first posted on April 25, 2013 at 3:08 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.

Database Virtualization: Data as a Service in Healthcare

#0056d6;">MH900423022The healthcare sector has a clear opportunity to modernize care delivery by adopting new data interchange standards and EHR systems. But getting there will first require upgrading aging infrastructure, managing data explosion, and ensuring compliance with new regulations. This translates to more projects and greater costs for IT resources that are already stretched thin. There is a clear need for transformative technologies that will enable healthcare IT teams to tackle the unavoidable wave of big projects faster and with greater efficiency.

Organizations like Presbyterian Healthcare Services, Health Dialog, Independence Blue Cross, European Bioformatics Institute and many others are leveraging Data Virtualization for databases to modernize care delivery and execute IT projects:

On Time: 20-50% greater project output with the same staff
On Quality: 30% fewer production errors through early detection
On Budget: 90% lower application testing costs (capex and opex)

During this webinar, you’ll learn:

  • #0056d6;">How Data Virtualization for databases improves application project output, quality, and cost efficiency
  • #0056d6;">How Data Virtualization for databases can impact specific projects in your organization including ICD-10 migration, healthcare exchange related projects, private cloud rollouts, data center migrations and much more
  • #0056d6;">How Presbyterian Health uses Delphix to implement Data Virtualization for databases to drive cost and operational gains in its claims processing environment?

register

 

Performance Monitoring

After the last Redgate webinar, what next ?

If you’ve been listening in to the online conversations I’ve been having with Grant Fritchey about SQL Server and Oracle, this is your opportunity to suggest a direction for future discussions. We’re after some ideas for topics that would allow us to spend an hour comparing popular pieces of functionality between the two systems.  If there’s something you’d like to hear discussed, tell me what it is by adding a short comment to this post.

Grid Infrastructure And Database High Availability Deep Dive Seminars 2013

So this is a little bit of a plug for myself and Enkitec but I’m running my Grid Infrastructure And Database High Availability Deep Dive Seminars again for Oracle University. This time these events are online, so no need to come to a classroom at all.

Here is the short description of the course:

Providing a highly available database architecture fit for today’s fast changing requirements can be a complex task. Many technologies are available to provide resilience, each with its own advantages and possible disadvantages. This seminar begins with an overview of available HA technologies (hard and soft partitioning of servers, cold failover clusters, RAC and RAC One Node) and complementary tools and techniques to provide recovery from site failure (Data Guard or storage replication).

In the second part of the seminar, we look at Grid Infrastructure in great detail. Oracle Grid Infrastructure is the latest incarnation of the Clusterware HA framework which successfully powers every single 10g and 11g RAC installation. Despite its widespread implementation, many of its features are still not well understood by its users. We focus on Grid Infrastructure, what it is, what it does and how it can be put to best use, including the creation of an active/passive cold failover cluster for web and database resources.

If you are interested I would like to invite you to head over to the Oracle University website here which has a more extensive synopsis and all the detail you need:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D81641_2043034

UPDATE: I received several emails and comments that the above link does not work. I couldn’t reproduce this until today. It appears to be an issue with the country selection. If you have USA selected in the top right corner the link won’t work, switching to United Kingdom (my preference) will fetch the course detail. I don’t quite understand as to why that is the case since the class is virtual and not depending on a country…

I hope to hear from you during the course!

Fedora 19 Alpha…

For those eager beavers out there, you can now get hold of Fedora 19 Alpha from the pre-release location.

The release notes can be found here. I’m keen to check out the improvements to MATE in version 1.6, as this is now my standard desktop.

Cheers

Tim…

Update: It installs in Oracle VirtualBox and the guest additions install correctly, so it’s looking good so far. :)


Fedora 19 Alpha… was first posted on April 24, 2013 at 11:53 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.

Windows PowerShell…

Followers of the blog know I’m a Linux fan, but over the weekend I needed to fix some stuff on a Windows server at work and I took my first tentative steps into the world of Windows PowerShell. It was very much a case of “scripting by Google”, but I managed to get the job done pretty quickly. That episode prompted this tweet.

powershell-tweet-1

That resulted in two little exchanges. The first from Niall Litchfield, who must have been a little under the weather. :)

powershell-tweet-2

powershell-tweet-3

The second from @WindowsServer.

powershell-tweet-4

powershell-tweet-5

powershell-tweet-6

I think that’s my first interaction with Microsoft on any social network. I sense a new website called “Windows-and-SQL-Server-and-PowerShell-base.com” coming on. :)

Cheers

Tim…

 


Windows PowerShell… was first posted on April 23, 2013 at 7:54 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.