Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

October 2013

PFCLScan Version 1.3 Released

Submitted by pete on Fri, 2013-10-18 12:37

We released version 1.3 of PFCLScan our enterprise database security scanner for Oracle a week ago. I have just posted a blog entry on the PFCLScan product site blog that describes some of the highlights of the over 220 new....[Read More]

Posted by Pete On 18/10/13 At 02:36 PM

EMCLI Rel 3, Post 1

Submitted by dbakevlar on Thu, 2013-10-17 23:43

So as the book gets under way on the Enterprise Manager Command Line Interface, (EMCLI) I’m starting to move away from the introduction statements that I commonly was required to repeat to folks, (“it’s the return to the golden age of the DBA 1.0- command line, baby!” :)) and now are onto what has changed in release 3.

Quiz Night

Submitted by Jonathan Lewis on Thu, 2013-10-17 21:58

The following output is the result of two immediately consecutive SQL statements (with “set echo on”), and nothing else happening to the database.

Cloudera Certified Developer for Hadoop (CCDH)

Submitted by oraclealchemist on Thu, 2013-10-17 20:15

Happy Hadoop

[This entry is part 5 of 5 in the series Cloudera Hadoop Training] 

Taking the Cloudera Developer Training for Apache Hadoop had many rewards — one of which was a free voucher to take the CCD-410 Exam (normally $295) which you must pass to get CCDH certified. I’m not sure if that’s a Cloudera University or Global Knowledge thing, but either way it was definitely a bonus.

Virtual date partitions

Submitted by Jonathan Lewis on Thu, 2013-10-17 18:40

I posted this question on twitter earlier on today (It was a thought that crossed my mind during a (terrible) presentation on partitioning that I had to sit through a few weeks ago – it’s always possible to be prompted to think of some interesting questions no matter how bad the presentation is, though):

Quiz: if you create a virtual column as trunc(date_col,’W') and partition on it – will a query on date_col result in partition elimination?

The answer is yes – on the version of Oracle that I happened to have to hand (12c) the next time I had a few minutes spare. Here’s a quick and dirty demo – with data adjusted to the publication date, so you may need to adjust the code to your current date.

Hash Clusters – 3

Submitted by Jonathan Lewis on Wed, 2013-10-16 12:03

This note is a quick summary of an oddity that came to light after a twitter conversation with Christian Antognini yesterday. First a little test script to get things going:

Merging and Branching a Database

Submitted by khailey on Wed, 2013-10-16 06:30

Three part post

14-01-21-218_950x510

Oracle VirtualBox 4.3 Released

Submitted by oraclebase on Tue, 2013-10-15 17:14

Oracle VirtualBox 4.3 has been released. The downloads and changelog are in the usual places.

There is a nice write-up about the new features here.

So do I upgrade just before the Nordic Tour, or be boring and play safe until after I get back? :)

Cheers

Tim…

Databases for every developer like source code?

Submitted by khailey on Tue, 2013-10-15 13:16

Three part post

sheep

The simple truth is that databases can’t be given to every developer like source code.

Abstracts, Reviews and Conferences, Oh My!

Submitted by dbakevlar on Tue, 2013-10-15 01:31

So yes, I’ve been involved in a number of conferences and in a number of different roles.  I started out presenting, then volunteering  at conferences,  reviewing abstracts, then as a track lead and now as a conference director for RMOUG.  This year I also am the database track lead for ODTUG’s KSCOPE for a second year in a row.