Skip navigation.

Feed aggregator

Partner Webcast – Oracle NoSQL key-value database

The Oracle NoSQL Database is a horizontally scaled, Key-Value database for Web Services and Cloud, designed specifically to provide highly reliable, scalable and available data storage across a...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle OpenWorld 2014 – In the middle of it…

Marco Gralike - Sun, 2014-09-28 10:50
It’s funny this might be one of the first time in years that my strange performance hobbies I have (on the side of my regular...

Read More

Exalytics X4-4 - Bigger, Better, Stronger

Look Smarter Than You Are - Sun, 2014-09-28 10:49
X4-4 - Same price as the X3-4 but with more powerThe big announcement about it is today at OpenWorld (it would be awesome if they mentioned it during the Intel keynote tonight), but the Exalytics X4-4 is actually available now.  It's the same price as the X3-4 ($175,000 at list not including software, maintenance, tax, title, license, yada yada).  This does mean the X3 is - effective immediately - no longer available, but then again, since the new one is the same price, I'm not sure why anyone would want the older one.  No word yet on if you can upgrade an X3 to an X4, but since they did offer an upgrade kit from X2 to X3 (though I never heard of anyone buying it), I'm guessing there will be one for those wanting to make an X3 into an X4.
X4-4 SpecsThe main improvement over the X3 is the number of cores: it's still 4 Intel chips, but those chips all now have 15 cores on them, meaning the X4 has 60 cores compared to the X3's 40 cores.  Here are the important details:

  • 4 Intel Xeon E7-8895v2 processors running at 2.8 - 3.6 GHz
  • 8 - 60 cores (capacity on demand, more on this in a second)
  • 2 TB of RAM
  • 2.4 TB of PCI flash
  • 7.2 TB of hard disk running at 10K RPMs (not that fast these days)
  • 2 Infiniband ports running at 40 Gb/s
  • 4 Ethernet ports running at up to 10 Gb/s
Cool Thing 1: Variable Speed & Cores
You probably heard about this last July.  Oracle worked with Intel to design a line of their Xeon E7-889x chips specifically for Oracle.  What we didn't realize until we saw it show up on the X4 spec sheet was that the chips were going in the Exalytics X4.  Simply put, on the fly, Exalytics can vary how many cores it uses and when it's fewer cores, the speed goes up.  If it's running 15 cores per chip, Intel sets the speed to 2.8 GHz.  If it's only using 2 cores per chip the speed goes all the way to 3.6 GHz (a GHz is one billion clock ticks per second).

But wait, you math geniuses say.  Isn't 3.6 * 2 less than 2.8 * 15 (so why wouldn't Oracle just always leave all 60 cores on at the slower speed)?  Well, yes, if you're actually using all those cores, and this is where you know the chip was apparently designed for Essbase (though it did premiere in Exadata first).  As much as I love my Essbase, there are still transactions that end up single threading (or using far less than the available cores on the box).
Say I'm running a massive allocation and despite my best efforts (and FIXPARALLEL), it's still single threading or running at 8 CPUs or fewer.  In this case, Exalytics is now smart enough to talk to those impressive new E7-8895v2 chips, scale down to as few cores as are actually needed, and in the process, up the clock speed for the remaining cores.  Take that, commodity hardware.  This really is the killer feature that makes Exalytics do something no other server running Essbase can do.
On a side note, Intel seems to be dropping the power on the non-used cores to nearly zero when not in use meaning the power consumption of your Exalytics box actually lowers on-demand.  So if your boss won't sign off on your new Exalytics X4, tell her she hates the planet.
Cool Thing 2: You Don't Need BIFSPer the current Engineered Systems Price List (buried down in note 13), you longer have to purchase BIFS (BI Foundation Suite) to buy Exalytics (either the X4 or T5).  You can now own BIFS, OBIEE, Essbase+, or Hyperion Planning+ without having to get a VP to sign off for a special exemption.  That's right, Planning people preferring to purchase pure premium power, you can now buy Exalytics.  With this change, I presume that any new Planning customer looking for the best user experience will be buying Exalytics X4 along with Planning.
Also buried in the footnotes, you apparently can now buy Exalytics for as few as 20 named users.  Last time I checked (and I don't read every edition of the footnotes, haters who think I have no life), the minimum was 100 named users.
What's Next: HFM on ExalyticsWe heard about it on the opening developer's day at Kscope: HFM should finally run on Exalytics in version (which we're hoping to see by the end of 2014).  I'm not sure if it will run on both the T5 (Solaris) and the X4 (Linux) by year-end, but Linux is almost a given.  That said, I don't work for Oracle, so don't base any buying decisions on the belief that HFM will definitely run on the X4.  Just when it happens, be pleasantly surprised that you can now consolidate all your major Oracle Business Analytics apps together.
So any T5 news?  Not at the moment. It's still available running it's 128 cores with 4 TB of RAM (and other cool things) so if you're looking for major horsepower and server consolidation, look to the T5.
I'll be updating this post after the OpenWorld keynote to include any new Exalytics news but if you hear any other Exalytics updates in the meantime, post it in the comments.
Categories: BI & Warehousing

BNB is participating in Oracle OpenWorld 2014

Javier Delgado - Sun, 2014-09-28 10:17
BNB is taking part in Oracle Open World 2014, the most important event for the Oracle customers, partners and employees ecosystem at a global scale. The event is starting today at the Moscone Center in San Francisco, September 28th and will close on October 2nd.

Up to 50.000 people will attend the event, which will involve more than 2.000 presentations. BNB participates as an Oracle Gold Partner, and we will be focusing on PeopleSoft, JD Edwards, Fusion and Taleo, while also looking at new trends on Big Data, Business Intelligence and Internet of Things.

As the event progress, I will be posting my impressions. This is my first Oracle Open World and it's all very exiting!

PS: Follow us under #BNBOOW hashtag.

BNB is participating in Oracle OpenWorld 2014

Javier Delgado - Sun, 2014-09-28 10:15
BNB is taking part in Oracle Open World 2014, the most important event for the Oracle customers, partners and employees ecosystem at a global scale. The event is starting today at the Moscone Center in San Francisco, September 28th and will close on October 2nd.

Up to 50.000 people will attend the event, which will involve more than 2.000 presentations. BNB participates as an Oracle Gold Partner, and we will be focusing on PeopleSoft, JD Edwards, Fusion and Taleo, while also looking at new trends on Big Data, Business Intelligence and Internet of Things.

As the event progress, I will be posting my impressions. This is my first Oracle Open World and it's all very exiting!

OOW 2014: ACE Director Briefing

Doug Burns - Sun, 2014-09-28 05:41

Disclosure: I'm attending Openworld at the invitation of the OTN ACE Director program who are paying for my flights, hotel and conference fee. My employer has helpfully let me attend on work time, as well as sending other team mates because they recognise the educational value of attending. Despite that, all of the opinions expressed in these posts are, as usual, all my own.

The first day of the ACE D briefing was a bit of a wipe-out for me as I had so much catching up on bits and pieces of work and personal email to do, having arrived very late the previous night, although I still managed to spend some valuable time catching up with friends of the Oak and non-Oak variety as well as hearing some useful info from various Product Managers. I was gutted to have missed Thomas Kurian's briefing session because, as I heard later, it was as splendid as usual. I think some of the enjoyment comes from people's fascination with how on top of things he is, talking at all sorts of technical and non-technical levels over a very wide portfolio. That's pretty much how I remember the last few briefings.

Despite the inevitable arrival of jet lag screwing up my sleep, I've been able to enjoy day two much more (once I'd absorbed some light-hearted wind-ups about my disappearing act). Today was always going to be the most enjoyable for me anyway as the agenda was more database-centric.

It kicked off with a session on the current state of play of MySQL which I must admit I've almost forgotten about (conspiracy theorists will enjoy that) but seems to be ticking along quite nicely with incremental performance and functionality improvements although the presenters were keen to point out that MySQLs forte is not it's functionality so much as it's ubiquity in the web area, given it's part of the LAMP stack. Like a lot of the presentations, it might not have been about something I use day to day but was very enjoyable keeping in touch with other technologies.

Next was an informal conversation with Bob Evans, the Chief Communications Officer, which covered a wide variety of subjects with the usual direct and critical approach I've come to expect from the ACE Directors in attendance (you might be surprised!), raising concerns about the interface between Oracle Sales and their shared customers. I was disappointed to hear that there seems to be a pattern of scheduling local sales events at the same time as Oracle ACE tour events. Seems pretty daft to me. (Another one for the conspiracy theorists, I suppose.)

Then Gene Eun gave us an update on the Oracle Database Cloud Service. Although I still feel Oracle are way behind the curve on this, I don't think that necessarily means they can't make up ground, as they have in the past, but I think the most important message for me was a reinforcement of an answer to a question I asked last year. There's no reason why people can't use the same technology to run their own on-premise cloud and, working in Finance as I seem to have done for a while, the most realistic implementations I can imagine are hybrids of onsite and offsite infrastructure to cope with regulatory requirements whilst still gaining the benefits of offsite deployment where that makes most sense.

I didn't spend so much time drinking coffee in the Oracle canteens this year, but I did manage to have an enjoyable catch-up with Uri Shaft, a true development geek who always has interesting thoughts both on those technologies he is or has been involved with, but also other development areas that he has nothing to do with! Never a man short on opinions on software and a truly nice guy. Sadly, the regular JB catch-up no longer exists and that Maria Colgan moves in entirely different circles these days! (That would be a joke, folks, and I'm looking forward to light refreshments and chat when she's in Singapore soon.)

Speaking of Maria, she was part of the presentation team for the two hour Oracle Database Development Update, which is one of the key sessions for most attendees. Penny Avril and Maria Colgan kicked off with an all-too-short session discussing release plans and a little about In-Memory Option but I was left with the feeling that, having put so much work into getting the In-Memory stuff ready, it's now a case of consolidating the work and delivering product. i.e. I didn't notice any earth-shattering announcements in the database area but I suppose last year made up for that!

So most of the session was focused on two non-RDBMS areas. George Lumpkin on documents in the database and JSON stuff which was one of those - interesting but not something I'm likely to work with for a while presentations. 

Dan McLary was almost certainly the speaker of the day as he delved into Oracle's BigData/Hadoop offering in good detail but with passion and a refreshing honesty about where Oracle fit into this field which still managed to be very positive about where Oracle are taking it. As he pointed out, the combination of being able to query anywhere (different data sources and technologies) with the functional richness of Oracle's SQL implementation is likely to be a pretty compelling offering. 

It was an afternoon full of good presenters likely to keep the jet-lagged awake (although both Connor McDonald and I were struggling badly by this stage) like David Peake who covered Apex and a new website - Learning SQL - to help people, erm, learn SQL. I think we'll be hearing more about this in the upcoming week.

Wim Coekaerts is always popular with a small chunk of the ACED crowd and was again with his usual Linux and VM update, an informal conversation delivered without notes or slides which hit mainly on the areas that the attendees wanted to discuss. In a neat piece of agenda symmetry, he pointed out the presence of DTrace probes for MySQL running on OEL, as he discussed in his recent blog post.

By now we were running late and beers were beckoning, so Steve Feuerstein did a great job of just about keeping people going with his discussion of Oracle's attempts to reengage and energise the traditional Oracle SQL and PL/SQL technologies we know and love with a new (and quite possibly younger!) audience - YesSQL! Keep an eye out for what is likely to be a fun and different session with Steven and Tom Kyte and other special guests at 18:30 on Monday in Moscone South 103.

... and with that all wrapped up, it was time for beers and the bus into the city. The hotel check-in wasn't the car crash it usually is, but by the time it was all done and dusted there was just time for a few more drinks and since then it has been sleep, sleep, sleep for me :-(

The usual thanks to the OTN team for putting together a varied and interesting briefing, which must be a really tough task when the Dev folks are all up to their eyebrows preparing for next week. Great work!

I'm hoping just an hour or two more and I'll be bright and breezy for Sunday, the first proper conference day. With my apparently new-found energy and dashing good looks (courtesy of Singapore), I'm expecting the week to be a good one!

Oracle on Windows

Laurent Schneider - Sun, 2014-09-28 05:31

@mkratoch is speaking at 10am UGF2633: Managing Oracle 12c on Windows

Again, 12cR1ps1 came before AIX and HPUX.

SQL> select dbms_utility.port_string, version 
  from v$instance;

PORT_STRING          VERSION         
-------------------- -----------------

Oracle Cloud - Keeping Your Perspective

Floyd Teter - Sat, 2014-09-27 23:54
The fact that we live at the bottom of a deep gravity well, on the surface of a gas covered planet going around a nuclear fireball 90 million miles away and think this to be normal is obviously some indication of how skewed our perspective tends to be.”
             - Douglas Adams, The Salamander of Doubt: Hitchhiking The Galaxy One Last Time

Oracle OpenWorld kicks off tomorrow.  My thoughts are with all the folks struggling through the mess that is the U.S. transportation system right now.  That mess in Chicago has really rippled throughout the country.  Hope ya'all keep your perspective and that things work out to get everyone here without too much trouble.

Many of the messages coming from Oracle over the next few days will have to do with the Oracle Cloud.  Oracle has strategically committed to darn near everything as a service (service offerings being a subset of most cloud definitions, but pretty synonymous with "Oracle Cloud" at the moment).  With Oracle adding a new offering at the rate of one per working day (yeah, really), it's easy to get lost in it all.  It's tough to keep things in perspective.

So I've got a nifty chart I found to help ya'all keep it all straight (wish I could remember where I found it so I could give proper credit...but, alas, as you age the memory is the first thing to go).  This should be a pretty spiffy reference too help keep things in perspective during OpenWorld and even thereafter.  Here ya go...

The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Iggy Fernandez - Sat, 2014-09-27 17:20
On the Toad World site, I’m writing a series of blog posts and Wiki articles on the subject of EXPLAIN PLAN. I’m using EXPLAIN PLAN as a motif to teach not just SQL tuning but also relational theory, logical database design, and physical database design. In a year’s time, I hope to have enough material for […]
Categories: DBA Blogs

Openworld 2014

Steve Karam - Sat, 2014-09-27 14:30
Oracle OpenWorld

Are you going to Oracle OpenWorld 2014? I am, and I hope to see you there! As you probably know, OpenWorld is a humongous event with tens of thousands of people in attendance and some amazing presentations. Why, I even hear Oracle’s new CTO might be there. I wonder if he has anything to talk about?

This year we’ll have a ton of activity at the Delphix booth. You can check out the speaking schedule, location, and more on Delphix’s website. At the very least you’ll want to register to win a sweet custom carbon fiber bike. I’ll be speaking on Monday, Tuesday, and Wednesday at the booth so please come on by and say hello.

I’ll also be hanging out quite a bit at OakTable World with data technology luminaries Kyle Hailey, Tim Gorman, Ben Prusinski, Adam Bowen, and other Delphix folks to take part and prepare for a very special set of events: the Attacks!

CloneAttackDelphix, DBVisit, and Solarwinds will be teaming up to present #CloneAttack, #RepAttack, and #MonitorAttack respectively, three events aimed at giving you real-world usage of some outstanding products for the Oracle world. Delphix specifically will be providing all participants with a 90-day developer trial of Delphix in all its glory so you can learn and experiment yourself with virtual data platforms. Be sure to check it out.

Lastly, I’m excited to announce that I will once again be appearing on #theCUBE this year. John Furrier and Dave Vellante are incredible hosts who really dig deep into the meat of the new tech and offerings in the IT world, and I’m honored to have been a part of their show last year and to be on again this year. That will be on Monday at 1PM PDT, so tune in if you can.

This promises to be an outstanding OpenWorld. I look forward to seeing you there!

The post Openworld 2014 appeared first on Oracle Alchemist.

oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full

Vikram Das - Sat, 2014-09-27 10:40
Yesterday, the users of an EBS R12.2 instance got this error when they logged in:

Error Page
You have Encountered an unexpected error.  Please contact the System Administrator for assistance.

On checking the $EBS_DOMAIN_HOME/servers/oacore_server1/logs/oacore_server1.out, we found this error:

oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full.
       at oracle.ias.cache.CacheHandle.findObject(
       at oracle.ias.cache.CacheHandle.locateObject(
       at oracle.ias.cache.CacheAccess.get(
       at oracle.apps.jtf.cache.IASCacheProvider.get(
       at oracle.apps.jtf.cache.CacheManager.getInternal(
       at oracle.apps.jtf.cache.CacheManager.get(
       at oracle.apps.fnd.cache.AppsCache.get(Unknown Source)
       at oracle.apps.fnd.functionSecurity.Grant.getGrantArray(Unknown Source)
       at oracle.apps.fnd.functionSecurity.Authorization.getFunctionSecurityGrantedMenusForGrantee(
       at oracle.apps.fnd.functionSecurity.Authorization.getFunctionSecurityGrantedMenus(
       at oracle.apps.fnd.functionSecurity.Authorization.getFuncSecGrants(
       at oracle.apps.fnd.functionSecurity.Authorization.testMenuTreeFunction(
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(
       at oracle.apps.fnd.functionSecurity.Navigation.getMenuTree(
We tried bouncing services and deleting $EBS_DOMAIN_HOME/servers/oacore_server1/cache.  None of those actions helped.  Things got back to normal only after the Xmx, Xms,and permsize startup parameters for the oacore JVM were changed in weblogic console on Gary's suggestion:
-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
I also changed it in the context file:
Old: s_oacore_jvm_start_options">-XX:PermSize=128m -XX:MaxPermSize=384m -Xms512m -Xmx512mNew: s_oacore_jvm_start_options">-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
The oacore_server1 and oacore_server2 were bounced after this.  We haven't seen that error ever since.

There is a article: Receive Intermittent Error You Have Encountered An Unexpected Error. Please Contact Your System Administrator (Doc ID 1519012.1)CauseThere are user accounts having extremely high numbers of FUN_ADHOC_RECI_XXXXXXX / FUN_ADHOC_INIT_XXXXXXX assigned.

Users have an extremely high number of (ADHOC) ROLES assigned to them, so when these attempt to login this fills the JOC ( Java object cache ) and causes it to run into it's limits resulting in the errors reported. Once bounce is done all is working fine until such an user logs in again.

While working in AGIS and creating and progressing batches, in the workflow there are several ad hoc roles created which remain on the system and do not get end dated or deleted. This can cause performance issues.
Ad Hoc Roles in WF_LOCAL_ROLES starting with FUN_ADHOC_RECI_XXXXXXX ; FUN_ADHOC_INIT_XXXXXXX with no expiration_date.

A. Run the following SQL to verify if there are accounts having extreme numbers of roles assigned

SQL> SELECT user_name, count(*) FROM wf_user_roles WHERE role_name <> user_name GROUP BY user_name ORDER BY 2;

B. Run following for particular user

SQL> SELECT distinct role_name FROM wf_user_roles
WHERE user_name = cp_user_name
or (user_name = (SELECT name FROM wf_local_roles wlr, fnd_user fusr
WHERE fusr.person_party_id = wlr.orig_system_id
AND wlr.orig_system = 'HZ_PARTY'
AND fusr.user_name = cp_user_name
AND rownum < 2))
AND role_name <> user_name;

Note: Replace cp_user_name with name of user having high number of ADHOC roles

SolutionTo implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Follow the steps given in document to purge the WF_LOCAL_ROLES for the AGIS transactions in 'COMPLETE' status.


3. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.

We had also logged SR with Oracle where they pointed us to the very same article and also asked us to do the following:

Action Plan

1. How to find out the existing adhoc roles?

select name, start_date, start_date, expiration_date
from wf_local_roles
where orig_system = 'WF_LOCAL_ROLES'
order by name;

2. Define an expiration date for the ad hoc role:

exec WF_DIRECTORY.SetAdHocRoleExpiration (role_name=> >,expiration_date=>sysdate-1);

3. Periodically, purge expired users and roles in order to improve performance.

exec WF_PURGE.Directory(end_date);

This purges all users and roles in the WF_LOCAL_ROLES,WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables whose expiration date is less than or
equal to the specified end date and that are not referenced in any notification.

Parameter: end_date Date to purge to.

For more information, please refer to Oracle Workflow API Reference on page 2 – 128.
Use the workflow API's to purge the ad hoc roles:

After end dating the adhoc roles, the expired adhoc roles can also be purged by running the Purge Obsolete Workflow Runtime Data concurrent program. Make sure the "Core Workflow Only" parameter set to N.
Oracle also shared 3 open bugs (unpublished, can be read only Oracle employees) for this issue:
Bug 11772304 : JOC INVESTIGATION WITH 12.2

Categories: APPS Blogs

Suppressing ADF LOV Like Operator Filtering

Andrejus Baranovski - Sat, 2014-09-27 05:05
ADF LOV component provides filtering option with STARTSWITH operation. This is used to check if similar value exists in the LOV, if such value exists - LOV popup is opened with all the suggested values. If user types 10 and there are 100, 1000 in the LOV, instead of accepting value 10 - LOV popup will be opened and all three values 10, 100, 1000 will be displayed. While this is useful, there is no option to turn off such functionality. My post describes a solution, that can be used to disable suggested LOV filtering.

Here you can see, how it works by default. User types 10, there is 100 in the LOV. LOV popup is opened with both suggested values. This can be annoying for advanced user, who already know the code and they don't need to use LOV popup to select it:

We can check generated SQL statement. Original LOV SQL was updated with LIKE and this was applied for bind variable value. This is how suggested LOV values are retrieved:

LIKE is applied for DepartmentID (LOV key), even we have set it explicitly in the LOV View Criteria to use EQUALS operator:

The solution is to override buildViewCriteriaClauses method in VO Impl class. ADF executes additional View Criteria to retrieve suggested LOV values, this criteria name is "__lov__filterlist_vcr___". We can intercept this View Criteria and replace all STARTSWITH operators with EQUALS:

With this fix applied, user could type 10 and there is no LOV popup opened anymore with suggested values:

Same SQL as before is generated, but LIKE is changed to =, this is the result of our fix:

New LOV value can be successfully saved to the DB:

Download  -

I Heart Logs - Event Data, Stream Processing, and Data Integration by Jay Kreps; O'Reilly Media

Surachart Opun - Fri, 2014-09-26 23:01
As I have worked in server-side a long time as System Administrator. I must spend with logs. To use it for checking and investigation in issue. As some policies in some Companies, they want to keep logs over year or over ten years. So, it is not unusual to find out idea to store, integrate logs and do something.
A book tittle "I Heart Logs - Event Data, Stream Processing, and Data Integration" by Jay Kreps. It's very interesting. I'd like to know what I can learn from it, how logs work in distributed systems and learn from author who works at LinkedIn. A book! Not much for the number of pages. However, it gives much more for data flow idea, how logs work and author still shows readers why logs are worthy of reader's attention. In a book, that has only 4 chapters, but readers will get concept and idea about Data integration (Making all of an organization’s data easily available in all its storage and processing systems), Real-time data processing (Computing derived data streams) and Distributed system design (How practical systems can by simplified with a log-centric design). In addition, I like it. because author wrote from his experience at LinkedIn.

After reviewing: A book refers a lot of information(It's easy on ebook to click links) that's useful. Readers can use them and find out more on the Internet and use. For Data integration, It's focused to Kafka software that is a distributed, partitioned, replicated commit log service. It provides the functionality of a messaging system. Additional, It gave why the Big Data Lambda Architecture is good for batch system and a stream processing system and point about things a log can do.

So, Readers will be able to learn:
  • Learn how logs are used for programmatic access in databases and distributed systems
  • Discover solutions to the huge data integration problem when more data of more varieties meet more systems
  • Understand why logs are at the heart of real-time stream processing
  • Learn the role of a log in the internals of online data systems
  • Explore how Jay Kreps applies these ideas to his own work on data infrastructure systems at LinkedIn
Book - I Heart Logs - Event Data, Stream Processing, and Data Integration
Author: Jay KrepsWritten By: Surachart Opun
Categories: DBA Blogs

Oracle OpenWorld is Upon Us! Application Developers Unite!

Christopher Jones - Fri, 2014-09-26 19:25

It's a super, extra, enormously busy time of the year at Oracle because our big Oracle OpenWorld Conference is next week. We have all been working on new products and new presentations.

I have a full mix of events, meetings, presentations and booth duty. If you're at the conference drop by to say Hi. I'll be at the Application Development booth (Left - SLD-163) in Moscone South on Monday morning, Tuesday lunchtime and Wednesday morning (plus other odd times).

Also lookout for me onstage with Tom Kyte on Monday and with Steven Feuerstein on Wednesday.

The session details, and other sessions you might find interesting are listed on my Focus On Application Development page.

If you are a developer, I recommend coming to the Programming and Scripting "Meet the Expert" session at 6pm Tuesday evening (Moscone South - 307). I cannot stress enough how valuable it is to have a dialog and relationship with the developers who create the software and APIs you use.

Oracle Technology Network Team Ramping up to Oracle OpenWorld and JavaOne

OTN TechBlog - Fri, 2014-09-26 18:31

Normally on Fridays we accumulate the Best of Content for that week, but this time around we are going to look at what OTN has in store for Oracle OpenWorld and JavaOne attendees — starting with what is lined up for September 28th in the OTN Lounge located in Upper Lobby, Moscone South.

RAC Attack - 9am to 2pm - Learn how to configure and clone virtual machines, create and set up internal and external virtual networks, create different storage types, and set up a local DNS server and other challenging components.

OTN Kick Off Meetup - 3 to 5pm -  A perfect way to start the week!  Join us for a beverage, grab a community ‘band’ to help find like-minded folks, and network! You'll also be able to make origami, use our photo booth to share how much fun you are having, and Tweet for a beer.

The OTN Community Managers will be posting videos and blogs all week long so make sure to check them out often:

Blogs -
The Java Source Blog
OTN DBA/DEV Watercooler

YouTube Channels -
OTN Garage
OTN ArchBeat

Follow @JavaOneConf for conference-specific announcements

Hacking sessions and interviews on NightHacktingTV - LIVE from the Java Hub, 9am-4pm PT.

APEX 4.2.6 patch available

Dimitri Gielis - Fri, 2014-09-26 15:01
Oracle released APEX 4.2.6 yesterday, it's also available from My Oracle Support as a patch set 19595896.

Here's the table of bug fixes.

Table 6 Bugs Fixed in the Oracle Application Express Patch SetBug NumberDescription18393429Importing pre-4.2 application with data loading results in runtime error18609856APEX_WEB_SERVICE.CLOBBASE642BLOB converts incorrectly18658967Corrupted HTML mail messages are created from APEX_MAIL.SEND18719750ORA-01858 during application import18733989Errors picking up session with cookie when TOP CALL is not FSHOW, or ACCEPT19021052Oracle Application Express 4.2.4 throwing error while generating check boxes19313700Check box fails with ORA-06502 after upgrade from release 4.0 to 4.2.419482775ORA-06502 when importing application containing translations
Applying the patch took less than 7 minutes.

This is probably the latest patch before APEX 5.0 hits the road...

Categories: Development

Patch 19183482 resolves ORA-01403 getting plan with baseline

Bobby Durrett's DBA Blog - Fri, 2014-09-26 14:51

I was testing SQL plan baselines on a base release of Oracle on a 64 bit Linux virtual machine.  I ran DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE to create a SQL plan baseline for a test query after running that query once to get its plan in the cursor cache.  When I ran the test query after creating the SQL plan baseline and called dbms_xplan.display_cursor to see its new plan I got an ORA-01403 error:

ORCL:SYSTEM>select * from table(dbms_xplan.display_cursor(null,null,'ALL'));

SQL_ID  4mu5a860ardpz, child number 1

An uncaught error happened in prepare_sql_statement : ORA-01403: no data found

NOTE: cannot fetch plan for SQL_ID: 4mu5a860ardpz, CHILD_NUMBER: 1
      Please verify value of SQL_ID and CHILD_NUMBER;
      It could also be that the plan is no longer in cursor cache (check v$sql_plan)

I applied patch 19183482 to my test system and the ORA-01403 error went away:

ORCL:SYSTEM>select * from table(dbms_xplan.display_cursor(null,null,'ALL'));

SQL_ID  4mu5a860ardpz, child number 1
select sum(blocks) from test

Plan hash value: 1950795681

| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
|   0 | SELECT STATEMENT   |      |       |       |    29 (100)|          |
|   1 |  SORT AGGREGATE    |      |     1 |     3 |            |          |
|   2 |   TABLE ACCESS FULL| TEST |  2844 |  8532 |    29   (0)| 00:00:01 |

Query Block Name / Object Alias (identified by operation id):

   1 - SEL$1
   2 - SEL$1 / TEST@SEL$1

Column Projection Information (identified by operation id):

   1 - (#keys=0) SUM("BLOCKS")[22]
   2 - "BLOCKS"[NUMBER,22]

   - SQL plan baseline SQL_PLAN_dscatqjvyk4qy6b581ab9 used for this statement

Here is a zip of the script that I ran to create the ORA-01403 error and the output that it generated with and without the patch applied on my test database: zip

Here is a list of the bugs that patch 19183482’s readme says it will fix:


I haven’t gotten very far into my investigation of SQL plan baselines but it looks like it would be a good idea to apply 19183482 before using SQL plan baselines on  I barely got started using SQL plan baselines and I immediately hit this bug.

– Bobby

Categories: DBA Blogs

Security Alert CVE-2014-7169 Released

Oracle Security Team - Fri, 2014-09-26 14:20
Normal 0 false false false EN-US X-NONE X-NONE

Hi, this is Eric Maurice.

Oracle just released Security Alert CVE-2014-7169. Vulnerability CVE-2014-7169, previously known as CVE-2014-6271, affects GNU Bash, and if successfully exploited can result in providing a malicious attacker the ability to fully compromise a targeted system. GNU Bash is a popular open source command line shell incorporated into Linux and other widely used operating systems. The National Vulnerability Database (NVD) has given this vulnerability a CVSS Base Score of 10.0.

Oracle is continuing to investigate this vulnerability. Today’s Security Alert lists the products that Oracle has currently determined to be vulnerable to CVE-2014-7169. Download and installation instructions are provided for those products with available patches. Note that the fixes provided with this Security Alert address both vulnerabilities CVE-2014-7169 and CVE-2014-6271. The Security Alert Advisory will be updated to reflect the availability of fixes for additional products when they have successfully completed testing. It is Oracle’s priority to provide fixes that provide effective mitigation against this vulnerability while not introducing regressions or other issues. In other words, Oracle will provide fixes for additional affected products as soon as they have been fully tested and determined to provide effective mitigation against this vulnerability.

Due to the severity of this vulnerability, the public availability of detailed technical information, and reports of attempted exploitation, Oracle urges customers to apply the appropriate fixes when they become available.

Customers who are concerned about the status of individual products not listed in today’s Security Alert Advisory should contact Oracle Technical Support to obtain additional information. In response to these inquiries, the Security Alert Advisory may also be updated to reflect the status of these products to ensure the wider dissemination of relevant information.

For More Information:

The advisory for Security Alert CVE-2014-7169 is located at

The Oracle Software Security Assurance web site is located at

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Oracle Java Cloud Service

Anshu Sharma - Fri, 2014-09-26 10:56

Oracle Java Cloud Service which is a full featured WebLogic Server available as PaaS is now offering Trials for ISV Partners. Let us know if you have a Java Application which you would like to deploy on this environment. We can take you through the process and would value your feedback.

If you are at Oracle Open World next week then please check out these sessions

Build and Deploy Java Applications on Oracle Java Cloud Service in Minutes [HOL9445]

  • Wednesday, Oct 1, 10:15 AM - 11:15 AM - Intercontinental - Sutter,
  • Thursday, Oct 2, 2:30 PM - 3:30 PM - Intercontinental - Sutter

The Power of Java and Oracle WebLogic Server in Oracle Cloud [CON7930]

Tuesday, Sep 30, 12:00 PM - 12:45 PM - Moscone South - 270 

Oracle Java Cloud Service: Deploy Enterprise Applications in the Public Cloud [CON7936]

Thursday, Oct 2, 10:45 AM - 11:30 AM - Moscone South - 304 

Log Buffer #390, A Carnival of the Vanities for DBAs

Pythian Group - Fri, 2014-09-26 10:50

All eyes are on the Oracle Open World. Thousands of sessions, demos, and labs topped up with the countless networking opportunities, Moscone Center is the place to be.


Oracle OpenWorld 2014 – Bloggers Meetup.

Query to show sql_ids related to SQL Profiles.

Oracle OpenWorld is nearly upon us and the agenda is packed with interesting sessions. Prominent among these are several sessions by customers who are able to share their stories of success with Oracle Multitenant.

The biggest challenge for people coming to such huge events as Oracle OpenWorld is to navigate through all of the events that simultaneously happen at various locations.

Pythian at Oracle OpenWorld 2014.

SQL Server:

Monitoring Longest Running Transaction using SQL Server Agent Alerts .

Free PDF Booklet: 119 SQL Code Smells.

Level 1: What is “SQL Server AlwaysOn“?

10 things I learned about rapidly scaling websites with Azure.

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask


How to do reverse engineering with MySQL Workbench.

MySQL 5.5.40 Overview and Highlights.

MySQL 5.7.5: GROUP BY respects functional dependencies!

JSON UDF functions version 0.3.2 have been released.

Importing related MySQL tables into an Excel Data Model using MySQL for Excel.

Categories: DBA Blogs