Lots of news coming out of Applications UX lately, so thought I’d share it here. Over at Misha’s (@mishavaughan) Voice of User Experience blog, you can read about Simplified UI for Oracle Human Capital Management Cloud and Simplified UI for Oracle Sales Cloud. Both versions went live in September when Oracle Cloud Applications, Release 7 was […]
Category Archives: Uncategorized
Here’s an example I saw a few months ago of the confusion caused by NULL. As the owner of the problem put it: the first query, run from SQL*Plus for testing purposes, takes no time to complete; but when “put into a pl/sql cursor” (as shown in the second query) it takes ages to complete. […]
I found out yesterday that we have an Oracle license audit in January, so I spent yesterday having a look at everything we have to check what features we are using… Our licensing situation is a little different to anywhere I’ve worked before, in that they are based on the number of Full Time Employees […]
Oracle License Audit was first posted on December 11, 2013 at 10:14 am.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
How not to write subqueries: If there had been any opportunity for the optimizer to do something clever with the NOT IN, you’ve just made sure it can’t happen. On top of that you may find that you don’t get the right results – consider the following cut-n-paste: Sometimes people simply forget that you can […]
It’s easy to move on if you accept a lie, without critical thinking.It’s easy to toss away love if you accept the hysteria that is around you.It is easy to destroy that which you loved by accepting the imaginings of those who say that have your best in…
Alchemists are best known for their (completely fictional and entirely ridiculous, but that’s besides the point) amazing ability to turn lead into gold. Let’s face it, there’s a lot of lead in the Oracle world. Bugs, angry developers, metrics that can seem to elude human understanding…but I digress. The question is, what can an alchemist [...]
Thats a really frequently asked question. Oozie is a workflow manager and scheduler. Most companies already have a workflow schedulers – Activebatch, Autosys, UC4, HP Orchestration. These workflow schedulers run jobs on all their existing databases – Oracle, Netezza, MySQL. Why does Hadoop need its own special workflow scheduler? As usual, it depends. In general, […]
Here’s another of my “draft” notes that needs some exapansion and, most importantly, proof. I have a fact table with a “status id” column that shows a massive skew. Unfortunately I have a dimension table that holds the “status code”, so (in theory, at least) I have to do a join from the statuses table […]
Here’s an offering in my “drafts for someone else to finish” suite of postings; it’s one I’ve been meaning to retest and publish for quite some time. It’s a possible answer to a question that comes up occasionally on the OTN database forum: “How do I resynchronize two tables that are supposed to be copies […]
My goal was initially to concatenate all rows generated via the package DBMS_FEATURE_USAGE_REPORT in one big HTML (XML?) document instead of the by default generated multiple row output… So how can you achieve this (in Oracle 11.1 and onwards) without getting into varchar2() or other buffer limitations… SQL> SELECT output FROM TABLE(dbms_feature_usage_report.display_html); OUTPUT