nVision Performance Tuning: Table of Contents

This post is an index for a series of blog posts that discuss how to get good performance from nVision as used in General Ledger reporting.  As the posts become available links will be updated in this post.
  • Introduction
  • nVision Performance Options
  • Indexing of Ledger, Budget and Summary Ledger Tables
  • Partitioning of Ledger, Budget and Summary Ledger Tables
  • Additional Oracle Instrumentation for nVision
  • Logging Selector Usage
  • Analysis of Tree Usage  with the Selector Log
  • Interval (more...)

ODC Appreciation Day: EMP #ThanksODC

Here is my very short entry for the Oracle Developer Community Appreciation Day 2017.

Very often I use the good ol' EMP table to demonstrate even the latest features of SQL and PL/SQL.
Everybody seems to know the EMP table, and some even know some of the content off the top of their head (yes, I'm guilty of that too). Whenever I need to write a hierarchical query and am not really sure what which (more...)

ODC Appreciation Day : Timeline component in Oracle JET, Data Visualization Cloud, APEX and ADF DVT: #ThanksODC

Here is my entry for the Oracle Developer Community ODC Appreciation Day (#ThanksODC).

It is quite hard to make a choice for a feature to write about. So many to talk about. And almost every day another favorite of the month. Sliding time windows. The Oracle Developer Community – well, that is us. All developers working with Oracle technology, sharing experiences and ideas, helping each other with inspiration and solutions to challenges, making each other (more...)

ODC Appreciation Day – Plan Statistics

If you don’t know that by now, OTN (Oracle Technology Netowrk) has changed its name to ODC (Oracle Developer Community), so OTN Appreciation Day becomes ODC Appreciation Day. This initiative started by Tim Hall from ORACLE_BASE last year. In this day, every blogger writes something to thank Oracle for. You can read about the concept … Continue reading ODC Appreciation Day – Plan Statistics

IoT Cloud Brewed Beer @ OOW: The Details

Now that Oracle Open World has come and gone, I have some time to go into the details of how this project was conceived and realized, and how it faired at OOW.  Let’s start with that last one.

I guess to no one’s surprise, the actual booth with (free!) beer was a crowdpleaser;  we blew through the stock of 12 kegs with time to spare.

Lines for IoT Cloud Brewed Beer

Lines for IoT Cloud Brewed Beer

That’s roughly (more...)

2017OOW – UKOUG & User Groups in General


UKOUG was represented at #OOW17 in force. As explained in a recent news article we were sending both Paul Fitton our President and James Jeynes our Executive Director.

Both Paul and  James were new to #OOW17 and I am sure they were surprised at the sheer scale of it all. They both had very full agendas and I know they wanted to see lots of sessions between meetings, but I haven't caught up with them (more...)

Overloaded Indexes (for ODC Appreciation Day)

ODC Appreciation Day is an idea that Tim Hall (aka Oracle-Base) came up with, to show out appreciation for the Oracle Technology Program (OTN)/Oracle Developer Community.

Fig 1 This is an efficient range scan

I want to show my support but rather than mention an Oracle “feature” I particularly like I’d like to mention a “trick” that I (and many others) often employ to help performance. That trick is Overloaded Indexes.

We can all (more...)

LEAP#348 D Latch with NAND gates

The gated D latch is perhaps the fundamental 1-bit memory unit in active digital logic.

Gated_D_latch_symbol

There are a few ways of constructing a D latch, here I’m using a NAND gate SR latch as the base, which is convenient as all it requires is a single 74LS00 (quad two-input NAND).

As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Oracle Developer Community Appreciation Day

OK, time for some controversy Smile

My ODC appreciation post is about support.oracle.com

Now I’m sure there will people in the community just itching to lose their proverbial about how they lost years of their lives waiting on the support response or similar complaint, and since I work for Oracle, they will be just as keen to jump on the bandwagon and claim that I’m just shilling for the company I work for.

But (more...)

Disrupt or Die- Learning From History

As I continue to dig into the legacy we’re impacted by in technology, I had the opportunity to read Disrupt or Die, the new book from Delphix and Avamar founder, Jedidiah Yueh.  I was first concerned that the content wouldn’t be that interesting to someone from the deep technical like myself…

To be honest, I ended up quite captivated by the history lessons surrounding some of our most successful  technology companies, like Facebook, (more...)

Thanks ODC, Oracle WIT Edition #ThanksODC

Just in case you wondered, if you do a search for #ThanksODC and leave the “C” off, you get a lot of stuff on the boy band, One Direction…. You can thank me later for that warning….

The sheer amount of thank you posts for Oracle Development Community Appreciation Day, (#ThanksODC) and the historical hashtag for reference, #ThanksOTN are impressive, but I waited a day on mine so I could continue the support for the (more...)

Thanks, ODC (Oracle Developer Community)!

I owe a lot of thanks to the ODC - which stands for Oracle Developer Community.  What is ODC?  You may remember it as OTN, or the Oracle Technology Network.  Same people, different name.  Why they changed it I can't say.  People just liked it better that way... (love that song)

In any case, what am I thankful for?  A lot.  To start, the tools that I use day in and day out: SQL Developer, (more...)

Exadata x7 with Cell Storage 18c

Continuing to raise the bar for enterprise-class database platforms, today Oracle announced the next-generation Oracle Exadata X7 with significant hardware and software enhancements in overall performance, storage capacity, network bandwidth, and automation. Exadata X7 delivers extreme performance and reliability to run the largest, most business-critical database workloads.

Oracle Exadata is an Engineered System designed to be the ideal platform for all database workloads.  It features scale-out, database optimized compute, InfiniBand networking, and smart storage (more...)

Using Adobe InDesign with Oracle Content Experience Cloud

5 Things I learned about Using Adobe Design Products with Oracle Content Experience Cloud

As a designer I am always a little leery when someone tells me they are going to ask me to change my process.  To my great relief moving from my desktop and WebCenter to Content Experience Cloud is not only easy but will make me faster.  Here are the first 5 things I have learned since making the switch.

ODC Appreciation Day: Mike Hichwa’s team #ThanksODC

I don't know Oracle's internal organization, but I get the impression that people like Joel Kallman, Jeff Smith and Kris Rice work for or with Mike Hichwa. By naming him, I get to show appreciation for a bunch of technologies, and for the people behind them.

ODC Appreciation Day : Visual Builder Cloud Service


Yep, it's cloud, but it lets me extend cloud apps and initially that was a no-no. It is also low code, so you don't need to be technical, so why wouldn't I like it?

Well I wish they would keep the name, it was called Application Builder Cloud Services and that meant it was ABCS and I wrote about it, lots.

First Thoughts

After #OOW16

Article in UKOUG Oracle Scene 64

I've presented on it (more...)

ODC Appreciation Day: Oracle GitHub Docker Images and Oracle Container Registry

It's time again for the ODC Appreciation Day (formerly known as OTN Appreciation Day) driven by Tim Hall.

My personal favorite this year are the Oracle GitHub Docker Images and the Oracle Container Registry.

The Oracle GitHub Docker Images (https://github.com/oracle/docker-images) are the "Community Version" provided by Oracle. So in order to use them you will need to download upfront the required Installation Software from OTN or Oracle Software Delivery Cloud.

Under the (more...)

ODC Appreciation Day: Collections in SQL

Here’s my contribution to the ODC Appreciation Day.

Overview

Last week I had the privilege to participate in the EOUC Database ACES Share Their Favorite Database Things session at Oracle OpenWorld, so I think that the best topic to write about, as part of the ODC Appreciation Day, is the one I talked about in this session.
My 5-minute presentation was about Collections in SQL.

Collections are very useful in PL/SQL development. This is (more...)

ODC Appreciation Day 2017 – The Oracle BI Server

It’s that time of year again. After last year’s OTN Appreciation Day this year there is another ODC Appreciation Day (“since Oracle Technology Network (OTN) has now been renamed to Oracle Developer Community (ODC) there is a name change for the event this year, but the idea is the same.”) powered by Tim Hall. Last year I decided to … Continue reading "ODC Appreciation Day 2017 – The Oracle BI Server"

ODC Appreciation Day: OBIEE’s Time Hierarchies

After last year successful OTN Appreciation Day, it's time again to show our love for a particular feature in any Oracle's tool we use in our work. You may have noted a name change with OTN now becoming ODC: Oracle Developer Community.

What

The feature I want to speak about is OBIEE's Time Hierarchies.
For anybody in the BI business the time dimension(s) are the essence of the intelligence bit: being able to analyze (more...)