Search

Top 60 Oracle Blogs

Recent comments

November 2016

Attribute clustering (part 2)

In the previous post, I demonstrated attribute clustering by

  • creating a table of source data which contained data in randomised order, via

SQL> create table source_data  as
  2      select d.*
  3      from dba_objects d
  4      where object_id is not null
  5      order by dbms_random.random;



  • and then it loading into a table with attribute clustering defined to cluster the data into the desired order.

The obvious question is then “Why not just cluster the data by combining the two operations ?”, namely

Clearing Clouds: Unraveling IaaS, PaaS, and SaaS

Cloud, Cloud, and More Cloud!

Cloud is upon us! Unless you’ve been living under a rock you must be aware that our industry is headed to the cloud; some of us are already there!

Many cloud services are available and more are coming every day. How can you make sense of the many “#ff0000;">?aaS” acronyms? In this article I’ll explain the differences between Cloud Service Models (IaaS, PaaS, and SaaS) and Cloud Deployment Options (public, private, and hybrid).

Cloud Service Models

Many, many acronyms come along with the cloud; here are three that are common:

  • IaaS  Infrastructure as a Service
  • PaaS  Platform as a Service
  • SaaS  Software as a Service

IaaS

Infrastructure as a Service means that the cloud provider provides: Hardware, Operations. and maybe core operating systems.

Delete/Insert

Many of the questions that appear on OTN are deceptively simple until you start thinking carefully about the implications; one such showed up a little while ago:

What i want to do is to delete rows from table where it matches condition upper(CATEGORY_DESCRIPTION) like ‘%BOOK%’.

At the same time i want these rows to be inserted into other table.

The first problem is this: how carefully does the requirement need to be stated before you can decide how to address it? Trying to imagine awkward scenarios, or boundary conditions, can help to clarify the issue.

If you delete before you insert, how do you find the data to insert ?

Attribute clustering (part 1)

One of the nice facilities in 12c is the ability to instruct the database to co-locate data during loading in order to facilitate reduced resource consumption for subsequent queries.

Here’s an example of it in use. First I’ll create table SOURCE_DATA to mimic some randomised incoming data feed



SQL> exec dbms_random.seed(0)

PL/SQL procedure successfully completed.

SQL> drop table source_data purge;
drop table source_data purge
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>
SQL> create table source_data  as
  2      select d.*
  3      from dba_objects d
  4      where object_id is not null
  5      order by dbms_random.random;

Table created.

So let’s now populate (create) our table T with a straight copy of the data from SOURCE_DATA and index a column of interest

DOAG 2016

I had a great time at DOAG 2016. It’s one of the best run conferences I’ve been to! I did a quick cameo during the keynote to talk about performance in Oracle’s cloud. Nothing like being on stage with a guy wearing a tie. :) Thanks Andrew for inviting me to say a few words.

Kerry_on_stage_doag_2016

Oracle Cloud Performance Testing Results


 

That was fun!

Then I did a couple of technical talks.

Oracle 12.2 DBaaS Availability!

At Oracle Open World 2016 Larry Ellison introduced Oracle Database 12c Release 2 (12.2) and shared that it would be available first to Oracle Cloud customers.

Immediately after Open World 12.2 became available to people who subscribed to the Oracle Exadata Express Cloud; those of us on DBaaS needed to wait for a little while longer.

In the second week of November, Oracle released Oracle Database 12c Release 2 (12.2) to DBaaS (DataBase as a Service) customers. Here’s how it looks when creating an instance:

oracledbaas12cr2

The ACE Scorecard

Azure and Oracle Cloud – My First Time

Below talks about my experience trying out Azure and Oracle cloud for the very first time (and at the same time).


So last night I tried for the very 1st time the Azure and Oracle Cloud. Here, I just like to share my experience. BTW I am a big fan of DigitalOcean because of its user friendly interface, very fast to setup (end to end 2 minutes w/ few button clicks), and fantastic community and HOWTOs (https://www.digitalocean.com/community/). If I have to choose a cloud dev environment provider I would still use DigitalOcean.

Now, being a newbie on both these platforms. I’m looking for a similar experience as DigitalOcean.

The cloud experience comparison is broken down to 3 categories:

DOAG 2016 - "Oracle Database Cloud Performance" presentation material

Thanks to all attendees that came to my presentation "Oracle Database Cloud Performance" at the DOAG conference 2016. You can check the presentation material here at Slideshare.

Friday Philosophy – Your Experience can Keep You Ignorant

This week I was in an excellent presentation by Kerry Osborne about Outlines, SQL profiles, SQL patches and SQL Baselines. I’ve used three of those features in anger but when I looked at SQL Patches I just could not understand why you would use them – they looked to me like a very limited version of SQL Profiles.