Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

November 2015

NOUG Session: How Cache Fusion Works

Submitted by arupnanda on Mon, 2015-11-09 19:34

For all those attended my session at Northeast Oracle User Group at Babson College in Wellesley, MA. Have you ever wondered how Cache Fusion knows where to get the block from? Or, how block locks vary from row locks? Or you are confused about the meaning and purpose of various Global Cache Service (GCS), Global Resource Directory (GRD) and Global Enqueue Service (GES). The session was meant to explain how all these actually work under the covers with live demos.

Fedora 23 and Oracle 11gR2/12cR1

Submitted by oraclebase on Mon, 2015-11-09 18:32

A few months ago I mentioned doing some Fedora 22 installations. At the time I did some pre-emptive installations on the Alpha release of Fedora 23 also.

Now the final release of Fedora 23 is out, I’ve run through the articles again to make sure things are all ship-shape.

The Eternal Newbie

Submitted by oraclebase on Mon, 2015-11-09 17:56

It’s been over a decade since I first heard Tom Kyte talking about Project Marvel, which eventually became Application Express (APEX). Since then I’ve “used” just about every version of APEX. I use the term “used” very loosely, because I typically use APEX for a few days to get a job done, then never touch it again for months. By the time I come back, I pretty much have to start the learning process from the beginning again.

Second wave of cloud migration

Submitted by khailey on Mon, 2015-11-09 14:54
#222222;">5444811562_9e5998990e_z
#222222; text-align: right;">photo by Sunova Surfboards
#222222;">
#222222;"> A second wave of cloud migration is now happening after the initial hiccups of
#222222;">

 

Wrong Results

Submitted by Jonathan Lewis on Mon, 2015-11-09 06:23

Here’s a little gem in 12c that arrived in my email a few days ago: a query where the result depends on the SQL*Plus arraysize!

The email had a short description, and a script to create a small data set that would demonstrate the problem. I’m not going to show you the query, or the result set, but here’s a sample of the output from an SQL*Plus session after creating the data. This is, by the way, on a “single-user” system – there is no way that some other session is changing the data – especially after the opening “set transaction”:

Parsing URLs from plsql

Submitted by morten on Mon, 2015-11-09 03:30

Just the other day I needed to parse a URL, and could not find one that acted like I was used to in python. So tired of always missing out in plsql, I want to do something about it.
So yesterday I decided to create a package with different URL utilities that I need from time to time. The package is
called url_ninja. It can split an URL into the different components (scheme, authority, path, parameters, query, fragments)
and back again to a complete URL. It can parse an array into a query string and it can parse a query string into an array.

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 41: Why has my SQL execution plan changed?—A checklist

Submitted by iggy_fernandez on Sun, 2015-11-08 14:00

If the inputs to the CBO change, the plan can change. For example, changes to bind variables can cause the plan to change when it is hard parsed. Therefore one should never be surprised when plans change.(read more)

Oracle ACE program

Submitted by tim.evdbt@gmail.com on Sun, 2015-11-08 04:27

What is the Oracle ACE program?

The Oracle ACE program is a community advocacy program for Oracle technology evangelists and enthusiasts, sponsored by and managed by Oracle Corporation.  As stated on the ACE overview page at “http://oracle.com/technetwork/community/oracle-ace”, it is both a network as well as a resource for everyone in the Oracle community.  It is not a certification program, and there is no course to study and no test to pass.  Rather, the ACE program is a recognition program by one’s colleagues and peers, and joining is a process of nomination, review, and acceptance.

Who are Oracle ACEs?

Dr. Paranoid's Blog

Submitted by oakroot on Fri, 2015-11-06 14:45

Friday Philosophy – We Could Be Heroes! {just for one day}.

Submitted by mwidlake on Fri, 2015-11-06 14:28

At Open World I overheard a snippet of conversation which went something like this:

Bob – “How’s it going? Did the last talk go down well?”
Bill – “Sure, it was on time, the audience seemed to like it.”
Bob – “Will you be here next year?”
Bill – “Errmm….” pause…*sigh*… “I don’t know…. I’ll see how I feel.”
Bob – “Oh? In what way?”
Bill – “It just that, at Open World… I have to fend off two dozen people just to go have a pee!”

Wild horses could not drag out of me the name of the person who said that (though several pints and the offer of a curry might do the trick – try me). It both made me smile and made me think. There are down-sides to becoming highly respected in your sphere.