The application and usage of the Oracle Database In-Memory has been described by Pom Bleeksma in this post. Oracle Database In-Memory can result in huge improvement in application query performance. This post will answer the question: “what would be an optimal situation for using the Oracle Database In-Memory feature?” The most predictable answer for these kind of questions is “it depends”. It is advisable to consult an expert before investing in this feature since (more...)
In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically 188.8.131.52. They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:
create cluster pt_hash_cluster ( id number(8,0), d_date date, small_vc varchar2(8), padding varchar2(100) ) -- single table hashkeys 10000 hash is id size 700 partition by range (d_date) ( partition (more...)
When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN. Without knowing the password for SYSMAN, how can I access the EM 12c interface? The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Before changing the SYSMAN password (more...)
Here are the links to the important stuff:
One of the main features of this new release is that it (more...)
One question I get asked a lot is “how can I add additional agent software to OEM 12c”? The answer is pretty easy; just download and apply to the software library. Now what does that mean? In this post, I’ll explain how to download additional agents for later deployments to other platforms.
After logging into OEM 12c, go to the Setup -> Extensibility -> Self Update (Image 1).
This just in from OTN Database Forum – a surprising little bug with “group by elimination” exclusive to 12c.
alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss'; select /* optimizer_features_enable('184.108.40.206')*/ trunc (ts,'DD') ts1, sum(fieldb) fieldb from ( select ts, max(fieldb) fieldb from ( select trunc(sysdate) - 1/24 ts, 1 fieldb from dual union all select trunc(sysdate) - 2/24 ts, 2 fieldb from dual union all select trunc(sysdate) - 3/24 ts, 3 fieldb from dual union (more...)
If you go to Help -> Check for Updates, tick the Open source and Partner Extensions checkbox and press Next:
Select the ADF (more...)
A quick post to let you know about the two presentations that I’ll be doing at Oracle Open World 2014.
Session ID: UGF4482
Session Title: “Getting Started with SQL Pattern Matching in Oracle Database 12c“
Venue / Room: Moscone South – 301
Date and Time: 9/28/14, 13:30 – 14:15
A comment on one of my early blogs about the 12c in-memory database option asked how Oracle would deal with read-consistency. I came up with a couple of comments outlining the sort of thing I would look for in a solution, and this note is an outline on how I started to tackle the question – with a couple of the subsequent observations. The data is (nearly) the same as the data I generated for my previous article on the (more...)
Over the last two weeks I’ve been working on a heartbeat monitoring solution for a client. This is not the normal heartbeat solution provided by Oracle as described in note 1299679.1; yet very similar. The approach that I configured is similar to a traditional heartbeat setup but uses the same extract and replicats already being used by the database/application. For simplicity reasons, I like to call this approach an Integrated Application Heartbeat.
In order (more...)
If you have done any play with the latest release of Oracle database 12c, you must have come across the concept of Common and Local users. I won’t rewrite what’s already there in the docs but for setting the context of the post, a Common user must be created with a prefix added to the username-C##. Miss that and you won’t be able to create one while being connected to the Container database. On (more...)
The fourth issue of OTech Magazine, the independent magazine for Oracle professionals, is available. For the summer 2014 issue there are some more personal articles included. Titles vary from The Spiritual Programmer to The Next Generation: Oracle SOA Suite 12c and back via How to protect your sensitive data using Oracle Data Vault.
Download OTech Magazine – Summer 2014 here.
In a recent article, I discussed how to configure the SOA Suite 12c for sending emails using GMail: http://technology.amis.nl/2014/08/05/setup-gmail-as-mail-provider-for-soa-suite-12c-configure-smtp-certificate-in-trust-store/. An interesting aspect of that configuration is the loading of the GMail SSL certificate into the Keystore used by WebLogic, in order for the SSL based interaction with GMail to successfully be performed. The configuration of GMail for inbound interactions requires a similar procedure for the certificate for the imap.gmail.com server.
Every once in awhile when I restart an extract, I see entries in the report file that reference “Bounded Recovery”. What exactly is “Bounded Recovery”?
First, keep in mind that “Bounded Recovery” is only for Oracle databases!
Second, according to the documentation, “Bounded Recovery” is a component of the general extract checkpointing facility. This component of the extract guarantees an efficient recovery after an extract stops for any reason, no matter how many uncommitted transactions (more...)
I was aware that up to Oracle 11g, a PL/SQL program wasn’t allowed use an associative array in a SQL statement. This is what happens when I try to do it.
SQL> drop table test_array purge; Table dropped. SQL> create table test_array as 2 select level num_col from dual 3 connect by level <= 10; Table created. SQL> select * from test_array; NUM_COL ---------- 1 2 3 4 5 6 7 8 9 10 10 (more...)
On the 22nd of july, patchset 220.127.116.11 for Oracle 12c database was made generally available for Linux x86-64 and Solaris.
This patchset includes the eagerly awaited In-memory option which promises an application transparent performance boost by using column-format data storage in memory.
Database In – Memory uses an In-Memory column store (IM column store), which is a new component of the Oracle Database System Global Area (SGA), called the In-Memory Area. Data (more...)