Impugn My Character Over Technical Points–But You Should Probably Be Correct When You Do So. Oracle 12c In-Memory Feature Snare? You Be The Judge ‘Cause Here’s The Proof.

Executive Summary

This blog post offers proof that you will trigger In-Memory Column Store feature usage with the default INMEMORY_* parameter settings.

What Really Matters?

This is a post about enabling versus using the Oracle Database 12c Release 12.1.0.2 In-Memory Column Store feature which is a part of the separately licensed Database In-Memory Option of 12c. While reading this please be mindful that in this situation all that really matters is what (more...)

Announcing the Retail Reference Library 14.0.1 and Translations for the 14.0 Retail Reference Model

The Oracle Retail Reference Library (RRL) release 14.0.1 is now available, and its rich content and artifacts are critical to a successful implementation of Oracle applications.

Oracle Retail Reference Library (RRL) 14.x (Doc ID 1617507.1/Patch 19073202)

The Retail Reference Library contains the three components listed below. Each of the three components can be installed and utilized independently.

  • The Retail Reference Model (RRM) is a comprehensive collection of established, industry leading business (more...)

RESTify your Backends for Mobile Access

Recently Oracle released the new Oracle SOA Suite 12.1.3.

One of the key areas of interest for mobile developers is the all new Oracle Service Bus 12.1.3.

One thing that will make many of the mobile developers who are using Oracle's tool to develop mobile apps is that the service bus design time experience has been integrated into the all new JDeveloper 12.1. (more...)

7 Questions for Tony Kender, Head of Oracle North America HCM Sales

Tony Kender, Senior Vice President, leads Oracle’s sales operations for HCM solutions in North America, including an organization dedicated to the unique needs of midsize companies.

Q: What is the (more...)

Deleted data showing in History?

In the Star ETL process there are 2 main types of updates.  There is the current data (dimensions and facts) and there is the historical data (_hd, hf, history) - see

The current data is overwritten every ETL update.  This will keep your data as up to date as the last ETL.  If you worked on a project, deleted a project, updated tasks, deleted tasks, scheduled (more...)

Plan Instability

There seems to me to be a relatively simple choice.

Either you except that the Oracle Optimizer has a wealth of complicated strategies and, in this complex effort to get the best executions it can, will inevitably either get it wrong sometimes (or take some extra executions to realise it’s wrong).

Or you stick your head in the sand and raise a bug for every unexpected poor execution or plan flip.

But let’s say that (more...)

BUCKET_WIDTH: Calculating the size of the bucket

Some time ago I had some blog posts introducing some of the basic Statistical function available in Oracle. Here are the links to these.

Define Your Own Role for Database Target Access in EM12c

Scenario

  1. Enterprise Manager 12c (EM) installed and agents rolled out to database servers
  2. Access to EM offered to development teams with the primary purpose of allowing them to investigate application related database performance issues

Documentation

The EM documentation covers a selection of privileges you might want to grant to users in database targets in order to allow them to be used for accessing EM functionality. The privileges mentioned are:

  1. SELECT ANY DICTIONARY
  2. CREATE SESSION
  3. EXECUTE on (more...)

Parallel Plans

I’ve popped this note to the top of the stack because I’ve added an index to Randolf Geist’s series on parallel execution skew, and included a reference his recent update to the XPLAN_ASH utility.

This is the directory for a short series I wrote discussing how to interpret parallel execution plans in newer versions of Oracle.

Oracle 12.1.0.2 ASM Filter Driver: First Impressions

This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football  “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.

Currently a Linux-only feature, the ASM Filter Driver (or AFD) is a replacement for ASMLib (more...)

Oracle’s In-Memory Database: The True Cost Of Licensing

At last, the long-awaited release of Oracle Database 12.1.0.2 has arrived, including the highly anticipated In-Memory Database Option. I have had the pleasure of being involved in the early beta stages of this feature and I have say: I'm impressed. This is truly game changing technology, and has been extremely well designed and implemented by […]

How to find out session info about session that comes from remote database through dblink

It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example.

First of all we need to start script on local database:

SQL>                                                                                                                                                                   
SQL> @transactions/global.sql
Enter filters(empty for any)...
Sid           :
Globalid mask :
Remote_db mask:

 INST_ID  SID    SERIAL# USERNAME REMOTE_DB REMOTE_DBID TRANS_ID         DIRECTION   GLOBALID                                           EVENT                      
-------- ----  (more...)

Oracle WebLogic / Fusion Middleware puppet module V2 by Edwin Biemond

The Puppet ORAWLS module has many ensurable WebLogic puppet types and is fast cause of the new WLST domain daemon. Get it here.


WebLogic Partner Community

For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Mix Forum Wiki

Carts and Horses (A reoccurring series)

Putting the Cart Before the Horse

In my years of experience I’ve had the opportunity to engage so many different customers that I’ve lost count. In my professional life I have spent maybe 9 or 10 years total as a contractor. If you assume that I have engaged one new customer every 4 weeks as a contractor (which seems somewhat accurate in my head), then that would (more...)

Standalone sqlplus script for plans comparing

I have a couple scripts for plans comparing:

1. https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql
2. http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active.sql

But they have dependencies on other scripts, so I decided to create a standalone script for more convenient use without the need to download other scripts and to set up the sql*plus environment.
I’ve tested it already with firefox, so you can try it now: http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active_standalone.sql

Some screenshots:
diff_plans.sql:
diff_plans

plans_active.sql:
plans_active

Usage:
1. plans_active:

SQL> @plans_active  (more...)

Oracle Database 12c Release 12.1.0.2 is Here!

...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release 12.1.0.2 supports Linux and Oracle Solaris (SPARC and x86 64 bit).

Get the download here.

And for those of us who just LOVE *sparknotes, here's a quick index of those new features with quick links from good friends and scribes in the Oracle Doc group.  But first, a cool picture. 

Sea Dragon photo taken at (more...)

Gartner Analysis: PeopleSoft Update Manager Delivers Significant Improvements to the Upgrade Tools and Processes

| Jul 24, 2014

For the last several months Gartner Group has been in contact with PeopleSoft customers using the PeopleSoft Update Manager (PUM). This new capability gives customers a high degree of flexibility to selectively apply new features, patches, and legal/regulatory updates.  To understand how customers are utilizing this new capability you can read the full report from Gartner Group here:

PeopleSoft Update Manager Delivers Significant Improvements to Upgrade Tools and Processes

For more information on the PeopleSoft (more...)

AWR Warehouse, Status

So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience.  I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to the ODTUG members on this feature that everyone is so anxious to get their hands on.

Let’s start with some of the top questions:

1. Can I (more...)

Bug with xmltable, xmlnamespaces and xquery_string specified using bind variable

Today I was asked about strange problem: xmltable does not return data, if xquery specified by bind variable and xml data has xmlnamespaces:

SQL> var x_path varchar2(100);
SQL> var x_xml  varchar2(4000);
SQL> col x format a100;
SQL> begin
  2      :x_path:='/table/tr/td';
  3      :x_xml :=q'[
  4                  <table xmlns="http://www.w3.org/tr/html4/">
  5                    <tr>
  6                      <td>apples</td>
  7                      <td>bananas</td>
  8                    </tr>
  9                  </table>
 10                  ]';
 11  end;
 12  /

PL/SQL procedure successfully completed.

SQL> select
  2        i, x
  3   from  (more...)

E-Business Suite Plug-in 12.1.0.3 for Enterprise Manager 12c Now Available

Oracle E-Business Suite Plug-in 12.1.0.3.0 is now available for use with Oracle Enterprise Manager 12c.  Oracle E-Business Suite Plug-in 12.1.0.3 is part of Oracle Enterprise Manager 12 Application Management Suite for Oracle E-Business Suite.

This latest plug-in extends EM 12c Cloud Control with E-Business Suite specific system management capabilities and features enhanced change management support.

The Oracle Enterprise Manager 12c Application Management Suite for Oracle E-Business Suite (more...)