Search

Top 60 Oracle Blogs

Recent comments

November 2015

Steve Jobs : the journey of simplicity

#37404e;">Steve Jobs sets a great perspective on the journey of simplicity. It starts from simple, goes through complexity and ends up in simplicity. 
#37404e;" />
#37404e;" />#37404e;">“When you start looking at a problem and it seems really simple, you don’t really understand the c#37404e;">omplexity of the problem. Then you get into the problem, and you see that it’s really complicated, and you come up with all these convoluted solutions. That’s sort of the middle, and that’s where most people stop. But the really great person will keep on going and find the key, the underlying principle of the problem — and come up with an elegant, really beautiful solution that works.” – Steve Jobs

 

Diff’ing AWR reports

#555555;">I don’t know if you are ever asked to compare to AWR periods. AWR period comparison is pretty easy if you have access to the two periods in the same AWR repository. AWR in the same repository can be compared with

#555555;">SELECT * FROM TABLE(
    dbms_workload_repository.awr_diff_report_text(
         [db_id ],
         [instance id],
         120, -- start snapshot id
         121, -- end snapshot id
         [db_id of target,
         [instance id] ,
         122, -- start snapshot id
         123  -- end snapshot id));

#555555;">and it can be run for single instance as

Pragma UDF – Speeding Up your PL/SQL Functions Called From SQL

A new feature for PL/SQL was introduced in V12, pragma UDF. UDF stands for User Defined Functions. It can speed up any SQL you have that uses PL/SQL functions you created yourself.

{please see this second post on some limitations of pragma UDF in respect of IN & RETURN data types and parameter defaults}.

We can create our own functions in PL/SQL and they can be called from both PL/SQL and SQL. This has been possible since V7.3 and is used extensively by some sites to extend the capabilities of the database and encapsulate business logic.

The power of metaphor

We had a question on AskTom the other day, asking us to explain what a “latch” was.

A simple metaphor sometimes does the trick Smile

 

metaphor

d3.js

Here is a short video

D3 Show Reel from Mike Bostock on Vimeo.

Here is a longer tutorial video

Data-driven Documents from London Web Standards on Vimeo.

Oracle Open World: Good News , Bad News

empty

Looking around Oracle Open World this year, it seemed like there was a significant drop in  attendees – at least compared to years past or especially compared to Dreamforce.  Feels like there is a lack of excitement. Makes me feel like Oracle has hit it’s apogee.

Twitter : Is it a valuable community contribution? (Follow Up)

There was some pretty interesting feedback on yesterday’s post, so I thought I would mention it in a follow up post, so it doesn’t get lost in the wasteland of blog comments. :)

Remember, I wasn’t saying certain types of tweets were necessarily good or bad. I was talking about how *I* rate them as far as content production and how they *might* be rated by an evangelism program…

Owning Your Content

Another thing that came out of my conversation with Zahid Anwar at OOW15, was about owning your content.

If your intention is to make a name for yourself in the community, it’s important you think about your “brand”. Most of us old-timers didn’t have to worry about this, and sometimes get a bit snooty about the idea of it, but we started early, so it was relatively easy to get noticed. For new people on the scene, it’s a much harder proposition.

It’s possible to write content on sites like Facebook, Google+ and LinkedIn, but I’m not sure that’s the best way to promote “your brand”. In some communities it might be the perfect solution, but in others I think you are in danger of becoming a faceless contributor to their brand.

Content in SCN

Nul points

(To understand the title, see this Wikipedia entry)

The title could also be: “Do as I say, don’t do as I do”, because I want to remind you of an error that I regularly commit in my demonstrations. Here’s an example:

 
SQL> create table t (n number); 

Table created 

Have you spotted the error yet ? Perhaps this will help: