0 Compose end to end tracing, logging and monitoring with ECID set from WebLogic in Database (exposed in V$SESSION)
The title of this blog is unfashionably long – and really says it all. The ECID (Execution Context ID) that…
Browsing: Database
0 Security Features of Standard Edition (One) – Part 1
or A closer look on database hosts The last couple of years quite a few organizations had a difficult time…
0 Cloud Control Agent 12c managing many objects
An Oracle Enterprise Management Agent 12c that has to manage hundreds of objects needs extra tweaking. If not, it will…
0 SQL*Plus / SQL*Net Dead Connection Detection
Recently I came across the situation where I knew for a fact that my sessions to the database were dead…
0 Major take-aways from Oracle OpenWorld 2014 – some relevant conclusions
Oracle OpenWorld 2014 is over. Just under a week, full to the brim with information, events, people, energy, plans, hopes…
2 How to hide login data of sql-scripts on Windows
One of the often given advices on hardening a database is to run scripts without broadcasting your login data at…
1 Oracle Restart to autostart your oracle database, listener and services on linux.
Half a year ago, my colleague Remco wrote an article on auto starting the listener and the databases after a…
1 Using Oracle’s Edition-Based Redefinition to support multiple SOA Suite revisions with the database adapter
When using the Oracle SOA Suite for web service development, chances are that you are also using an Oracle database…
0 Winter edition of OTech Magazine has just been published – free yet rich, in-depth yet broad
In the past few hours, Douwe Pieter van den Bos released the second issue of OTech Magazine to the world.…
0 The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all…
0 OOW13 and JavaOne 13: Notes from a Conference – Part Two
In this article a second brain dump with observations from the Oracle OpenWorld and JavaOne conferences. These are fairly raw…
2 You consolidated your applications in one database, but now one application needs recovery…
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and…
0 OOW13: Sneak Preview of the Major Announcements?! In-Memory Database, PaaS (Database and Java) and M6 big memory machine
Recent press releases as well as the comment provided by Oracle’s top brass around the FY14 Q1 earning provide some…
0 Het Oracle OpenWorld Preview Evenement (5 september 2013) – 15 sprekers & sessies
Vanaf 22 september vindt in San Francisco de Oracle OpenWorld conferentie plaats: hét evenement waar Oracle haar productstrategie uit de…
0 Oracle Database SQL – Recursive Subquery to inspect events in football matches – find the MVP
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot…
3 Oracle Database 12c: Find most valuable player using MATCH_RECOGNIZE in SQL
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a…
0 Oracle Database 12c: Flashback Moving Forward
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up…
8 Oracle Database 12c: quickly create a virtual machine with OEL 6.4 and Oracle Database 12c (for dummies)
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than…
1 Oracle Database 12c: In-Database Archiving to deal with logically discarded records
When a record is no longer active – it is logically discarded – you may want to delete it. However,…
0 Oracle Database 12c: Pattern Matching through MATCH_RECOGNIZE in SQL
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical…