July 2016

Skinny Banners and the Corporate Laptop

Many corporate laptops display in 1366 x 768 pixel resolution, as do many budget models purchased from discount stores. The low vertical display height triggers media queries in some Squarespace templates causing banner images to display in a slimmer format that normal. You may not want those slimmer banner images, and you can override the behavior with a bit of CSS. 

Note: The specific examples that follow apply to the Bedford template. The general technique however, should be valid for most templates that include banner images in their design. 

Recently I was contacted by a designer working on a Mac who had just learned that his clients were displeased at seeing skinny banner images from their Windows machines. Using my own site as an example, the designer saw images such as in Figure 1, whereas the clients saw much slimmer images such as in Figure 2.

LAG / LEAD quick tip

As most of us know, with LAG and LEAD or more generally, any analytic function that may extend “past” the boundary of window it is operating on, you can get null as a result.

Here’s a trivial example


SQL> create table t as
  2  select rownum x
  3  from dual
  4  connect by level <= 10;

Table created.

SQL>
SQL> select x, lag(x) over ( order by x ) as lag_Test
  2  from t;

         X   LAG_TEST
---------- ----------
         1           
         2          1
         3          2
         4          3
         5          4
         6          5
         7          6
         8          7
         9          8
        10          9

10 rows selected.

We get null for the first row, because we cannot lag “below” x=1 because there is no such value. That is of course trivially solved with an NVL, for example:

Direct mode operations on IOT’s

An AskTom contributor brought to my attention, that direct mode insert on index organized tables now appears possible in 12c.  We can see the difference by running a simple script in both v11 and v12

Push oracle audit data into Elasticsearch and analyze/visualize it with Kibana

Introduction

Auditing the oracle database may lead to a wide variety of information.

What about having all this information centralized? What about having the possibility to gather, format, search, analyze and visualize this information in near real time?

To achieve this, let’s use the ELK stack:

We’ll focus on the audit information coming from:

Friday Philosophy – Brexit & the Misplaced Blame Culture.

This is not going to be a rant about Brexit and how the selfish, stupid and simply fearful were led by a jingoistic & deceitful bunch of career politicians to show the worst side of the UK. Well, maybe a bit… It’s more about something that struck me about Brexit in respect of who is to “blame”. And there are aspects of this that are echoed in our own industry.

I feel that there is a strong element of “the chickens coming home to roost” with Bexit. By this, I mean things were done by our politicians and our media that unintentionally led to this fiasco – and a lot of those who are presently supposed to lead the UK, who are currently dismayed at the Brexit vote are, in fact, partially responsible.

Understanding CPU on AIX Power SMT Systems

This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. I’ve worked with databases running on AIX a number of times over the years now. Nevertheless, I got thrown for a loop this week.

TLDR: In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. The bottom line is twofold:

Understanding CPU on AIX Power SMT Systems

This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. I’ve worked with databases running on AIX a number of times over the years now. Nevertheless, I got thrown for a loop this week.

TLDR: In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. The bottom line is twofold:

Understanding CPU on AIX Power SMT Systems

This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. I’ve worked with databases running on AIX a number of times over the years now. Nevertheless, I got thrown for a loop this week.

TLDR: In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. The bottom line is twofold:

Believe it or Not: Converting an Inner Join to an Outer Join to improve performance

The cost-based optimizer tries to merge views whenever possible but sometimes we ma y want to override this behavior; that is, we may want the optimizer to push predicates into the view instead of merging the view into the main query. If the main query performs an inner join to the view, it becomes necessary to convert the inner join to an outer join if the database version is less than 12.1.0.2.(read more)