Oracle Exadata Statement of Direction

There is a very interesting paper about the way of direction of the Exadata Database Machine.

http://www.oracle.com/technetwork/database/exadata/exadata-statementofdirection-2417679.pdf

 

Thanks a lot Günther Stürner.


PaaS & Middleware Partner YouTube Update December 2016

The December edition of the PaaS & Middleware Partner Update contains three key topics:

  • Cloud Partner Opportunities
  • Enrich SaaS with PaaS
  • SOA & BPM Partner Community Webcasts December20th 2016

For regular updates please subscribe to our YouTube channel here. Thanks for your likes and sharing the video on YouTube and LinkedIn. For the latest SOA & BPM Partner Community information please visit our Community update wiki here (Community membership required)

SOA & BPM (more...)

GTT and Smart Scan – the importance of the append hint

While writing the previous two posts about GTTs and Smart Scan, I stumbled across an interesting observation. When I started putting my thoughts to (virtual) paper, I thought it was going to be a short post. Well, it wasn’t to be, again. Anyway, you might find this interesting.

Initial Situation

If you read the previous posts this code example I used to populate the GTT might look familiar:

insert /*+ append */ into gtt select  (more...)

Änderung der endpoint value Berechnung für Histogramme seit Oracle 11.2.0.4

Jonathan Lewis und vor ihm bereits Franck Pachot haben zuletzt darauf hingewiesen, dass in 11.2.0.4 eine Änderung der Berechnung der endpoint values für Histogramme von char und nchar (nicht aber varchar2 und nvarchar2) Spalten eingeführt wurde, die eine Neuerzeugung entsprechender Histogramme nach einem Upgrade von einer früheren Version erforderlich macht, da sich sonst recht bizarre costing-Effekte ergeben.

In Francks Test existiert eine Spalte mit den beiden Werten 'Y' und 'N', die massive (more...)

Resolving two errors on Datapump export – parameter cluster=N/Y

I attempt to export a table with 76,000 rows using a relatively standard datapump command

expdp schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp include=table:"IN('ORDM_ERROR_COUNTS')" parallel=8 logfile=OEC.log

It fails with a fatal error and also produces a warning

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and OLAP options
Starting “ODI_TEMP”.”SYS_EXPORT_SCHEMA_03″:  odi_temp/******** schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp (more...)

Ten Years and Counting

This blog turned 10 this year.  When I started it in 2006 with this article, I had no idea that it would become what it is today.  Things certainly turned out differently than I expected. 


Photo credit: Fulvio Spada, Wikimedia Commons

This little blog now gets millions of visits a year.  It has helped us shape EBS to meet your needs better.  I've been schooled in the many ways (more...)

node-oracledb 1.12.0-dev available for preview

| Dec 4, 2016
A preview of node-oracledb 1.12.0-dev is available on GitHub and can be installed with: npm install oracle/node-oracledb.git#v1.12.0-dev Node-oracledb is the Node.js add-on for Oracle Database. The key things to look at are all the LOB enhancements - we want feedback. There are a couple more LOB enhancements... [Read More]

EM13c: SQL Monitoring Raises ORA-06553

After I have installed the EM13c R2, I noticed that I couldn’t access the SQL Monitoring page. I tested the SQL monitoring page for 11g to 12c database targets, and it gave the same error: ORA-06553: PLS-306: wrong number or types of arguments in call to ‘REPORT_SQL_MONITOR_LIST’. As you can guess I hit a bug, good thing is someone else already raised a service request and Oracle released Patch 24914115 to fix the bug. When (more...)

UKOUG Tech16 : Super Sunday

tech16_300wMy blog posts about a conference usually start with a post about my journey to the event, so…

I got in my car, drove 4 miles, parked my car, walked about 100m.

That’s it. 🙂

I met up with a gang of people in the ICC and pretty soon we moved up to the main reception area, where we had a natter and coffee before everything kicked off. They couldn’t find a badge for Mr Debra Lilley, so (more...)

Applications User Experience OpenWorld 2016 results

image

See what the Oracle Applications User Experience (#OAUX) team did during Oracle OpenWorld 2016 in San Francisco in September on the Voice of User Experience blog, or VoX, where we’ve reposted our most recent Storify collection. Here’s a short summary of the big stuff:

 The OAUX Cloud Exchange, where the OAUX team demos near-future and future concepts, was extended to three days this year. Participants included Oracle partners, industry analysts, private customer (more...)

Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer

I got a question from our internal mailing list… I would like to know how I can view historical SQL tuning recommendations in SQL Developer 4. I don’t want to run the sql worksheet manually but view the automatic recommendations as the query has been running already for several days now. I’m... [Read More]

Oracle Developer Cloud Service and ADF Build/Deployment Automation Summary

We are moving our internal development to Oracle Cloud production instance. This weekend I was going through build automation and deployment process with Oracle Developer Cloud Service. I would like to share few hints with you.

There are excellent video tutorials recorded by Shay Schmeltzer, I would not repeat here all the steps, will post only key steps in the process and few extra tips. Watch Shay's videos to get understanding how it works and (more...)

Toys for when You & I are bored

https://github.com/terrywang/vagrantboxes/blob/master/oraclelinux-7-x86_64.md

https://github.com/yasushiyy/vagrant-oracle11g-rac
https://github.com/yasushiyy/vagrant-oracle12c-rac

https://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_Automation

https://github.com/racattack/vagrantfile

http://oracleprof.blogspot.com/2015/08/automation-for-dba-vagrant-part-1.html
http://oracleprof.blogspot.com/2015/09/automation-for-dba-vagrant-part-2.html

http://vxcompany.com/2016/08/12/vagrant-for-you-rac-test-environment/

http://myofwexperiments.blogspot.com/2015/10/oracle-12c-database-installation-on.html

https://www.centos.org/download/


Exadata GI Upgrade 11.2.0.4 to 12.1.0.2 + PSU Jul2016

giupg

Recently I did a upgrade to Grid Infrastructure 12.1.0.2 on a few Exadata Clusters

Here my summary of the installation

Before you start please read the following MOS note 1681467.1. This note is very helpful and describes the whole procedure in a Exadata environment

It’s not only the Upgrade to 12.1.0.2. In the same „session“ I also install the GI PSU Jul 2016 and the Oneoff Patch (more...)

Podcast Show Notes: Building a Real Cloud Solution by Bob Rhubart

image

This program was recorded on Wednesday, September 21, 2016, during Oracle OpenWorld in San Francisco. "During" is the operative word, since the podcast was actually recorded in my hotel room, several blocks from Moscone Center, where OOW16 was held. The topic was suggested by Oracle ACE and frequent OTN contributor Arturo Viveros, who, along with other panelists, was in town for the big Oracle event. Listen.

The Panelists

Oracle ACE Arturo Viveros
Principal Architect, SYSCO (more...)

Oracle Tidbits – November 2016 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in November 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… #oratidbit The orapki command […]

My Talks/Sessions at UKOUG Tech16

Hi guys,

If you plan to attend UKOUG Tech16, please check out my talks.sessions

  1.  Sunday 12/04 16:10  New JDBC & UCP Perf, Scalability & HA features in Oracle Database 12cR2 @
  2. Monday 12/05 17:55 A RESTful MicroService for JSON Processing in Oracle Database 12c R2 @  
  3. Wednesday 12/07 8:50 Hadoop, Spark & Flink Explained to Oracle DBAs & why They Should Care @ https://t.co/7CGLchAYAF
  4. (more...)

R12.1.x US Benefits Customers: The Affordable Care Act Employer Information Reporting 2016 Phase I Patch has been Released

Oracle EBS Benefits is announcing the availability of the Affordable Care Act Employer Information Reporting 2016 Phase I patch - Patch 24733720:R12.BEN.B.

This patch includes changes to accommodate the 2016 IRS Forms 1094-C, 1095-C and more.

For full details on what is delivered in Patch 24733720:R12.BEN.B along with setup and processing instructions, please consult the functional readme Document 2208547.1 - 2016 Employer Shared Responsibility Reporting Under the Affordable (more...)

Amazon announces Performance Insights

Excited to see the announcement of Amazon RDS Performance Insight feature for database performance monitoring and tuning.

Having met the team for this project I can say from my personal view point that the importance and future success of this feature is clear as day to me. The team is awesomely sharp, the architecture is super impressive, and this is by far the most exciting performance monitoring and feedback system I’ve been involved with,  surpassing the (more...)

New York OUG Winter Event

On December 7th, Gitora founder Yalim Gerger will be at the NYOUG Winter Event to talk about version control of PL/SQL using Git. Click here for the full agenda. We hope to see you there!