(Ben) In this article, I’ll explain what the Oracle LNNVL function does and show you some examples.
Tag: Oracle
Advanced Replication
(connormcdonald) Long before Streams, long before Goldengate, if you want to keep data between sites synchronised in some fashion, or even allow sites to independently update their data, there was the Advanced Replication facility in Oracle.
Startup trigger and wallet ‘quirk’
(Dbaharrison) Many of you out there will be using dataguard and i guess most of you will have some variation of the startup trigger below
Creating a RAC 12.1 Data Guard Physical Standby environment (1)
(Martin Bach) I have just realised that the number of posts about RAC 12c Release 1 on this blog is rather too small. And since I’m a great fan of RAC this has to change 🙂 In this mini-series I am going to share my notes about creating a Data Guard setup on my 2 node 12.1.0.2.161018 RAC primary + […]
In Memory Session State – Use Case
(Scott Wesley) Many moons ago Anton Nielson posted about the different kinds of session state in Oracle APEX.
Custom SQLFORMATs with SQLcl
(Jeff Smith) When I make jokes about copying and pasting code from StackOverflow or Github, I’m not really joking.
How to configure FLASHBACK in #Oracle
(Uwe Hesse) It’s easy to get confused by the various different forms of FLASHBACK possible with Oracle Databases. Let’s try to sort that out. I start with forms of FLASHBACK that work with little effort to the system and not much – if anything – to do for the DBA to enable it.
Renaming & Commenting Oracle Data Mining Models
(Brendan Tierney) As your company evolves with their data mining projects, the number of models produced and in use in production will increase dramatically.
Oracle LN Function with Examples
(Ben) In this article, I’ll explain what the Oracle LN function is, and show you some examples.
Force a Different Path with Automatic Plan Hints
(Jeff Smith) Are you smarter than the optimizer?
