Archive

2026  2

January  2

Oracle Spatial Studio - First session

January 31, 2026 · 4 min · Øyvind Isene

Oracle Spatial Studio - Installation

January 30, 2026 · 5 min · Øyvind Isene

2025  5

December  2

UUID v7 in Oracle Database

December 22, 2025 · 4 min · Øyvind Isene

Moving Oracle Mobile Authenticator to a new phone

December 13, 2025 · 2 min · Øyvind Isene

November  1

OML4Py 2.1 on Linux

November 15, 2025 · 4 min · Øyvind Isene

October  1

UUIDs in Oracle Database

October 15, 2025 · 10 min · Øyvind Isene

February  1

104 million places from Foursquare in Oracle

February 27, 2025 · 7 min · Øyvind Isene

2024  11

December  1

External embedding in Oracle 23ai

December 19, 2024 · 11 min · Øyvind Isene

October  1

Flashback Time Travel

October 16, 2024 · 6 min · Øyvind Isene

September  1

Extend the boot device on OCI compute VM with Oracle Linux 9

September 14, 2024 · 3 min · Øyvind Isene

August  1

Practical Guide to Load Large CSV Files to Oracle

August 21, 2024 · 6 min · Øyvind Isene

May  4

Use OCI object storage from PL/SQL

May 30, 2024 · 6 min · Øyvind Isene

Oracle Database 23ai and Vector Search

May 15, 2024 · 11 min · Øyvind Isene

OML4Py Client on Ubuntu

May 13, 2024 · 3 min · Øyvind Isene

Stuffing files into OCI object storage

May 6, 2024 · 11 min · Øyvind Isene

April  3

ORA-01835

April 17, 2024 · 2 min · Øyvind Isene

ORA-01950

April 8, 2024 · 2 min · Øyvind Isene

First Journey with SelectAI

April 3, 2024 · 8 min · Øyvind Isene

2023  8

October  2

Your Own Oracle Database Lab in 1-2-3

October 11, 2023 · 7 min · Øyvind Isene

Moving ORDS from PDB to CDB

October 4, 2023 · 3 min · Øyvind Isene

April  1

Adding an SRID to Spatial

April 19, 2023 · 1 min · Øyvind Isene

March  1

REST: Don’t Let Them Wait

March 8, 2023 · 2 min · Øyvind Isene

February  4

ORA-01821

February 21, 2023 · 1 min · Øyvind Isene

Dataguard: Switchover vs Failover

February 16, 2023 · 4 min · Øyvind Isene

Primary Key as Generated Identity

February 9, 2023 · 3 min · Øyvind Isene

Is your SYSAUX tablespace way too large?

February 4, 2023 · 2 min · Øyvind Isene

2022  7

November  3

ORDS, APEX, and Social Sign-In

November 24, 2022 · 1 min · Øyvind Isene

Show CGI Environment in APEX

November 23, 2022 · 1 min · Øyvind Isene

ORA-20294

November 2, 2022 · 3 min · Øyvind Isene

October  2

Error ‘Server key did not validate’ in SQL Developer

October 25, 2022 · 1 min · Øyvind Isene

The Richness of Oracle Database Instrumentation

October 11, 2022 · 3 min · Øyvind Isene

August  1

ORA-30926 and MERGE

August 20, 2022 · 1 min · Øyvind Isene

April  1

Table with one row

April 5, 2022 · 2 min · Øyvind Isene

2021  3

October  1

APEX for Administrators

October 11, 2021 · 4 min · Øyvind Isene

March  1

UTL_HTTP from Oracle Autonomous Database

March 4, 2021 · 1 min · Øyvind Isene

February  1

Alter Pluggable Database Enesi Open;

February 13, 2021 · 1 min · Øyvind Isene

2020  1

December  1

Reboot

December 30, 2020 · 3 min · Øyvind Isene

2019  5

October  1

OGB Appreciation Day 2019: A Special part of the Oracle Community

October 10, 2019 · 3 min · Øyvind Isene

July  1

KSQL server failed to start after upgrade

July 11, 2019 · 1 min · Øyvind Isene

May  1

Presentation at Riga Dev Days 2019

May 28, 2019 · 1 min · Øyvind Isene

February  1

Presentation at OBUG 2019

February 2, 2019 · 1 min · Øyvind Isene

January  1

Import Large Excel Files with SQL Developer

January 10, 2019 · 1 min · Øyvind Isene

2018  3

September  1

Presentation at POUG 2018

September 7, 2018 · 1 min · Øyvind Isene

April  1

Converting Epoch Time to Date with a Virtual Column

April 15, 2018 · 2 min · Øyvind Isene

February  1

Oracle 12c and SSL

February 24, 2018 · 3 min · Øyvind Isene

2017  13

October  1

ODC Appreciation Day: SQL

October 10, 2017 · 3 min · Øyvind Isene

September  2

ORA-01861

September 30, 2017 · 1 min · Øyvind Isene

Docker for Mac - Increase Swap

September 30, 2017 · 3 min · Øyvind Isene

July  1

Slow SQL From Monitoring Software

July 15, 2017 · 2 min · Øyvind Isene

June  3

Flashback Tables

June 26, 2017 · 2 min · Øyvind Isene

Invisible Tables

June 18, 2017 · 1 min · Øyvind Isene

You should speak at UKOUG Tech17

June 4, 2017 · 3 min · Øyvind Isene

May  2

Normalizing Data Sets

May 27, 2017 · 7 min · Øyvind Isene

Hi there!

May 27, 2017 · 1 min · Øyvind Isene

March  2

Too Easy for a Post: Install Oracle 12.2 with Vagrant

March 26, 2017 · 2 min · Øyvind Isene

Adding Examples to a Docker Container with Oracle database 12.2

March 5, 2017 · 2 min · Øyvind Isene

February  2

Splitting a String into Elements

February 20, 2017 · 2 min · Øyvind Isene

ORA-1722 and Regular Expressions

February 19, 2017 · 1 min · Øyvind Isene

2016  10

November  1

Delete Cascade with Recursive PL/SQL

November 30, 2016 · 1 min · Øyvind Isene

October  4

Displaying Spatial Data in SQL Developer

October 23, 2016 · 3 min · Øyvind Isene

Importing GPX files to Oracle database, part 2

October 16, 2016 · 3 min · Øyvind Isene

OTN Appreciation Day: A database that is reliable

October 11, 2016 · 2 min · Øyvind Isene

Importing GPX files to Oracle database, part 1

October 2, 2016 · 5 min · Øyvind Isene

September  1

Oracle Open World 2016 Afterthoughts

September 30, 2016 · 2 min · Øyvind Isene

July  1

24 Basic Tips on Using SQL Developer

July 21, 2016 · 5 min · Øyvind Isene

May  1

Open Session Error when connecting to Hive from SQL Developer

May 23, 2016 · 2 min · Øyvind Isene

April  1

Undo old mistakes with online table redefinition

April 19, 2016 · 4 min · Øyvind Isene

February  1

SQL Developer and SSH for DBAs

February 17, 2016 · 2 min · Øyvind Isene

2015  12

December  1

JRuby in SQL Developer Data Modeler on Mac

December 29, 2015 · 2 min · Øyvind Isene

November  2

ORA-01105

November 23, 2015 · 1 min · Øyvind Isene

My take away from OOW15

November 8, 2015 · 2 min · Øyvind Isene

October  1

OUGN16 - Call for paper

October 30, 2015 · 1 min · Øyvind Isene

September  2

Who is your hero in the Oracle community?

September 28, 2015 · 2 min · Øyvind Isene

Function to let user B see all tables of user A

September 27, 2015 · 1 min · Øyvind Isene

July  2

Gather statistics on spatial index

July 27, 2015 · 1 min · Øyvind Isene

Orphan Processes in the database

July 5, 2015 · 1 min · Øyvind Isene

May  1

ORA-00942

May 16, 2015 · 3 min · Øyvind Isene

March  2

Search and history in SQL Developer

March 4, 2015 · 1 min · Øyvind Isene

DBMS_INDEX_UTL

March 2, 2015 · 1 min · Øyvind Isene

January  1

To a junior DBA

January 31, 2015 · 6 min · Øyvind Isene

2014  16

December  1

Why was my abstract (not) accepted?

December 20, 2014 · 5 min · Øyvind Isene

November  1

Use Domains in SQL Developer Data Modeler

November 10, 2014 · 2 min · Øyvind Isene

October  4

Restore XE database from an AWS instance

October 24, 2014 · 2 min · Øyvind Isene

Oracle VM: Templates and Assemblies

October 22, 2014 · 2 min · Øyvind Isene

Oracle database XE and APEX on Amazon Web Services

October 18, 2014 · 5 min · Øyvind Isene

Include roles and synonyms in DataPump export

October 8, 2014 · 1 min · Øyvind Isene

September  1

OOW 2014

September 24, 2014 · 2 min · Øyvind Isene

August  2

Revoke privileges from PUBLIC may cause ORA-600

August 27, 2014 · 2 min · Øyvind Isene

Correlation between restore time and used space in a datafile

August 24, 2014 · 2 min · Øyvind Isene

July  4

DBMS_LDAP and ORA-12703

July 23, 2014 · 1 min · Øyvind Isene

Connecting to a guest console in Oracle VM

July 7, 2014 · 1 min · Øyvind Isene

Importing ISOs to Oracle VM using OVM Manager

July 4, 2014 · 1 min · Øyvind Isene

Real Application Testing - some notes

July 2, 2014 · 11 min · Øyvind Isene

June  1

Some thoughts from last PoC

June 22, 2014 · 4 min · Øyvind Isene

March  1

42 Reasons to join me at #OUGN14

March 28, 2014 · 6 min · Øyvind Isene

January  1

Kurs med Cary Millsap i Oslo dagen før #OUGN14

January 18, 2014 · 1 min · Øyvind Isene

2013  10

September  2

Upcoming conferences

September 20, 2013 · 1 min · Øyvind Isene

Finding corrupt XML files on Linux

September 15, 2013 · 2 min · Øyvind Isene

July  1

Corrupt database blocks III

July 7, 2013 · 11 min · Øyvind Isene

May  1

Download from OTN slow? Check DNS

May 21, 2013 · 2 min · Øyvind Isene

April  3

OUGN Spring Seminar 2013

April 24, 2013 · 3 min · Øyvind Isene

Removing obsolete parameters from spfile

April 14, 2013 · 1 min · Øyvind Isene

Corrupt database blocks II

April 7, 2013 · 2 min · Øyvind Isene

March  1

Corrupt database blocks I

March 31, 2013 · 2 min · Øyvind Isene

February  1

Throw out the garbage

February 28, 2013 · 2 min · Øyvind Isene

January  1

Flashback database fails with read-only tablespace

January 11, 2013 · 2 min · Øyvind Isene

2012  13

December  1

Pro Oracle Database 11g RAC on Linux

December 31, 2012 · 3 min · Øyvind Isene

September  3

Oracle Open World - lucky me

September 28, 2012 · 2 min · Øyvind Isene

VirtualBox 4.2 released

September 15, 2012 · 1 min · Øyvind Isene

Easier installation of Oracle on Linux

September 15, 2012 · 2 min · Øyvind Isene

August  1

Oracle load testing - part 3 Hammerora results

August 20, 2012 · 4 min · Øyvind Isene

June  1

Oracle load testing - part 2 ORION results

June 6, 2012 · 3 min · Øyvind Isene

May  1

Oracle load testing - part 1

May 28, 2012 · 5 min · Øyvind Isene

April  2

Analyze your social networks with ThinkUp

April 5, 2012 · 6 min · Øyvind Isene

Extract SQL from trace file with Perl

April 1, 2012 · 1 min · Øyvind Isene

March  4

OUGN 2012 Day 2 - Wrap up

March 25, 2012 · 4 min · Øyvind Isene

OUGN 2012 Day 1 - At sea

March 23, 2012 · 2 min · Øyvind Isene

OUGN 2012 Day 0 - The Martins

March 21, 2012 · 2 min · Øyvind Isene

OUGN 2012 Day -1

March 20, 2012 · 2 min · Øyvind Isene

2011  15

December  2

EXP-00003

December 29, 2011 · 2 min · Øyvind Isene

Wordfeud and regular expression in SQL

December 28, 2011 · 2 min · Øyvind Isene

November  1

Two free profilers for 10046 trace files

November 30, 2011 · 4 min · Øyvind Isene

October  6

OOW 2011 Day 5

October 7, 2011 · 3 min · Øyvind Isene

OOW 2011 Day 4 and Blogger’s meetup

October 7, 2011 · 2 min · Øyvind Isene

OOW 2011 Day 3

October 5, 2011 · 2 min · Øyvind Isene

OOW 2011 Day 2

October 4, 2011 · 3 min · Øyvind Isene

OOW 2011 Day 1

October 3, 2011 · 1 min · Øyvind Isene

OOW 2011 Day 0

October 3, 2011 · 1 min · Øyvind Isene

September  1

Going to San Francisco…

September 29, 2011 · 1 min · Øyvind Isene

July  2

Rebuild Oracle Text indexes for Portal

July 13, 2011 · 3 min · Øyvind Isene

ORA-32012

July 6, 2011 · 3 min · Øyvind Isene

June  1

Hidden updates - another reason to trace

June 3, 2011 · 2 min · Øyvind Isene

May  2

VirtualBox on Fedora 15

May 30, 2011 · 1 min · Øyvind Isene

Today

May 29, 2011 · 1 min · Øyvind Isene

2010  10

November  2

Removing orphan DataPump jobs and filtering included tables with a query

November 20, 2010 · 2 min · Øyvind Isene

Slow performance with TDE and CHAR data type on 10.2.0.5

November 16, 2010 · 3 min · Øyvind Isene

October  2

A few notes on Oracle VM

October 20, 2010 · 4 min · Øyvind Isene

Permission denied when adding ASM disk

October 10, 2010 · 3 min · Øyvind Isene

June  1

Error when using 11g export client on a 10g database

June 29, 2010 · 1 min · Øyvind Isene

May  1

Someone trying to outperform Oracle’s cache

May 8, 2010 · 1 min · Øyvind Isene

March  2

Collatz conjecture in PL/SQL

March 27, 2010 · 1 min · Øyvind Isene

Using trace to find wallet location

March 6, 2010 · 2 min · Øyvind Isene

January  2

Database triggers are evil

January 29, 2010 · 1 min · Øyvind Isene

Changing character set in database

January 25, 2010 · 3 min · Øyvind Isene

2009  5

November  1

RMAN Convert database and ORA-7445

November 9, 2009 · 1 min · Øyvind Isene

October  1

Manually add a host target to Grid Control

October 11, 2009 · 1 min · Øyvind Isene

June  1

AIX and large pages

June 2, 2009 · 1 min · Øyvind Isene

March  1

Passed the OCP exam

March 8, 2009 · 4 min · Øyvind Isene

February  1

New job

February 12, 2009 · 1 min · Øyvind Isene

2008  11

October  1

Side effect

October 26, 2008 · 2 min · Øyvind Isene

August  1

Connection Manager and ORA-12529

August 27, 2008 · 2 min · Øyvind Isene

July  1

Multi-column function based index

July 15, 2008 · 2 min · Øyvind Isene

June  1

Table partitioning to improve stats

June 30, 2008 · 2 min · Øyvind Isene

May  3

Another great tool: SQL Developer

May 25, 2008 · 2 min · Øyvind Isene

Praise for Oracle BI Publisher

May 13, 2008 · 3 min · Øyvind Isene

ORA-16047

May 5, 2008 · 1 min · Øyvind Isene

April  4

Create a standby database with RMAN

April 29, 2008 · 3 min · Øyvind Isene

Understanding a legacy database

April 20, 2008 · 4 min · Øyvind Isene

Data Guard and forced logging

April 14, 2008 · 3 min · Øyvind Isene

First post…

April 13, 2008 · 1 min · Øyvind Isene