While visiting a customer, we had a conversation about the correct way to stop users from writing to code tables. The customer described his ancient logic: when he wanted to move table to a read only state, he removed the write (insert/update/delete) permissions from all of his users. That was good enough for him for years – since he started using this method way back in Oracle 8. All was well, util this week he (more...)
In case you missed this webinar, here’s a 1.5h holiday video about how Gluent “turbocharges” your databases with the power of Hadoop – all this without rewriting your applications :-)
Also, you can already sign up for the next webinar here:
- GNW06 – Modernizing Enterprise Data Architecture with Gluent, Cloud and Hadoop
- January 17 @ 12:00pm-1:00pm CST
- Register here.
See you soon!
NB! If you want to move to the "New World" - offload (more...)
The only thing that remains constant is change. ~Heralitus
This often is more apparent in technology than anywhere else. Even with a group of Oracle evangelists and enthusiasts like the ACE program, which offers the opportunity for peers to recognize those that contribute to the community and help make it a better place.
I’ve [often quietly] assisted many around me to find their path into the ACE (more...)
BPM/SOA Human Task: Java code in jsp source files is not allowed in ojsp.next mode by Antonis Antoniou
Error: OracleJSP error: oracle.jsp.parse.JavaCodeException: Line # 14, oracle.jsp.parse.JspParseTagScriptlet@66e50889
Error: Java code in jsp source files is not allowed in ojsp.next mode
What was really strange to me was that I did not do anything different from what I used to do with previous versions.
After some research I found out (more...)
For those that don’t know, I came to reading Fiction rather late. In September of 2006, at the age of about 37 I decided to start reading. Up until that point I had pretty much avoided reading wherever possible for most of my life. I did what I had to for my degree, PhD and job, but I was a minimum effort reader. The first series of books I read was The Vampire Chronicles and I (more...)
Das erste stammt noch von der DOAG Konferenz 2015 und bezieht sich auf meinen damaligen Vortrag über die neuen Parallel Execution Features von Oracle 12c:
DOAG.tv Interview 2015
Das zweite ist von der diesjährigen DOAG Konferenz und bezieht sich auf meine Performance-Tests der Oracle Database Cloud und dem dazugehörigen Vortrag:
Recently in a discussion with colleague, on what entries do MLOG$ have, the following was agreed to :-
1. “I” for insert
2. “D” for delete
3. “D” + “I” for update.
Along with the above entries, you might notice “U” also. The “U” entry is for update. But then, on what condition do we get “U” and when do we get “D” and “I” entries.
I have used “EMP” table as master table in (more...)
I’ve been playing around with some more of the new JSON features in Oracle Database 12c Release 2 (12.2).
The first thing I tried was the new PL/SQL support for the JSON functions and conditions that were introduced for SQL in 12.1. That was all pretty obvious.
This is the Christmas edition and therefore rather compact! It’s 46th installment of my blog series around Stream Processing and Analytics.
As usual, find below the new blog articles, presentations, videos and software releases from last week:
News and Blog Posts
More often than not, you will want your processes to interact with other services or processes inside or outside your enterprise. Since integration options are rather typical in Oracle Process Cloud Service, this article will help you to apply best practices for creating and managing your connections in a sustainable fashion.
Process Cloud integration points
Let’s say you have modelled a process in Oracle Process Cloud Service (PCS) for a private home loan application. Chances (more...)
You should not worry, as per Shay Shmeltzer answer on OTN Forum - "We discovered an issue with the installer - we are working to fix this. Once we have the updated installer we'll update (more...)
When we add a new datafile to the primary environment of a dataguard setup, we need to add the datafile to the standby environment as well if we want the manged recover to continue working. We can do that manually if we want – but fortunately for us Oracle comes with a built in feature for automatically creating the file in the standby as well. All we need to do to set it up is (more...)
Enabling flashback on 18.104.22.168 database can take minutes and cause multiple database wait events degrading database performance.
On a quite busy system, during the low peak hours, I tried to enable flashback on 22.214.171.124.6 version database and multiple sessions waited on
1. buffer exterminate
2. enq: SQ – contention
3. latch: cbc contention
4. SGA: allocation forcing component growth
PRAKANAN_DBA@:1> show parameter sga_target NAME TYPE VALUE ------------------------------ ----------- (more...)
How can you create custom XPath functions in Oracle Service Bus 12c? And how can you use these in both XSLT and XQuery? Let’s find it out. I like to show you how they’re different in behaviour.
The context of my post comes from one of my projects, where we were migrating quite some (stateless) services from the SOA (BPEL) platform to Service Bus. Since our clients were already ‘virtualized’ to our clients (i.e. (more...)
So it’s Christmas morning here in the UK.
I’m pretty tired after last night’s events. The night before I heard something in my ceiling, which I was hoping was mice, but suspected might be this.
Last night I put a humane trap in the attic and in the evening heard some noise as the trap was rocking back and forth. I took it outside to a hedge about 100 yards away, as suggested by a couple (more...)