ODTUG Webinar: APEX 5 Page Designer

I'll be presenting an online webinar for ODTUG not long after the Perth conference.

It will be the same session I did for AUSOUG back in July, which is lucky since it's 6am for us Perth locals. It's a close look at the Oracle APEX 5 Page Designer, and what it means to you as an APEX developer.

Check the webinar registration page for details on the abstract and help with the time zone (more...)

Oracle and the new road to User Experience; launch of Alta UI – Oracle OpenWorld 2014

One of the new announcements on OpenWorld 2014 is the generic Alta UI. The Oracle product teams have worked hard to apply this new UI to all their products. This new interface theme is the result of Oracles efforts towards a more usable and comprehensible User Experience by the Oracle Usability Labs.

The deliverables of the Oracle Usability Labs are applied to all new products. This is a major change in the UX strategy of Oracle. (more...)

Website Outage Warning : 26 Oct 2014 20:00-00:00 GMT

DiagnosticsJust a quick note to say the website will be out of action this evening for 3-4 hours.

There have been a couple of random failures recently. With nothing in the logs to work with, I figured I’d try testing the hardware. Yesterday I tested the disks and they came back OK. Tonight it’s the turn of the memory. The plan is for the site to go down about 20:00 UK Time (GMT) and be (more...)

Getting Started with Impala Interactive SQL for Apache Hadoop by John Russell; O’Reilly Media

Impala is open source and a query engine that runs on Apache Hadoop. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time. If you are looking for a book getting start with it - Getting Started with Impala Interactive SQL for Apache Hadoop by John Russell (@max_webster). Assist readers to write, tune, and port SQL queries and other (more...)

Dead Code Kills

Your applications contain 20-30% dead code that is never executed. Not just commented-out code that programmers have left in “just in case”, but routines never called, branches never executed and screens never displayed.

The cost of software maintenance depends on the size of the code base, but systems with dead code are more expensive to maintain. This is because every time a developer comes across a dead piece of code, he becomes unsure: “I wonder (more...)

Dead Code Kills

Your applications contain 20-30% dead code that is never executed. Not just commented-out code that programmers have left in “just in case”, but routines never called, branches never executed and screens never displayed.

The cost of software maintenance depends on the size of the code base, but systems with dead code are more expensive to maintain. This is because every time a developer comes across a dead piece of code, he becomes unsure: “I wonder (more...)

Using JVM Diagnostics (JVMD) to help tune production JVMs

Using JVM Diagnostics (JVMD) to help tune production JVMs

Contributing Author: Shiraz Kanga, Consulting Member of Technical Staff, Oracle

Tuning a production JVM involves more than merely adding more RAM to it via the -Xmx parameter. It depends upon an understanding of how your application truly behaves in a production environment. Most JVM tuning is done by developers with a simulated load in their Development or QA environment. This is unlikely to (more...)

Recap of yesterday’s Arizona Oracle User Group (AZORA) meeting

Yesterday was the first meeting of the newly restarted Arizona Oracle User Group, AZORA.  It was a good first meeting to kick off what I hope will turn into an active club.

We met in the Tempe Public Library in a large downstairs room with a projector screen and plenty of seating with tables so it was easy to take notes.  We also had snacks.  I got a Paradise Bakery chocolate chip (more...)

Minimising Parse Time in Application Engine with ReUseStatement

This article explains how to determine the overhead of using literal values rather than bind variables in SQL submitted by PeopleSoft Application Engine programs. Using a combination of PeopleSoft Application Engine Batch Timings and Oracle Active Session History (ASH), it is possible to determine where it is most effective to change to alter this behaviour by setting the ReUse attribute.

ReUse Statement Flag

I originally wrote about the Performance Benefits of ReUseStatement in Application Engine (more...)

Glorious Data Visualizations for Your Friday

If you’ve read here for more than a hot minute, you’ll know that I love me some data visualization.

This love affair dates back to when Paul (@ppedrazzi) pointed me to Hans Rosling’s (@hansrosling) first TED talk. I’m sure Hans has inspired an enormous city of people by now, judging by the 8 million plus views his TED talk has garnered. Sure, those aren’t unique view, but even so.

There’s an interesting (more...)

APEX Tabular Forms Deep Dive at #ORCLAPEX NYC Meetup

Ever heard of APEX$ROW_NUM, APEX$ROW_SELECTOR and APEX$ROW_STATUS? Did you know you can reference tabular form columns using bind variable syntax in your page processes? Are you familiar with the execution scope of tabular form proecesses for modified vs submitted rows? Ever struggled using apex_application.g_fxx arrays with checkboxes? And do you really need to use the apex_item APIs? In APEX 4.0, 4.1 and 4.2 we've introduced lots of new tabular form features, (more...)

OCP 12C – Resource Manager and Performance Enhancements

Use Resource Manager for a CDB and a PDB Managing Resources between PDBs The Resource Manager uses Shares ans Utilization limit to manage resources allocated to PDBs. The more “Shares” you allocate to a PDB, the more resource it will have. Shares are allocated through DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE. One directive can only concern one PDB and you can’t [...]

The post OCP 12C – Resource Manager and Performance Enhancements appeared first on Oracle DBA Scripts and (more...)

Download Oracle VirtualBox VM with Database version 12.1.0.2

Somehow missed the announcement that the Oracle Development team refreshed (9/26/2014) the VirtualBox Oracle Database…

Oracle recognizes Cedar Consulting for Expertise in Oracle HCM Cloud

Oracle HCM Cloud Specialisation (white bkgnd - small)We are delighted to announce that Cedar Consulting has achieved OPN Specialized status for Oracle HCM Cloud.

To achieve this a number of our consultants had to pass a set of exams on Oracle HCM Cloud and as a business we had to have a certain amount of clients. This means that we can proudly display this logo on relevant collateral.

Graham, one of Cedar’s Directors, said:Graham (normal)

“This Specialized status, which follows extensive investment in our Oracle (more...)

Oracle ACE Program: Follow Up

I just wanted to write something as a follow up to my recent and provocatively titled Oracle ACE = Oracle’s Bitch? post. Obviously, that subject has been preying on my mind a little… I said before, it is hard to be objective about yourself, so maybe some aspects of the “being an Oracle ACE changes you” debate may be true. It would be wrong of me to deny that outright, but I think there are some (more...)

Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Last week Oracle released a Statement of Direction (SOD) for Oracle Business Intelligence Analytics (OBIA). The message from Oracle to their Customers is clear; Move away from OBIA 7.9.6.x and move to OBIA 11g, either in the Cloud or On Premise. Let us have a look what the actual message is. Find below a picture would find in a…Read more Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Trip Report: OpenSlava 2014

I had the pleasure to attend OpenSlava conference in Bratislava last week. It is a one day event which is comparably new and launched last year. This year it grew even bigger and even expanded to another area at the Faculty of Electrical Engineering and Information Technologies (FEI STU) of Bratislava. And as there are no registration fees for the conference, it is a great chance to catch up with a lot of interesting speakers.

Bratislava is (more...)

PeopleTools 8.54 Feature: ExcelToCI Errors and Warnings Worksheet

Some years ago, I wrote this post on ExcelToCI limitations. One of the limitations I've found annoying in the past was the need to move the mouse over each Warning or Error result cell. It was not just annoying, it actually didn't allow the users to easily work on the different error types and analyze useful information such as the most common error messages, how many rows would go through if they solved a particular (more...)

Ordina Open Wereld 2014

Werelds grootste IT conferentie, Oracle OpenWorld/JavaOne conferentie in San Francisco is voorbij. Meerdere Ordina mensen…

Postcard from Oracle OpenWorld 2014: The Oracle FS1 Flash Array

OOW14

A couple of weeks ago I wrote a post about my trip to Oracle OpenWorld 2014 and the surprise announcement of the Oracle FS1 Flash Array. I posted it on the Violin Memory corporate website here:

http://www.violin-memory.com/blog/postcard-oracle-openworld-2014-the-oracle-fs1-flash-array/

Follow the link to find out whether I thought it was the most amazing product in the history of storage, or simply a rehashed Pillar Axiom hybrid array with some SSDs and a ton of marketing.


(more...)