Oracle Coherence Data Grid Videocast
The following is a video presentation about how Oracle Coherence capabilities function, such as in-memory caching, dynamic data partitioning, and parallel query and process execution.
Comments Off | Filed in Oracle | Tags: coherenceTwitter Updates for 2007-12-28
- Watching a video on how to use Skype for interviews http://snurl.com/1vwi5 #
- Has http://getsatisfaction.com/oracle been abandoned in favor of https://mix.oracle.com/ ? It looks like it. #
- AOL has killed Netscape Navigator! Was it alive in the first place?! Too bad, when I first experienced a browser, it was with Netscape Nav. #
Twitter Updates for 2007-12-27
- Hello everyone. I’m back from my Orlando vacation. I Arrived home today at 2:30 AM after a 3 hour delay at Chicago O’Hare. Glad to be home. #
- Even though we had fun in Disney World, we wasted hours just waiting in line. There was a line for everything, even the restrooms. #
- Next time I go on vacation it is going to be somewhere that very few people know about. But I doubt such a place exists. #
- @bigjim Thanks for the tip Jim. I figure anytime other than official holidays is the best time to take a vacation. #
- I have just activated Twitter Tools, a WordPress plugin, on my blog. Now my micro-blogging will be nicely digested into my normal blogging. #
- @Radu43 Yes I missed Twitter. Disney gets -2.0 with all the lines. Waiting in line with two kids is not fun
# - I have to go and make up for lost sleep. You all have a good night and sweet dreamzzzzzzzz. #
Quick Posts from Twitter – 2007-12-22
- and the vacation continues. Now in MGM studios watching The Fantastic with…oh…50000 other people. #
- it’s very hard to twitter or blog while you’re on vacation. I’ll be resuming my normal online activities after Xmas. Have a merry one. #
- @mkrigsman thanks. I will. It’s 80 here during the day. Oh, the show is starting now. Later. #
Quick Posts from Twitter – 2007-12-19
- at PDX waiting to board my flight to LAX. #
- let’s see if I can survive the next 7 days without a computer. I still have my iPhone though. It’s the next best thing. #
- in LAX now. It’s one huge airport. But I like PDX better. I miss the free WIFI in PDX. Off to Orlando in an hour. #
- Made it to Orlando. In a taxi heading to our vacation home. 6:50am now but still 3:50am according to my body clock. #
Quick Posts from Twitter – 2007-12-18
- @marshallk looks like you have an HTML error in the link to Oracle AppsLab blog. #
- Off to my interview at the USCIS in downtown Portland. It’s a pretty wet day today. #
- thanks all for the good luck wishes. Now at the USCIS waiting to be called for the interview. #
- I passed the interview. It was so easy. My naturalization oath ceremony is 3 hours from now. Then I’m off to Florida for vacation
# - Thanks @topperge, @ccmehil, @oracletechnet, @mkrigsman, @carlback, @OracleJulio, @oemperor and everyone else I missed. #
- Now, I gotta go pack and eat. I feel like I want to eat American cuisine today, or maybe Lebanese. #
- I am in the ceremony now watching a short presentation. Will take the oath in a few minutes. #
- Photo: Receiving my US citizenship certificate http://tinyurl.com/3axxr5 #
Quick Posts from Twitter – 2007-12-17
- @yourdon twhirl has been very stable on my PC and laptop. So far, it’s my twitter client of choice. #
- @OracleJulio Good to know. Thanks Julio and congrats to your mom. #
- @oemperor Ah! impeachment did not come to my mind when I read the names. #
- In case you missed it, twitterers: http://snurl.com/1ve8w and http://snurl.com/1ve8z this guy cracks me up. #
- It’s 10PM PST. Twitter and I are going to say good night now. Later… #
The Value of Oracle Users Groups
I was recently elected to the Board of Directors of the Northwest Oracle Users Group (NWOUG). My official title is: membership coordinator, which means that I will be responsible for monitoring and maintaining the NWOUG membership database, answer members’ questions, send out email communications and follow-up on expired memberships, among other things. And, to bring it to the web 2.0 age, I have created the NWOUG mix group and wiki page.
Being a member of an Oracle users group can be useful. For example, NWOUG:
- organizes free lunch-and-learn sessions.
- organizes a yearly conference.
- prints and publishes a journal with news, information and technical articles.
- provides discounts for members on training and such; The latest is $250 off of the regular price of the PSOUG 10 day DBA Boot Camp training.
But, other than the things I mentioned above, what is the added value of joining an Oracle users group? especially with the abundance of freely available information on the Web. Whenever I think about it, I always come back to the same conclusion. I believe that the most value of being a member of a users group are the people you meet during these group events, the face to face interaction, the referrals and experience sharing.
It’s that socializing and communicating with people, who share the same interests as yours, what makes joining a users group in general, and an Oracle one in particular, worthwhile. Don’t you agree? What users group are you a member of? What do you think a users group should do to justify its existence and value to its members?
7 Comments | Filed in Oracle | Tags: usersgroupDid You Know This About Outer Joins in Oracle?
Here is something interesting. Oracle converts this outer join query
SELECT T1.d, T2.c
FROM T1, T2
WHERE T1.x = T2.x (+) and T2.y > 5;
and its ANSI equivalent
SELECT T1.d, T2.c
FROM T1 LEFT OUTER JOIN T2
ON (T1.x = T2.x)
WHERE T2.y > 5;
into this inner join query
SELECT T1.d, T2.c
FROM T1, T2
WHERE T1.x = T2.x and T2.y > 5;
That’s according to the Optimizer Development Group blog. They go on to explain:
Here the filter predicate on the outer-joined table T2 does not contain the outerjoin operator (+); thus it will be applied after the left outerjoin has taken place. This will result in the elimination of all null appended rows of T2. Hence, Oracle converts the outer join into an inner join.
And here is an interesting thing about ANSI full outer joins:
Before Oracle 11gR1 all ANSI full outerjoins were converted into a UNION ALL query with two branches, where one branch contained a left outerjoined lateral view and the other branch contained a NOT EXISTS subquery. A native support for hash full outerjoin was introduced in 11gR1 to overcome this problem. When the native full outerjoin cannot be used, Oracle reverts to the pre-11gR1 strategy.
Their latest blog post about Outerjoins in Oracle is a good read.
1 Comment | Filed in Joins, Oracle | Tags: concepts, joinOracle in 3 Minutes: A Ticking Bomb
Here is the second episode of Oracle in 3 Minutes. I titled it A Ticking Bomb, but you can also call it A Sleeper Bug.
6 Comments | Filed in Oracle | Tags: 3minoracle
