Search

Top 60 Oracle Blogs

Recent comments

March 2016

Quiz

Can you spot anything that might appear to be a little surprising about this (continuous) extract from a trace file ? The example is from 10.2.0.5, but 11g and 12c could produce similar results (or direct path read equivalents):

Gluent New World: In-Memory Processing for Databases

As Gluent is all about gluing together the old world and new world in enterprises, it’s time to announce the Gluent New World webinar series!

The Gluent New World sessions cover the important technical details behind new advancements in enterprise technologies that are arriving into mainstream use.

These seminars help you to stay current with the major technology changes that are inevitably arriving into your company soon (if not already). You can make informed decisions about what to learn next – to still be relevant in your profession also 5 years from now.

Think about software-defined storage, open data formats, cloud processing, in-memory computation, direct attached storage, all-flash and distributed stream processing – and this is just a start!

OGh DBA Day – Call for Papers!

While part of this packed event is already underway (SQL Celebration Day bit), the DBA…

KeePass 2.32

KeePass 2.32 has been released. You can download it from here.

You can read about how I use KeePass and KeePassX2 on my Mac, Windows and Android devices here.

Cheers

Tim…


KeePass 2.32 was first posted on March 14, 2016 at 12:33 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 Midlands : Event #14

Tomorrow is Oracle Midlands Event #14.

om14

Please show your support and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…


Oracle Midlands : Event #14 was first posted on March 14, 2016 at 11:33 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.

Oracle Data Masking and Secure Test Databases

My daily work is helping my customers secure their Oracle databases. I do this in many ways from performing detailed security audits of key databases to helping in design of secure lock down policies to creating audit trails to teaching....[Read More]

Posted by Pete On 14/03/16 At 08:45 AM

The first matching row

I was recently asked when presented with a query along the lines:


SQL> select * from
  2  ( select x
  3    from   t1
  4    where  x = :b1
  5    union all
  6    select x
  7    from   t2
  8    where  x = :b1
  9  )
 10  where rownum = 1
 11  /

and asked – will the “ROWNUM” lead Oracle to be smart enough to stop after the “top” half of the UNION ALL if it gets row back ?

Let’s find out. First we create tablespaces for tables to be stored, and plonk a table in each.

UKOUG Application Server & Middleware SIG – Summary

ukougOn Thursday I did a presentation at the UKOUG Application Server & Middleware SIG.

As I mentioned in my previous post, I was not able to stay for the whole day. I arrived about 30 minutes before my session was scheduled to start. The previous session finished about 10 minutes early and the speaker following me cancelled, so my 45 minute session extended to about 70 minutes. :)

 

BI Publisher Integration in EM12c

As some of you would already know, for my sins I am the product manager with responsibility for BI Publisher in Enterprise Manager [I must have a lot of sins because I’m also responsible for Change Management, Compliance Management, Configuration Management (these three form the Database Lifecycle Management pack), jobs, the target discovery framework, and at least part of DBaaS along with data cloning and refresh </p />
</p></div>

    	  	<div class=

GoldenGate Plug-in for Enterprise Manager 13.1 is released

Just a quick post to let you know the EM13.1 plug-in for GoldenGate has been released by the GoldenGate development team. I know some of you have been waiting for this, so head on over to the official announcement for all the details!

The post GoldenGate Plug-in for Enterprise Manager 13.1 is released appeared first on PeteWhoDidNotTweet.com.