Example Jmeter workload for Postgres and Oracle

pgload.jmx is JMX file you can load into Jmeter and run a substantial load on a Postgres database. Should work just as well on Oracle if you change the test SQL from “Select 1″ to “select 1 from dual”

Install jmeter on our machine . On my mac, I did

  • brew install jmeter

You will need the Postgres driver. I used

New Index enhancement in Oracle 12c Part 2 – Partial indexes on partitioned tables


In the article, you will have a look at the partial indexes available since Oracle 12c. The partial indexes enable us to index only certain partitions of a partitioned able and avoid indexing of the other partitions of the same table. The partial indexes can be either global or local indexes.

I will illustrate with examples the use of partial indexes. First, I will create full indexes and after that I will create partial (more...)

Understanding the User’s Perspective

Recently I encountered what I thought was an interesting allegory in regard to software development and understanding the user experience.

My three year old approached me with her bottle of milk and requested more, insisting it was empty.

Exhibit A - One non-empty receptacle

I assessed what was presented to me:

  1. There was milk in the container
  2. The straw reached the current milk level
  3. The straw was not blocked (I didn't feel like milk. I (more...)

Which is the best career path: Oracle ADF or Java?

My answer on Quora to “Which is the best career path to choose, Oracle ADF, or Java?”

Concentrate on Oracle ADF. ADF skills are in high demand and pay better than pure Java skills.

Because Oracle ADF is a Java-based framework, you will need to learn some basic Java as you build you ADF skills. Once you land an ADF job, you will learn more Java as you work with ADF. This allows you (more...)

Oracle E-Business Suite Mobile and Web Services Security – What You Need To Know

Securing packaged software such as the Oracle E-Business Suite presents different challenges than securing bespoke custom software. Unlike custom software, both the structure of and the security vulnerabilities of the Oracle E-Business Suite are well known and documented, not only to users but also to threat actors.  To begin an attack, limited probing and/or reconnaissance is needed because threat actors know exactly what to target and what to expect.  This also makes the (more...)

IRs with Subscriptions that might not work

If you have an Interactive Report with the Subscription feature enabled, users can “subscribe” to the report, getting a daily email with the results of the report. Unfortunately, however, this feature doesn’t work as expected if it relies on session state – e.g. if the query uses bind variables based on page items to filter the records. In this case, the subscription will run the query with a default session state – Apex doesn’t (more...)

Can we trust the Exadata ISO image?

Recently i had to reimage a couple of Exadata compute nodes for different reasons like an almost simultaneous failure of 2 harddisks in the compute node.

After the compute got back online with a fresh image and restoring settings like cellip.ora, DNS, NTP and cellinit.ora we got to the point where we need to reinstall the Oracle components, this clusters has an Grid Infrastructure, and (more...)

Links for 2017-02-22 [del.icio.us]

Links for 2017-02-22 [del.icio.us]

Run dynamic action from report row and pass multiple variables

Execute a "Dynamic Action" by clicking on a button/link inside a report row is mostly handled by some triggering HTML class.

It actually works in 95% of all cases. But it is not the best way to do it. It is much more effective to execute the "Dynamic Action" with a custom event.

Reason is simple: You don't need to allocate unnecessary elements via a class by jQuery. You execute the "Dynamic Action" in the (more...)

Pushing artifacts to GitHub from Oracle Developer Cloud Service

We came across a use case where the Oracle Developer Cloud Service was being used to build a zip archive and then the requirement was to upload this zip file on GitHub from Developer Cloud Service for a public usage. This blog will help you understand how to push an artifact generated on Developer Cloud to GitHub repository.




Prerequisites for GitHub:

  1. To have a valid GitHub account.
  2. Have created a GitHub repository, (more...)

Who should create Oracle ADF skins?

My answer on Quora to “Who should create Oracle ADF skins: Developers or designers”

If you are on the latest ADF version (12.2.1.x.x), you have access to the web-based Theme Editor. In this case, your designer should use this user-friendly tool to create the skin. It has some limitations, but the designer is best placed to work around these.

In earlier ADF versions, a CSS developer is needed to develop the (more...)

Flipkart and the Executive Revolving Door

he contrast could not have been more striking, or poignant.
2017 began on a sombre note for Flipkart, when it announced on the 9th of Jan that Kalyan Krishnamurthy had been named CEO, and its current CEO Binny Bansal would become group CEO. It was the Indian e-commerce startup's third CEO in less than one year.
Three days later, on the 12th, Amazon let it be known via a press release that it (more...)

APEX 5.1 New Features – neuer Termin

APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !

Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit (more...)

Building a Hyper-V Environment for SharePoint / Cyberinc Entitlements Server Prototype – Part 3

In my previous post, I covered the installation of SQL Server 2016 SP1 for our Hyper-V environment. After that is completed, we are ready to install SharePoint Server 2016. That’s what I’ll be covering here. Firstly, you need to download a copy of the software. At the time of writing this post, SharePoint Server 2016 is available from Microsoft. That’s the version I’ve downloaded for installation on the VM.

Installing the Prerequisites

To start the (more...)

Spark based Microservice- Deployment Automation in the Oracle Cloud

Spark is a Java based framework supporting development of micro applications/services. This blog will give an understanding of deploying a simple Spark based REST service project on Oracle Application Container Cloud using Oracle Developer Cloud. This post will show the essential capabilities for Spark framework based projects management, build automation and streamlined deployment in the Oracle Cloud, using Developer Cloud Service and deploying to Application Container Cloud.


Tech Stack Usage

Eclipse: IDE for Spark (more...)

The Flash Insider: To POC or Not To POC?

Proof of Concept?

Guest Post

I’m excited announce another guest blog written by my good friend and funny-talking American cousin Nathan Fuzi. Like me, Nate comes from a database background but joined the all-flash storage revolution back in its infancy. Which means, like me, Nate how has a little tombstone on his résumé marked Violin Memory. But even though he has since moved up to working in THE CLOUD, Nate’s experience working for an AFA vendor is invaluable. Over six years, he worked (more...)

Long Parsing and PGA limits

Recently I’ve seen not so smart optimizer behavior: one query took long time to parse, and ended with an error hitting PGA_AGGREGATE_LIMIT in few minutes; another query was just parsed for ages while using reasonable (under 2G :)) amount of PGA and still could hit PGA_AGGREGATE_LIMIT but after way more time – up to an hour.

Both cases were similar and involved queries which were accessing views; and those views’ code is generated by an (more...)

Oracle Database Result Cache Troubleshooting

I was troubleshooting an issue where the Oracle Database Result Cache did not get used when the RESULT_CACHE hint was specified inside a subquery. As the main query has a sysdate inside, the RESULT_CACHE Hint can not be specified for the main query, but only for the subquery.

SELECT SQ.*, sysdate FROM
(SELECT * FROM tableX, ....) SQ;

When using “/*+ RESULT_CACHE */ inside of Subquery, result cache was not (more...)

Optimising AWS for Oracle – Licenses

If you're keeping an eye on the Oracle license rules you'll know that you need to make sure that when you're designing in AWS you make the most of every CPU that has an Oracle license attached too it.

Here's our rundown of how to design and use AWS features to maximise those licenses.

  • Design for zero waste. In the past we might have Oracle nodes that didn't do very much. Those DR servers, or (more...)