I remember hearing someone talking about this years ago and I never actually took the time to check it out. It looks like the real answer is “it depends”. For the basic loop processing and maths the JVM does look a little faster. It was just a curiosity thing, but I thought I might as [...]
¶
Posted 28 August 2010
† Tim...
§
‡
°
The APPEND_VALUES hint is new to 11gR2 and allows you to use direct-path inserts from “INSERT INTO … VALUES” type statements. Pretty neat if you are doing inserts in a FORALL statement and need the extra punch. Cheers Tim…
This afternoon I’ve been cleaning up some data in an SQL Server database. I decided to use SQL*Developer to connect to SQL Server by following this post. Using Oracle SQLDeveloper to access SQLServer (The “Check for Updates” functionality doesn’t seem to work properly on my SQL*Developer running on CentOS 5 (64-bit), so I had to install [...]
I was recently nominated and approved as a member of the OakTable Network . Do you ever get that feeling that one day people are going to realize you don’t have a clue what you are talking about? I think that day just got a little closer. Cheers Tim…
I was scooting around the net and I stumbled on a reference to Wirth’s Law and had a flashback (not Nam related) to a conversation I had about 14 years ago with my boss at the time. We were setting up the kit for a new automated warehouse solution (Oracle 7, HP 9000s and ServiceGuard [...]
Until a couple of days ago I hadn’t even realized that Fedora 13 was out. I guess that shows how interested I am in Fedora these days. Anyway, I had a play around with it. Fedora 13 (F13) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 13 (F13) Cheers Tim…
With the recent news that the latest version of VirtualBox now supports shared disks, I thought I better give it a go and see if I could do a RAC installation on it. The good news is it worked as expected. You can see a quick run through here: Oracle Database 11g Release 2 RAC [...]
Thomas Roach just posted about the latest version of VirtualBox supporting shared disks. Seems like I can finally get rid of VMware Server and become a complete Oracle bitch… Cheers Tim…
Question: What is the most important skill any Oracle DBA/Developer needs? Answer: Knowing how to search the Oracle documentation. The Oracle database is a massive product. There are sections of it I’ve never ventured near. Do I spend my time trying to remember syntax and procedures for every possible occurence? No. I try to understand [...]
I wrote about some new bits of 11gR2 auditing a while ago. Well actually it’s a bit of audit vault functionality that was included in 11gR2. While answering a question today I confidently proclaimed that while you can move the AUD$ and $FGA_LOGS tables to another tablespace, it’s not a great idea and could make [...]