Posts tagged oracle 12c
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up of a mechanism that has been at the core of the Oracle Database from very early on: the ability to have concurrent sessions and transactions and allow transaction rollback and long running queries unaffected by transactions completed after the start of the query are all based on the same mechanism as flashback.
Flashback was great for demos and it was great for administrators. Developers however could not to very much with it. At least not until Oracle Database 11g when the Flashback Data Archive was introduced that provided fine grained control over which tables should have flashback data associated with it and which would not. At the time, the FDA was part of the Advanced Compression Database Option on top of the Enterprise Edition. So:great feature but for the happy few. In addition, there still were two main limitations with Flashback: history starts only at the day when the FDA is created. Nothing from before that day would be available. It’s a bit like the butterfly that does not have any of the memories of the caterpillar. The second limitation: Flashback did not record More >
Oracle Database 12c: quickly create a virtual machine with OEL 6.4 and Oracle Database 12c (for dummies)3
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than about command line. I have always been a little scared of system administration and non-wizard (next-next-finish) based installations. I am not proud of it. I have other skills and interests. I know how to drive my car but I cannot do engine maintenance. Something like that. Now Oracle has released Oracle Database 12c. And the only way for me to run it today is to install it on Linux. So I have a big impetus to finally get started. First with the creation of a Virtual Machine (VirtualBox) with Oracle Enterprise Linux inside (I wrote about my baby steps in this article http://technology.amis.nl/2013/06/29/how-to-create-a-virtual-box-vm-with-oracle-enterprise-linux-inside-a-dummy-guide/) and next with the installation of the Oracle Database 12c in that machine.
This article describes how I went from a clean Oracle Enterprise Linux 6.4 environment in a VirtualBox VM to a VM with additional hard disk, volume group and logical volume with the Oracle Database 12c up and running. The steps are: (more…)
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 in actie te zien.
Op maandag 15 juli organiseert AMIS het gratis seminar “Oracle database 12c revealed”. De AMIS specialisten die meer dan een jaar bètatesten hebben uitgevoerd laten zien wat er nieuw is en hoe we dat de komende jaren gaan inzetten.
Het programma: 16:30 – 17:00 Ontvangst 17:00 – 18:00 Oracle Database 12c: een overzicht 18.00 – 18.45 Een bezoek aan de beroemde AMIS frietkar 19.00 – 20.30 Parallelsessies met live demo’s: Nieuwe features in SQL en PL/SQL voor ontwikkelaars Nieuwe features voor database-administrators en -architecten 20:30 Borrel in het AMIS café
We hebben ruimte voor 80 mensen. Als er meer interesse is, dan openen we een wachtlijst. Schrijf je daarom snel hier in.
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one row in the result set to be calculated using the values in other rows. This allowed to look forward (lag) and back (lead) in result sets as well as calculate aggregates across partitions in every direction. Analytical Functions have helped to produce quite advanced analyses of data using very elegant, compact and surprisingly well performing queries.
With Oracle Database 12c, our SQL just got a little better equipped to perform analysis. The MATCH_RECOGNIZE operator has been introduced – one you may know if you have ever dabbled in CQL, the Continuous Query Language that is at the heart of several complex event processors. This operator goes beyond Analytical Functions in its capabilities to analyze a data set. The comparisons MATCH_RECOGNIZE allows us to make between rows in order to decide whether or not to produce a result are more advanced (and sometimes more fuzzy) than the straightforward comparison operators available with analytical functions. That sounds a little cryptic. Let’s look at More >
A small enhancement, but what a golden nugget! At least that’s what I think.
It is now possible in Oracle 12c to export data via a view. I my realm, Oracle XMLDB, that can be an interesting feature to export stored XML content in a relational format and import it, for example, in a relational table/environment. Let me show you how.
Lets create an XMLTYPE table and insert some XML into it: (more…)
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a small overview (sneak peek) into this great new tool for, for example, database performance tuning, hereby some pictures to create some appetite. I created some have load on my database, to make it a bit more interesting…Main Menu
The main menu has a section for “Configuration”, “Storage”, “Security” and “Performance” (more…)