Search

Top 60 Oracle Blogs

Recent comments

July 2013

12c ddl logging

In new releases, its often the little things that really catch my attention.

Like this one…. I love it

SQL> alter system set enable_ddl_logging = true;

System altered.

SQL> create table t ( x int );

Table created.

SQL> drop table t purge;

Table dropped.

SQL> host cat ddl_cdb12.log
diag_adl:create table t ( x int )
diag_adl:drop table t purge

Awesome

Wrong Index 2

A couple of days ago I wrote an article about Oracle picking the “wrong index” after an index rebuild, and I mentioned that the sample data I had generated looked a little odd because it came from a script I had been using to investigate a completely different problem. This note describes that other problem, which appeared on the Oracle-L mailing list last month.

On the Topic of Technology… 5

July 7, 2013 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) As many readers of this blog are probably aware, Oracle Corporation has released Oracle Database 12.1.0.1 so far for the Linux, Solaris, and Windows platforms.  Oracle Database 12.1.0.1 may be downloaded from Oracle’s OTN website.  This article is not […]

On the Topic of Technology… 5

July 7, 2013 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) As many readers of this blog are probably aware, Oracle Corporation has released Oracle Database 12.1.0.1 so far for the Linux, Solaris, and Windows platforms.  Oracle Database 12.1.0.1 may be downloaded from Oracle’s OTN website.  This article is not […]

Oracle WebLogic 12cR2 and ADF Runtime Installations…

The new versions of the WebLogic 12cR2 and ADF could not have come at a worse time for me. My top priority is learning about the 12cR1 version of the database. Second, is getting to grips with Cloud Control 12cR3. Third on the list is getting up to speed with the changes in WebLogic 12cR2 and ADF. Unfortunately, my personal priorities don’t quite match my work priorities, so WebLogic 12cR2 has moved up the list for a while. As a result, I did some installations last night.

12c install on Windows

This is not a complete how-to, because I do not think its warranted…you pretty much click Next Next Next (which in itself is a credit to the product)

But one thing to note – on the few machines I’ve installed it on, the installer gets to 100% and then just sits there for a LONG time.

If you click on the "Details" button, you’ll see the location of the installer log.  The long pause is in the "Saving Inventory" phase…

So my advice is – just be patient.  It will (eventually) get to the "Installation finished" message :-)

12c Partial Indexes For Partitioned Tables Part II (Vanishing Act)

In Partial Indexes Part I, we looked at how it was possible with the 12c database  to create a Partial Index based on data from only selected table partitions. The resultant Partial Index can be either a Global or Local Index. In Part I, we only really looked at Global Indexes, so let’s look at […]

Implicit Statement Results and Extended Data Types in Oracle 12c…

Over the last couple of days I’ve put another couple of articles live. In this case they are both focused on easing migration from non-Oracle databases to Oracle.

It’s a little hard to get excited about either feature as I would not expect any straight Oracle shop to want to use them.

12c Top N (px)

A comment from Greg Rahn in response to my posting yesterday prompted me to do a quick follow-up (test time ca. 3 minutes, write-up time, ca. 50 minutes – thanks for the temptation, Greg ;). Greg asked if the “Top N” would push down for a parallel query, so all I had to do was re-run my script with a parallel hint in place. Here’s the resulting execution plan (from explain plan, but v$sql_plan showed the same structure):