Category: Database
Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it. So here’s the story.. For one of our customers …
Oracle NoSQL Database is an interesting option to consider when you want a schemaless, fast, scale-able database which can provide relaxed (eventual) consistency. Oracle provides a Node.js driver for …
Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a …
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database …
Oracle introduced the ODA X6-2S and ODA X6-2M. And no, they are not the successor of the quite popular ODA X5-2, which we installed and configured quite a number …
Views in the Oracle database have several uses. You can use them to provide a view of data in different tables as a single object to query. You can …
In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In the previous two Blogs I have described the tools …
My Oracle Public Cloud DBaaS instance did not respond. On closer investigation, it turned out to be down. Mounting the database ended with an ORA-3113 End of Communication Channel. …
Some months ago I worked on a project where we thought it would be a good idea to use multiple guaranteed restore points to be able to navigate through …
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In this Blog I will describe how to create migration …
In this Blog I will explore the possibilities to apply Continuous Delivery (CD) for the Oracle database. What is Continuous Delivery? The introduction on Wikipedia Continuous Delivery says: “Continuous …
Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate ORAchk, the healthcheck tool for databases, RAC and Engineered …
JDBC URLs used in JDBC database connections in IDEs like JDeveloper and in JDBC Data Source definitions in Java EE servers such as WebLogic Server will typically use the …
After a database instance is provisioned in the DBaaS cloud service, it is not automatically accessible from services outside the identity domain. Various processes and applications running as part …
In this article I will tell you how to get up and running with the Oracle Database as a Service Cloud offering. How in 30 minutes of your own …
One of the cool stories of Oracle OpenWorld and JavaOne 2015 is the story of MySQL, in particular of release 5.7 of MySQL. For me, working primarily with Oracle …
This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around Data Management. It discusses on premises products such as Oracle Database …
With Oracle Enterprise Manager you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server. You are also able to exchange notifications …
Thanks to colleague Patrick Roozen I learned that there’s a tiny little flaw in Oracle databases 12c patch procedures when using DBUA (upgrade) and DBCA (create custom database) when …
Time has always been an important dimension for data in any database with topics like when was data created, when are records valid, how did records evolve over time, …
A client of mine was busy correcting one of his development streets and therefore the NLS charactersets of about 10 11.2.0.4 EE databases had to be changed. Most of …
Suppose your organization wants to enforce a security policy on database password strength. The DBA’s have implemented a password strength verification function in PLSQL such as the oracle supplied …
or Some Musings on the Security Implications of Oracle Database Initialization Parameters Still following the steps of a database installation, this article will muse about some Initialization Parameters with …
This article is small and simple. It discusses how from PL/SQL an HTTP POST request can be made to a REST service. This particular service is exposed at http://localhost:9002/cinema …
Wouldn’t be nice to get regularly informed how (in)compliant you are with Oracle licenses in an easy – centralized – way, and therefore not have to worry about visits …
Deleting some rows or tens of millions of rows from an Oracle database should be treated in a completely different fashion. Though the delete itself is technically the same, …
As you may well know, Advanced Compression is an option you have to pay for when using it. But as a DBA you can’t always control the use of …
Last week I read this blogpost by Scott Wesley. In this post he describes that he uses a custom aggregate function to create large JSON-strings. And for that he …
Harry Dragstra
March 9, 2015
Database, Databases, DBA Oracle, Frontend technology, Languages, Oracle, Oracle 12, Oracle Application Development Framework, PL/SQL, SQL, Technology
Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending on a choice during or after login – which …
While writing an article on database session context for the OTech Magazine’s Spring issue, I tried out whether I can send a SQL statement from a database consumer such …
The title of this blog is unfashionably long – and really says it all. The ECID (Execution Context ID) that is used in Fusion Middleware to identify a conversation …
or A closer look on database hosts The last couple of years quite a few organizations had a difficult time and internal costs where a main focal point was …
On 21 January 2015, Oracle announced Exadata X5, the sixth revision of Oracle’s database management system (DBMS) engineered system. The entire Exadata configuration no longer needs to be licensed …
An Oracle Enterprise Management Agent 12c that has to manage hundreds of objects needs extra tweaking. If not, it will not start, or it will die soon, leaving you …
One of my pet peeves is people using GUI tools like Toad or SQL Developer while running release scripts on test, acceptation or production systems. Actually, pet peeves is …
When you happen to have a customer that want’s to use Data Guard on Oracle RAC without a license for Active Data Guard then you might want to read this …
Recently I came across the situation where I knew for a fact that my sessions to the database were dead because I pulled the power plug out of my application …
A few days ago, I presented a session at Oracle OpenWorld 2014 about the most useful features for application developers in Oracle Database 12c (12.1.0.1 and 12.1.0.2). The main …
Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few hundred lines. See for instance ORACLE-BASE, How to FTP …
The application and usage of the Oracle Database In-Memory has been described by Pom Bleeksma in this post. Oracle Database In-Memory can result in huge improvement in application query …
![One of the many nice new features in 12c database: code based access control]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "One of the many nice new features in 12c database: code based access control")
