Search

Top 60 Oracle Blogs

Recent comments

August 2015

OTN Tour of Latin America 2015 : UYOUG, Uruguay – Day 2

I woke up early and started working on the computer. I wrote a couple of blog posts and logged in to work to check some stuff out. I also re-recorded the vocal for the ALL, ANY and SOME video. The mic I was using wasn’t too good, but I was keen to get it done, rather than wait until I got back to the UK. Overall, it was a pretty busy morning.

Index compression–working out the compression number

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives about index compression, and very little negatives.  But obviously one critical thing is choosing the right number of leading columns to compress. Is it just "take a guess?" .  Luckily, Oracle has taken the guesswork out of it.

The ANALYZE command on an index can let you find the optimial compression count.  When you do an ANALYZE INDEX command, two critical columns are populated:

Navigating the world of Oracle database documentation

If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can find about the database.  If you’re a seasoned Oracle professional, then you probably dont think twice about finding PIVOT examples in Chapter 18 of the Data Warehousing guide Smile

But for the novice, whether it be DBA or Developer, it can be a bit overwhelming.  One resource that you might find a useful addition to your navigation of the Oracle universe, is the interactive quick reference site.

CloneDB in Oracle 12.1.0.2

I personally really like CloneDB, a way to thin-clone an Oracle database over NFS. This can be quite interesting, and I wanted to update my blog for 12.1.0.2.3 (April PSU). Tim Hall has a good example for 11.2.0.2 and later with further references.

My setup is as follows:

Upcoming Raspberry Pi Family Coding Day Project

I’ve had a lot of people email and message me asking me what I’m doing with the Raspberry Pi and I wanted to share before the actual RMOUG Quarterly Education Workshop, (QEW) this Friday at Elitches.

WordPress 4.2.4

wordpressBy the time you read this, you are probably auto-magically running on WordPress 4.2.4. :)

It’s a security release. You can read about the changes here.

Have a good time sitting back and doing nothing while it takes care of itself! :)

Cheers

Tim…

The Proliferation of I.T. Voodoo…

When I say “voodoo” in this context, I’m really talking about bullshit explanations for things based on guesswork, rather than reasoned argument built using facts and investigation.

It’s really easy for voodoo explanations to proliferate when people are starved of facts. There are several ways this can happen, but a couple of them that spring to mind and really piss me off are:

On the Topic of Technology… 8 – First 48 hours with Windows 10

August 3, 2015 (Updated August 5, 2015, August 10, 2015, August 29, 2015) (Back to the Previous Post in the Series) I have been testing Windows 10 under the Windows Insider Program for several months using an old Dell Precision Core 2 Extreme computer (with NVidia graphics card) that was retired from engineering service a […]

OTN Tour of Latin America 2015 : UYOUG, Uruguay – Day 1

After 15 hours of sleep I still managed to feel tired. :) I went for breakfast at 6:30, then started to feel a little weird, so I took some headache pills and headed back to bed for a hour before meeting up with Debra and Mike to head down to the venue for the first day of the UYOUG leg of the tour…

The order of events went like this:

Provisioning Virtual ASM (vASM)

Create vFileshttp://cdn2.oraclealchemist.com/wp-content/uploads/2015/08/add_vfiles-30... 300w, http://cdn3.oraclealchemist.com/wp-content/uploads/2015/08/add_vfiles.pn... 1054w" sizes="(max-width: 840px) 100vw, 840px" />

In this post, we’re going to use Delphix to create a virtual ASM diskgroup, and provision a clone of the virtual ASM diskgroup to a target system. I call it vASM, which is pronounced “vawesome.” Let’s make it happen.