Video : Real-Time Materialized Views

Today’s video is a quick demo of Real-Time Materialized Views,
introduced in Oracle Database 12c Release 2 (12.2).

This is based on information from the following articles.

The cameo for today’s video is Maria Colgan. 🙂

Cheers

Tim…


Video : Real-Time Materialized Views was first posted on February 18, 2019 at 11:09 am.
©2012 "The ORACLE-BASE Blog". Use (more...)

Another bug with lateral

Compare the results of the following query with the clause “fetch first 2 rows only”

with 
 t1(a) as (select * from table(odcinumberlist(1,3)))
,t2(a,b) as (select * from table(ku$_objnumpairlist(
                                 sys.ku$_objnumpair(1,1),
                                 sys.ku$_objnumpair(1,2),
                                 sys.ku$_objnumpair(1,3),
                                 sys.ku$_objnumpair(3,1),
                                 sys.ku$_objnumpair(3,2),
                                 sys.ku$_objnumpair(3,3)
                                 )))
,t(id) as (select * from table(odcinumberlist(1,2,3,4,5,6,7)))
select
  *
from t,
     lateral(select t1.a,t2.b
             from t1,t2 
             where t1.a = t2.a 
               and t1.a = t.id
             order by t2.b
             fetch first  (more...)

Lateral view decorrelation(VW_DCL) causes wrong results with rownum

Everyone knows that rownum in inline views blocks many query transformations, for example pushing/pulling predicates, scalar subquery unnesting, etc, and many people use it for such purposes as a workaround to avoid unwanted transformations(or even CBO bugs).

Obviously, the main reason of that is different calculation of rownum:

If we pull the predicate “column_value = 3” from the following query to higher level

select * 
from (select * from table(odcinumberlist(1,1,1,2,2,2,3,3,3)) order by 1)
where rownum  (more...)

Oracle 19C New Feature Availability

trump-exasperatedSince Oracle Open World 2018, Oracle have been trumpetting a few cool new features in the Oracle 19C database, the headline two for administrators being “Automatic Indexing” and “Real-Time Statistics“.

With the release of Oracle 19.2 on Exadata (on-premises – not yet on Cloud!) this week, we also got the documentation released which allow us to answer a very important question: on which platforms will we be able (more...)

Source Oracle Environment Easily

I have been patching a lot lately and wanted a fast and easy method to source Oracle environment.

The objective is to copy, paste from action plan vs having to selectively copy, edit, paste.

Example: . /media/patch/gi.env vs . oraenv — +ASM[n]

Started by creating gi.env which will be used to source GI for all RAC hosts.

You are probably thinking, isn’t it a PITA to have to edit and maintain all the gi.env (more...)

Video : Collation and Case-Insensitive Queries in Oracle Database

Today’s video is a run through the Collation functionality introduced in Oracle Database 12c Release 2 (12.2).

If videos aren’t your thing, you can find a lot more information about this subject in my article here.

The cameo in today’s video is Kim Berg Hansen. 🙂

Cheers

Tim…


Video : Collation and Case-Insensitive Queries in Oracle Database was first posted on February (more...)

Listening To Customers

The Oracle HCM Cloud team hosted their annual Customer Advisory Board meetings at Oracle HQ last week.  I've always enjoyed the CAB meetings because it's the one event where we reverse the flow of information:  customers tell us about how they use our products rather than us showing customers how to use those products.  I learned a few lessons in listening to our customers last week.

Customers today are more concerned with the pragmatic aspects (more...)

Updating Oracle Opatch with AWS Systems Manager Run Command at Scale

AWS Systems Manager (SSM) is a managed service by AWS, which is used to configure and manage EC2 instances, other AWS resources, and on-premise VMs/servers at scale. SSM frees you up from having ssh or bastion host access to the remote resources.


Pre-requisites of SSM:

The managed instances need to have SSM agent running.
The managed instances need to be assigned an IAM role with policy AmazonEC2RoleforSSM.
The managed insatnces need to have a meaningful (more...)

Making Scripts Work with IDCS Deployed PaaS

A while back I made some utilities I developed to help with managing the API Platform. At the time we didn’t have access to an IDCS based environment, so credentials worked using basic auth (I.e. user name and password). But with environments managed by IDCS tokens are used.

As a developer with a Java background I have to admit to liking Groovy over Python for scripting, not to mention for the API Platform groovy (more...)

OBUG Tech Days Belgium 2019 : Day 2

Day 2 started a little late for me and I missed the first block of speakers. Sorry Alex!

The first session of the day for me was Franck Pachot with “Microservices : Get rid of your DBA and send the DB into Burnout”. The session started with a rousing chorus of “Happy Birthday” for Franck. My bad summary of the session would be, pick the right tool and the right approach for the job. The (more...)

OBUG Tech Days Belgium 2019 : Day 1

The day started at my normal wake-up time. My flight wasn’t until 10:50, but I decided the leave for the airport really early to avoid traffic. It makes no difference to me if I’m at home on my laptop, in the airport on my laptop, or at work… 🙂

The only thing of note from the airport was me trying to scan through boarding security with my conference ticket, which of course failed, but they let (more...)

Oracle ASM and Thin Provisioning – How To Reclaim Space

It came to my attention last November that I had crossed the one year anniversary since my last post on flashdba.com. I was so surprised that I immediately decided to write a new post, which took another three months. There are reasons why I’m no longer posting technical blogs about databases and flash, but I’ll cover them in a later post. No, not that late – I hope.

In the meantime, I thought I’d (more...)

Oracle Developer Meetup – London Feb 19

Last night was the first Oracle Developer Meetup in London for 2019.  We were very fortunate to have Tomas Langer fly over to talk about the new micro container/framework being developed as an open source solution by Oracle.

Oracle Developer Meet-up - Tomas Langer presenting on Helidon

Tomas, opened by explaining the evolution of the micro-profile being championed by the Eclipse Foundation who are now the guardians of J2EE also known as Jakarta and how the J2EE and Micro-Profile standards compare (in simplistic (more...)

Oracle Linux hangs after “probing EDD” in Oracle Cloud

Just short note: If your imported Oracle Linux image hangs on boot in the Oracle cloud, just set GRUB_DISABLE_UUID=”true” in /etc/default/grub

OBUG Tech Days Belgium 2019

The BOUG Tech Days 2019 conference is happening on the 7th-8th February, which is Thursday and Friday this week. I see from the Twitter-verse that some people are already there and checking out the city.

I’ll be flying out on Thursday morning, and flying back Friday night, so it’s an overnight stay for me.

The list of speakers is pretty impressive, so it looks like it’s going to be a good one.

See you there!

(more...)

Video : Extended Data Types in Oracle Database 12c Onward

Today’s video is a quick run through the Extended Data Types functionality introduced in Oracle Database 12c Release 1. Why such an old subject? Well, it’s a prerequisite for something I was planning to do a video on, so I thought I better do this first. 🙂

For those that don’t like videos, you can find the same information and more here.

The cameo in (more...)

API Caching with the Oracle API Platform

We have been developing some advanced custom API policies for a client and in the process picked up on a few insights that didn’t even make into the API book. One of these policies is to provide an optimization around caching of API calls. The rest of this blog will talk about the tricks we have specifically applied to link an API Gateway to a caching mechanism and why.

Before I go into the details, (more...)

Upcoming Events- #SQLSatCle and @RMOUG_ORG #TD19

As I live in an RV and travel as part of my work and to attend events, travel has started to figure out that I often fly out of one location and fly back into another. This week will be no different.

Since we travel between cities on the weekend, its bound to happen that I leave for a SQL Saturday on a Friday in one city and arrive back in a different city on (more...)

Review: eBook: Saas for Dummies

As i wrote some days ago, Oracle provided this book as free download:


Here my review:

The book starts with the chapter "recognizing modern business challenges and opportunities". The author comes up with things like "business transformation starts with digital transformation" or "businesses will need to rethink every element of their business". It contains a typical opening for this topic.

The next chapter has the title "Empowering Business Managers with SaaS Solutions". The focus (more...)

VirtualBox 6.0.4

VirtualBox 6.0.4 has been released. Hot on the heels of 6.0.2 we got this new version lst night (UK time).

The downloads and changelog are in the usual places.

I’ve installed it on my Windows 10 laptop at work. I’ll do my personal Windows 10 laptop, old MBP and OL7 server when I get home, and post an update here to say how I got on.

Cheers

Tim…


VirtualBox 6.0. (more...)