Category Archives: Uncategorized

Oracle Fusion Glass App

Lately, I have been working on a Glass App for Fusion.  As developers,  the normal way to create a Glass app is to use HTML 5 and JSON to construct the timeline cards.  Building on Glass is like building a web application.  When going through the Mirror API developer’s guide, although most things are quite [...]

ODBC 32bits for Windows 64bits

Windows-On-Windows 64-bit (WOW64) enables you to run 32bits applications in 64bits OS. You will see there is another powershell, another registry, another ODBC tool, another Oracle client. %SYSTEMROOT%\syswow64\WindowsPowerShell\v1.0\powershell.exe First, we run powershell(x86) Get-itemproperty HKLM:\SOFTWARE\ORACLE\*| Select-Object ORACLE_HOME,ORACLE_HOME_NAME ORACLE_HOME                                                 ORACLE_HOME_NAME ———–                                                 —————- C:\oracle\product\11.2.0\client_32                          client32bit_11203 Only the Oracle 32bit client is displayed cmd /c “%SYSTEMROOT%\syswow64\odbcconf.exe /a {configdsn “”Oracle in [...]

Wasted Space

Here’s a little quiz: If I take the average row length of the rows in a table, multiply by the number of rows, and convert the result to the equivalent number of blocks, how can the total volume of data in the table be greater than the total number of blocks below the table high […]

Man of Steel

I’ve just got back from watching Man of Steel at the cinema. I went into this film with extremely low expectations. For people of my age, this is the third time round for this story, so I expected to be pretty bored from a plot perspective. I’m going to split the film into three parts. [...]


Man of Steel was first posted on June 19, 2013 at 12:04 am.
©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.

Oracle ODBC hello world with powershell

Demo : cmd /c “odbcconf.exe /a {configdsn “”Oracle in OraClient11g_home1″” “”DSN=helloworld|SERVER=DB01″”}” Create a helloworld data source connecting to your DB01 tns alias in your OraClient11g_home1 Oracle Home. It is easy to get the Oracle Home name with Get-itemproperty HKLM:\SOFTWARE\ORACLE\*| Select-Object ORACLE_HOME,ORACLE_HOME_NAME ORACLE_HOME                                       ORACLE_HOME_KEY ———–                                       ————— C:\oracle\product\11.1.0\client_1                 OraClient11g_home1 C:\oracle\product\11.2.0\client_1                 OraClient11g_home2 Then we create the connection (as [...]

Delphix

If you’ve been keeping an eye on my Public Appearances page you’ll know that I am scheduled to go on line with Kyle Hailey for a second (more technical) discussion about Delphix and virtual databases on 19th June (tomorrow). If you haven’t registered, there’s still time to do so. It’s scheduled for 5:00 pm (BST), […]

Running in the Background

Archives

We all have that list of features we just wish Oracle would adopt in their latest version: alterable redo log files, command history in SQL*Plus, DBA_OOPS package with various rollback options when you screw something up… One of my biggest wishlist items is detachable sessions. In Oracle 10g we got the Datapump tool for exports [...]

The post Running in the Background appeared first on Steve Karam :: The Oracle Alchemist.

The Story of Two Boats and Why Justin Bieber Owes Me £120* (Part 1)

(* Inspired by Cary Millsap, although the story isn’t as elegant as one of his …)

It’s 3 weeks, 4 weeks, 2 months since I disembarked from my second boat cruise in a week but it already seems longer. Perhaps it’s because my client had thoughtfully waited until I got back into the office for the next Production release of the application I’ve been working on. That went well, but the subsequent infrastructure performance issues were the latest part of a 5 week long haze, and then it was time to handover to my replacement and make a start on a new role. It’s been an extremely busy few months :-( (

Sunday
My almost traditional pre-conference illness (maybe it’s because these things are in Autumn and Spring or maybe it’s pre-conference stress – who knows?) and the last frantic bits of work for the release on the horizon meant that I had very little time to work on my two new presentations so when I set off for Helsinki on Sunday, it was with laptop powered up and ready to go. Fortunately I had managed at least half of one of the presentations before I got ill. What I didn’t have yet was a hotel room in Oslo for the Wednesday night because when I got around to checking on Friday, there was literally nothing. I was utterly baffled (really, how often is there *nothing* except for a hostel?) but decided I could sort that out later ….

The time difference stole another two hours from me (these things seem more signifcant when your back’s against the wall) but it was a pleasant, uneventful trip and a quiet night in the hotel prepared me for setting sail on Silja Serenade the next morning.

Monday
Having never spent any time in Helsinki, I decided I might as well walk to the boat and Helsinki looks like a beautiful city that I’ll be going back to at some point. Once on board and unpacked in my beautiful sea-view room, I realised that there was a stowaway on board! He has a habit of getting lost …

Gerald the Stowaway
Gerald the Stowaway

Tom Kyte and Bryn Llewellyn had the good grace to give keynote presentations using slides that I’d seen several times by now which gave me most of the first day to work on …  (you get the picture). Never have I been so happy to presenting on the second day of a two-day conference ;-) But I was very keen to see Melanie Caffrey’s ‘Keeping It Simple in Database Application Development’. She’d been giving this presentation at Oak Table Sunday last year at the same time as my 8-bit presentation, so I’d missed out then.

Although I know Melanie through her being a regular at the annual UKOUG conference, I’m not sure that I’ve ever seen her present much before, but she was as engaging and smart as I expected as she went through some of the lessons learned in her role as a Senior Development Manager at Oracle, working on linux.oracle.com. I wish I could remember more of them now, but sometimes I’m so busy listening to the messenger that I can miss some of the message! LOL

I’d warned Melanie how weird it is to be presenting just as the boat sets sail because I remember it from my first time and, sure enough, stuff started clanging, the boat started humming and swaying ever so slightly – it’s an experience everyone should have at least once ;-) She also learned just how polite and quiet Finnish people are when in a sober audience of more than a few people. Never try a rhetorical question to the audience – you’re likely to just get stoney silence back! However, they truly come into their own when you add beer or have a more private conversation – somewhat like most Scots I know!

After that, Heli Helskyaho (@HeliFromFinland) gave the OUGF 25th Anniversary Speech, flipping effortlessly between Finnish and English which is about as impressive as it gets to my ears. Although I have to say, it seems that this 25th Anniversay thing is a bit debatable. Is it 25 or 26 or …. I think someone forgot to start counting!

One of the most enjoyable aspects of a boat conference is the food, and we had one of the first of many great meals, all with plenty of wine thrown in and I was lucky enough to have Melanie, Debra Lilley and Alex Nuijten for company so it was a great way to wrap the day up, particularly as I had almost finished my slides ;-)

Tuesday

Tuesday was a day of worrying about and deliverying two presentations and feeling not a little unwell. It wasn’t so much seasickness as the continuation of the long-running cold that I’d shared with lots of other people, so I was a little tense when I started presenting “10053 Trace Files – Mostly Harmless”, particularly as Tom Kyte and Melanie were in the audience, knowing Tom’s encyclopedic knowledge of Oracle! But it seemed to go reasonably well for the first time giving this presentation, but with some areas that I can improve, particularly some more useful examples.

Then there was time to actually eat some lunch (which is an achievement for me on presentation day) before I moved on to “Fast ETL Processes using Native Oracle Features”. But im the lead-up, I felt really sick and I was concerned I might perform the impressive but disgusting trick of being physically sick mid-presentation! I mentioned the possibility on Twitter, so Alex made sure he turned up with his phone at the ready so he could tweet the evidence! Fortunately I got through it ok. Again, it probably needs a little more polish but the small room was absolutely packed and it went well enough. What I needed most was to lie down and rest, which meant that I missed Alex’s Analytic Functions presentation again (something I have a long personal history of doing …)

It was worth it though, as I was in a much better state when I made it back to the conference area just in time for Heli’s wrap-up session. As well as having a prize-giving raffle from the numbers on peoples conference badges during which some really inconsiderate delegates walked off with all of the Cuddly Toys ;-) , Heli tossed balls around the room to elicit feedback from whichever attendee caught the balls and she asked what was their best thing about the conference. At first I thought it might be embarassing and took a while to get going (Scots and Finns have a lot in common!) but it actually worked really well because I don’t think anyone would have volunteered otherwise ;-) Maybe the real reason I liked the idea was when one of the delegates said that his favourite thing was my presentations, which was brilliant to hear. I always speak at a lot of conferences with great speaker line-ups, so I’ve never actually been told that in the past! Others who I won’t mention are used to it on a regular basis *cough* Jonathan, Tom, Cary … *cough*

Which put me in a great mood for the final dinner which was delicious, as all the catering was. Did I mention? But if you could have seen Bryn, Tom and Melanie *piling* the starters on to their plates, you would know I wasn’t exaggerating. In fact, there were so many interesting and tasty options (particularly for those with wider tastes than me) that a lot of people just about managed a bunch of starters and then a few puddings. Between the company and the food, I didn’t think it could get much better, but then I was voted Speaker of the Day. Again, that’s something that never happened to me and I probably shouldn’t care, but I’m afraid I did, particularly when I considered the other speakers on the agenda. Of course, I cheated a bit by doing two presentations on one day but, hey, I’ll take what I can get ;-) Heli presented me with a Moomin mug and some whisky

Moomin Mug
Moomin Mug

In the interests of actually submitting a blog post, I’ll leave it there for now. Justin Bieber? He can wait!

Hints again

A recent posting on OTN came up with a potentially interesting problem – it started roughly like this: I have two queries like this: select * from emp where dept_id=10 and emp_id=15; select * from emp where dept_id=10 and emp_id=16; When I run them separately I get the execution plan I want, but when I run […]

Webinar questions

Following the webinars about 11g stats that I presented on Monday John Goodhue emailed me a few questions that had come through the chat line while I was speaking, but hadn’t appeared on my screen. He’s emailed them to me, so here are the questions and answers. 1. I’d like to know what parameter to […]