Different plan_hash_value same plan

I mentioned this same effect in an earlier post about SQL profiles: link

I get a different plan_hash_value values for a query each time I run an explain plan or run the query.  I see this in queries whose plan includes a system generated temporary segment like this:

|   1 |  TEMP TABLE TRANSFORMATION   |                             |
...
|  72 |    TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D668C_764DD84C |

For some reason the system generated temporary table (more...)

Oracle has changed the Exchange rate of the Euro to 0.8682

For years the number of 0.7893 meant something to those who are working on regular basis with licenses in Europe. This number is the ‘Current local Pricing Exchange rate’.

And Oracle is entitled to change this rate twice a year:

twice-a-year

This rate remained rock solid for the last couple of years, but Oracle has decided to change this rate at February 3th, 2015.

The new rate of the Euro is now 0.8682.

A (more...)

IR Scrolling – With a Little Help From My Friends

If you are working with interactive reports you will for sure be faced with a problem of wide reports. If you are taking care of the page layout and eventually have more than just an interactive report on the page, you will want to limit it's size to something making sense. The first problem will appear if you limit the width by setting the region attribute to something like this

style="width:830px"

and you will not (more...)

5 Things I wish I knew about apex when I just started (part 1)

I’ve been doing apex for about 7 years now, and along the way I discovered a few things that made my life as a developer a lot easier. I made a list of 5 things thar I wish I had known wen I just started. Those things will be explained to you in a series of 5 posts.

Subscriptions

One of the most tiresome things to do when managing multiple applications is to keep things like (more...)

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 36: The sisters of the mother of all SQL antipatterns

The mother of all SQL “anti-patterns” is the ad-hoc query. Here, the end-user of the application can specify any combination of parameters—for example, the job_id, the dept_id, or a combination of both—and the data is retrieved using a catchall query. This antipattern has two sisters who are almost as evil. These two sisters arise from the requirement to paginate through the records retrieved by a query.(read more)

Comparing NULLable Values

If a column or expression may be NULL, it is a pain to compare it to something else. Why? Because comparisons involving a NULL do not result in TRUE or FALSE: they result in NULL. I use the DECODE function to work around this problem: here's why - and how.

How Set Stack Size to overcome java.lang.StackOverflowError

| Mar 1, 2015

Stack Overflow Crash

Many Java Virtual Machine publishers reduced the default size of a thread's call stack from 1MB to 256KB. This allows more threads to run simultaneously, but it means that each thread is more limited in how deeply its function calls can be nested.

There are circumstances when a stack overflow crash occurs, as the JRockit JVM cannot handle a stack overflow error gracefully. According to the J2SE Java doc, a gracefully handled (more...)

New! Establishing a Mobile Security Architecture

Excerpts from a recent publishing.

Beyond Brute Force: 3 User-Friendly Strategies for BYOD Security*

In 1825 a painter named Samuel Morse was visiting New York City to fulfill a portrait commission and received word that his wife—at home in Washington, D.C.—had fallen gravely ill. The following day, another messenger brought heartbreaking news: Morse’s wife had died from her illness. Morse rushed home as fast as nineteenth-century transit could carry him but arrived (more...)

Business Analytics Monthly Index – February 2015

The following provides quick links to recent Proactive Support Blog postings from over the month just past.

Welcome to the Monthly Index posting for February 2015.

Within each section the items are shown in chronological order.


Oracle Business Analytics
- Proactive Support Blog


Monthly Index - February 2015
General Summary Link
Business Analytics Monthly Index - January 2015
- Monthly Blog Index - January 2015
Patch Set Update: Smart View 11.1.2.5. (more...)

The EBS Technology Codelevel Checker (available as Patch 17537119) needs to be run on the following nodes

I got this error while upgrading an R12.1.3 instance to R12.2.4, when I completed AD.C.Delta 5 patches with November 2014 bundle patches for AD.C and was in the process of applying TXK.C.Delta5 with November 2014 bundle patches for TXK.C :

Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.
[START 2015/03/01 04:53:16] Check if services are down
        [INFO] Run admin (more...)

Oracle Tidbits – February 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in February 2015. 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… Publish Date TidBit 2-Feb #oratidbit […]

Why I Am Excited About JDK 8 Update 40

Doing JavaFX development? Take a look at the very clear performance enhancements in JDK 8 Update 40 (https://jdk8.java.net/download.html) by looking at a new EPUB plugin that's being worked on:

Top Challenges in the Life of an IT Capacity Manager

Let me first confess. I don’t have double-digit years of experience in IT Capacity Management. But I would say, during last 9 years I have defined the process multiple times from scratch. I have seen capacity management process getting traction. Multiple times I was part of the journey where the process got matured from chaotic to efficient. I have also witnessed cases where management couldn’t justify the investment in the process and it got a (more...)

Event Publishing Service – promote your events at oracle.com!

clip_image002Reach new customers and build brand awareness by promoting your events using Oracle’s Partner Event Publishing Service. Qualified partners running live or virtual stand-alone events can publish to both Oracle.com/events and on Oracle’s internal facing events calendar.

This service is available to partners that have achieved at least one Specialization. To find out if your company is eligible for this service, please visit the Solutions Catalog to check your company's achievements. Start to promote (more...)

Custom ADF Application with New ADF 12c Alta UI by Andrejus Baranovskis

clip_image002I was inspired by recently published WorkBetter application with ADF 12c Alta UI demo (you can read more about Alta UI and download WorkBetter application from here - Oracle Alta UI). I have decided to create my own application, using the same guidelines as described by Alta UI. While WorkBetter application is based on EJB, my application is using regular ADF BC model. Right now it displays a list of employees from HR schema (more...)

Programming in C: Few Tidbits #5

1. Splitting a long string into multiple lines

Let's start with an example. Here is a sample string. It'd be nice to improve readability by splitting it into multiple lines.

const char *quote = "The shepherd drives the wolf from the sheep's for which the sheep thanks the shepherd as his liberator, while the wolf denounces him for the same act as the destroyer of liberty. Plainly, the sheep and the wolf are not agreed (more...)

Cedar’s Oracle Cloud and PeopleSoft Day

Cedar held it’s annual Oracle Cloud and PeopleSoft Day in London on Friday, with almost a hundred people in attendance (about 80 customers, plus staff from Oracle and Cedar).

It was a great success, with a really positive vibe – customers are looking to do great things with both PeopleSoft and Oracle’s Cloud suite – and a privilege to be part of.

Here are some photos from the day:

Graham welcomes everyone
2015-02-27 10.05.59

 

Marc Weintraub gave (more...)

ORA-04000

I created a table in an Oracle 11.2 database. I did not specify a pctfree or pctused so it was given the defaults of 10% and 40% respectively:

SQL> conn system/manager
Connected.
SQL> create table t1 (c1 number)
  2  /

Table created.

SQL> select pct_free, pct_used
  2  from user_tables
  3  where table_name = 'T1'
  4  /

  PCT_FREE   PCT_USED
---------- ----------
        10         40 




SQL>

When Oracle inserts rows into (more...)

OTN Yathra 2015 just got over!!

Quite well said – Investment in knowledge is the gives you the best returns. It was a great fun last week to be the speaker at OTN Yathra 2015, organized by All India Oracle Users Group (AIOUG). The OTN tour covered seven cities and I was the part of it at three cities i.e. Hyderabad, Bangalore … Continue reading

Even More Oracle Database Health Checks with ORAchk 12.1.0.2.1 and 12.1.0.2.3 (Beta)

As we have discussed before, it can be a challenge to quantify how well your database is meeting operational expectations and identify areas to improve performance. Database health checks are always important and the more critical your databases are they become even more important.

Oracle health check is now available as ORAchk version 12.1.0.2.1, with versioning aligned with and following the same format used by the Oracle 12c Database Patch (more...)