I mentioned in the previous post we were spending the day sightseeing today. Last time I was in Buenos Aires I did a bus tour. You can see some of the photos here.
I woke up far too early and spent a few hours on the computer.
A number of folks on the tour have built up so many Hilton Honours points they get access to the executive lounge, so I was signed in as a scummy guest and I got breakfast for free.
At about 09:00 we walked across to the AROUG event, which had the following order of events.
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.
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:
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
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.
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:
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.
By 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…
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:
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 […]
Recent comments
2 years 51 weeks ago
3 years 11 weeks ago
3 years 15 weeks ago
3 years 16 weeks ago
3 years 21 weeks ago
3 years 42 weeks ago
4 years 10 weeks ago
4 years 40 weeks ago
5 years 24 weeks ago
5 years 24 weeks ago