Search

Top 60 Oracle Blogs

Recent comments

July 2015

The Queen of Social Media Mean

Unlike other forms of communication, social media can be a real gray area for rules on what dictates freedom of speech and how you have to endure with those that may not be pleasant to interact with.  I’m often told what etiquette some feel it necessary and that I should just disengage from some people online.

APEX 5.0.1 : We’re all patched up!

apexAPEX 5.0.1 was released about a week ago. I started to patch some stuff straight away. We were already on APEX 5.0 across the board, so we didn’t need to do any full installations, just patches.

During the patching I noticed we were getting some issues with supposed misconfiguration of static files. After clearing my browser cache, the message went away, so I tweeted this.

MobaXterm 8.0

command-promptI just noticed MobaXterm 8.0 was released a few days go.

Downloads and changelog available in the usual places.

Happy unzipping!

Cheers

Tim…


MobaXterm 8.0 was first posted on July 24, 2015 at 3: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.

AUDIT_SYS_OPERATIONS defaults to TRUE in #Oracle 12c

A small but remarkable change in Oracle Database 12c is the default value of AUDIT_SYS_OPERATIONS has changed to TRUE now. In other words, all actions done by the superuser sys are being audited now by default!

Subquery Factoring (9)

Several years go (eight to be precise) I wrote a note suggesting that Oracle will not materialize a factored subquery unless it is used at least twice in the main query. I based this conclusion on a logical argument about the cost of creating and using a factored subquery and, at the time, I left it at that. A couple of years ago I came across an example where even with two uses of a factored subquery Oracle still didn’t materialize even though the cost of doing so would reduce the cost of the query – but I never got around to writing up the example, so here it is:

ORA-15410: Disks in disk group do not have equal size

12.1.0.2 ASM introduced a new feature which might prevent you from adding dissimilar size disks into a normal or high redundancy disk groups. The relevant MOS note is Doc ID 1938950.1.

Unfortunately I've found that some information in this note requires further clarification.

COMPATIBLE.ASM

The note suggests that the check is only enforced when the Disk Group has 'COMPATIBLE.ASM'='12.1.0.2' attribute set. This is incorrect and can be easily demonstrated:





SQL> select name, compatibility from v$asm_diskgroup;

NAME COMPATIBILITY
------------------------------ --------------------
DATA 11.2.0.3.0

SQL> alter diskgroup data add disk '/dev/sdc';
alter diskgroup data add disk '/dev/sdc'
*
ERROR at line 1:
ORA-15032: not all alterations performed

WordPress 4.2.3 : Hurry up and … let it fix itself…

WordPress 4.2.3wordpress has been released.

It contains fixes for some pretty nasty stuff. Usually, the updates have to be manually triggered for a day or so before the auto-update feature picks them up. I was on the blog this morning and there were no “manually triggered auto-updates” available, so it looks like this one has been pushed straight out, which probably makes sense.

By the time you’ve read this you are probably up to date already, but if not, get on your blog and give it a nudge. :)

Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics

My recent dalliance with YouTube (141 subscribers and growing! :) ) has left the blog feeling a little bit unloved of late, but then why write when you can waffle in the car? :)

Anyway, the 12c learning train keeps on rolling. I’ve recently put the following articles live.

Invalidation

Someone who attended my sessions at the Bucharest Oracle Summit earlier on this year sent me an example of a quirky little bug, possibly related to the newer “fine-grained” invalidation mechanisms, possibly related to ANSI syntax SQL, that’s very easy to reproduce. (That’s always nice for Oracle support – a perfect test case.)

All it takes is two tables and a packaged procedure that queries those tables. The package is coded to do something that should not be allowed in production code; but “should not” and “is not” are very different things. For anyone who wants to play with the example, here’s the script to create the necessary objects:

So long, and thanks for all the fish

After fifteen years at the helm of Scale Abilities, I have decided it’s time for the next chapter. Scale Abilities is closing down and I’m taking a job with another company. Fifteen years is a long time, especially in the technology business, and it might be a bit of a shock to those that have … Continue reading "So long, and thanks for all the fish"