Using guaranteed restore points to navigate through time
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 …
Category: Databases
Oracle licenses needed while monitoring your (non-)Oracle environment with OEM
October 20, 2015
Architecture, Database, Databases, Enterprise Manager, IT, Licensing, Platform Technology
3 Comments
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 …
12c DBCA skips database-patching activities
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 …
A Short Note on Pesky CSSCAN Results Before a Characterset Change
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 …
Security Features of Standard Edition (One) – Part 2
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 …
How-to bulk delete ( or archive ) as fast as possible, using minimal undo, redo and temp
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, …
How-to set the current database schema of an application using a global context
March 9, 2015
Database, Databases, DBA Oracle, Frontend technology, Languages, Oracle, Oracle 12, Oracle Application Development Framework, PL/SQL, SQL, Technology
No Comments
![How-to set the current database schema of an application using a global context]({"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"} "How-to set the current database schema of an application using a global context")
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 …
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 and internal costs where a main focal point was …
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 not start, or it will die soon, leaving you …
RAC and preventing Active Data Guard: My experiences
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 …
SQL*Plus / SQL*Net Dead Connection Detection
November 28, 2014
Architecture, Database, Databases, DBA Oracle, Oracle, Oracle WebLogic Server, Platform Technology, Virtualization and Oracle VM
No Comments
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 …
When to use the Oracle Database In-Memory option?
September 22, 2014
Architecture, Data Warehousing & BI, Databases, Digtial Innovation, Oracle 12
1 Comment
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 …
Sometimes the cause of a TNS error is ….
A couple of months ago one of my customers had a failed data ware house report. There was a ORA-12592 (TNS) error message generated. I turned out not to …
How to make a time consistent export dump using the expdp datapump utility
In those old days when there was the exp utility we made a time consistent export dump by using the consistent=y parameter. But today, in fact a couple of …
SQL> Select * From Alert_XML_Errors;
August 29, 2014
Database, Databases, DBA Oracle, Development Tools, Oracle, Software Development, SQL
No Comments
Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying …
SQL> Select * From Alert_XML;
By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since …
Sqlnet tracing during nightly hours…
A TNS error at night… Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to …
Materialized views: fast refresh, complete refresh or recreate?
Have you ever wondered why it takes a century to completely refresh your materialized view? I did, so I did some testing. Recently I was asked to support a …
Cloud Control: How a Camel can make you cross a Data Guard Mountain
July 9, 2014
Cloud, Database, Databases, DBA Oracle, Enterprise Manager, Oracle, Platform Technology
No Comments
In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. …
How to add your Standby Cluster Database to Cloud Control
July 6, 2014
Cloud, Database, Databases, DBA Oracle, Enterprise Manager, Platform Technology
No Comments
The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider …
Spatial: license-incompliancy while using Oracle Locator ?
As you may know, the use of Oracle Locator is free of charge, while Spatial is an option in Oracle Enterprise Edition which have to be paid for. Spatial …
SQL based Charts – Scatterplot for x,y coordinate data sets (growth curve, euro/dollar ratio)
Today, against all priorities, I have resumed an old hobby: the creation of charts with nothing but SQL to work with. Several years back I created pure SQL Hi-Lo …
Fast delete of many files in LINUX and WINDOWS
One of my customers ( Oracle Database 11gR2 on LINUX ) never noticed the Oracle software LUN filling up until a “df -h” reported 97% used, wondered why, and …
Named credentials in OEM12c
In Oracle Enterprise Manager 12c (aka OEM) there is such a great facility called “Named Credentials”. This allows someone to create a pair of username/password which can be used …
PL/SQL vs SQL
There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL, do it in SQL. I came across some code …
Using Table Functions
Overview of table functions Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database …
Typical
After a presentation by Lucas Jellema I decided to try something with types in Oracle. One of the issues posed in this presentation was that the type cannot self-reference. …
Steven Feuerstein Master Class. Anti-Pattern PL/SQL Programming + 12c New PL/SQL Features, December 12 and 13 2013
12 and 13 December 2013 AMIS will host a two day masterclas with Oracle PL/SQL guru Steven Feuerstein. The Design Pattern movement reminds us that most of the code …
AMIS presenteert: twee-daagse masterclass PL/SQL 12c door Steven Feuerstein
Steven Feuerstein, dé PL/SQL autoriteit, komt op 12 en 13 december naar AMIS in Nieuwegein. Twee dagen lang verzorgt hij een masterclass waar u intensief door hem persoonlijk gecoached …
15 juli – Oracle Database 12c revealed
Afgelopen dinsdag is Oracle Database 12c beschikbaar gekomen, de nieuwste generatie van de Oracle database. AMIS biedt Oracle professionals de eerste mogelijkheid om de vernieuwingen in Oracle Database 12c …
ADF interaction with business service – an ongoing discussion
January 20, 2013
Databases, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
The ADF framework strongly suggests if not dictates a certain application architecture. Through ADF BC (Business Components) – the predominant business service implementation with ADF – applications will typically …
Book review: Oracle APEX Best Practices
Oracle APEX Best Practices explains how to build robust and secure APEX applications. The authors have a proven track record in the Oracle APEX world. The intended audience of …
AMIS Masterclass Advanced SQL – scherp je SQL skills in een pittige en praktijkgerichte dag – maandag 10 december
November 21, 2012
APEX, Database, Databases, Java, Oracle, Oracle Application Development Framework, PL/SQL
No Comments
Of je nu ‘klassieke’ Oracle applicaties ontwikkelt, met APEX bezig bent, een SOA landschap inricht of een Java/JEE (bijvoorbeeld ADF) applicatie bouwt: het fundament van veel van wat je …
Kom kennismaken met AMIS en doe mee met uitdagende projecten
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
OOW 2012: The Very Very Latest in Database Development (CON4792)
Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the …
Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML
September 12, 2012
AMIS, Database, Databases, Java, Oracle WebLogic Server, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java, XML
No Comments
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem …
Implementing Web Services backed by a Database PL/SQL API using the Oracle Service Bus
This article accompanies an article on the Architecture section of Oracle Technology Network (OTN): Implementing the Enterprise Service Bus Pattern to Expose Database Backed Services. It provides a detailed …
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
October 13, 2011
Announce / Events, Architecture, Big Data, Book reviews and Publications, Cloud, Database, Databases, DBA Oracle, Development Tools, IT, Oracle, Oracle E-Business Suite, PL/SQL, SOA, Software Development, Testing, Tools
No Comments
In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken …
Masterclass Advanced Oracle SQL – vrijdag 14 oktober 2011
Aanstaande vrijdag geef ik voor de derde keer de Masterclass Advanced Oracle SQL. Deze MC gaat over SQL – dat zal duidelijk zijn. We gaan de mogelijkheden van SQL …
Implementation of a moderately complex data constraint business rule using RuleGen 3.0
In a previous article, I have introduced RuleGen 3.0 – a 2nd generation business rule implementation framework for the Oracle Database: https://technology.amis.nl/blog/?p=12807. RuleGen provides a solid, structured, scalable framework …