KeePass 2.30

KeePass 2.30 was released about a week ago. This passed me by as I was distracted with the whole tour thing. :)

The downloads and changelog are in the usual placed.

You can read how I use KeePass (Windows & Linux) and KeePassX2 (Mac) here.



KeePass 2.30 was first posted on August 17, 2015 at 7:50 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. (more...)

Loading file data … easier than you think

So a request comes in from a colleague…

”Hi Connor.  I’ve created this new table, and I need to populate it with some data.  I’ve got it in Excel – can you help me load it”

Now, at this point, my heart normally sinks, because whilst the Oracle tools to load flat file data are comprehensive, I know that I now have to

  • go find out the table definition, column names and data (more...)

Hyper-Extended Oracle Performance Monitor 7.0 Beta

August 16, 2015 Three and a half years ago I offered the Hyper-Extended Oracle Performance 6.0 Beta for download – that Beta version expired a year later.  This program has been somewhat of a pet project for the last 13 years (almost 10 years at the time of the previous Beta offering), so I was […]

My Glamorous Life : Just so you don’t misunderstand…

If you’ve subscribed to my YouTube channel, you will have noticed me posting some videos with the title “My Glamorous Life : …“.

I had several distinct plans for this trip:

  • Do the OTN tour itself. That is of course the real reason we are doing this!
  • Collect some video footage of the conferences so I could produce little montage for each, just to help me remember it. I’ll do that when (more...)

Lima to Amsterdam

I left the hotel a little late, but the airport was literally across the road, so it was no big deal. Having a business class ticket meant I checked in immediately (+1) and even had time to hit the lounge (+2). High class swanky time, and without needing to be signed in for once. :)

Boarding the flight was pretty straight forward. Once again, the business class ticket gives priority boarding (+3), without me having to (more...)

Parallel Projection

A recent case at a client reminded me of something that isn't really new but not so well known - Oracle by default performs evaluation at the latest possible point in the execution plan.So if you happen to have expressions in the projection of a simple SQL statement that runs parallel it might be counter-intuitive that by default Oracle won't evaluate the projection in the Parallel Slaves but in the Query Coordinator - even (more...)

ORA-00600 [kqlidchg0] | ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Recently after upgrading the dev database to 12c, I ran utlrp to compile the invalid objects and it failed with the below error

SQL> @utlrp

SQL> SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual;

COMP_TIMESTAMP UTLRP_BGN  2015-06-30 03:50:27

  2     threads pls_integer := &&1;
  3  BEGIN
  4     utl_recomp.recomp_parallel(threads);
  5  END;
  6  /
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [],
[], [],  (more...)

Mr DISTINCT might not be your friend

Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure that you are not hiding just a larger issue. It actually might represent either incorrect use of SQL or incorrect assumptions from the data model.

Consider the following example

FROM   emp e, dept d
WHERE  e.ename = 'SMITH'
AND    e.deptno = d.deptno

The query is certainly valid, but (more...)

Move Table Partition between Tables

I was recently asked if we can move partition of one table into another? Basically a developers had truncated the partition and the team wanted to move the partition from one table to another.Both the table were structurally the same and had same data.

Here I will be showing how we can do that

1. Create a monthly partitioned table –

SQL> create table sales_part
    (product char(25),channel_id number,cust_id number,
    amount_sold number, time_id date)
    partition  (more...)

Log Buffer #436: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers the top blog posts of the week from the Oracle, SQL Server and MySQL arenas.


  • Momentum and activity regarding the Data Act is gathering steam, and off to a great start too. The Data Act directs the Office of Management and Budget (OMB) and the Department of the Treasury (Treasury) to establish government-wide financial reporting data standards by May 2015.
  • RMS has a number of async queues (more...)

OAM PS3 State-of-the-art

An attempt to run OAM 11G Release 2 PS3 on Oracle Linux 6.7, WLS 12C, RDBMS 12C. Install Linux Pretty straightforward. Used Oracle 6.7, as 7 is not certified. Create a 200MB /boot, and an LVM for /, both ext4. Install just the server. Deselect *all* options, just X system and X legacy support (the OUI needs it). Some 566 packages will get installed. Make sure it boots, and the network starts.

Friday Philosophy – Building for the Future

I started my Oracle working life as a builder – a Forms & Reports Builder (briefly on SQL*Forms V2.3 but thankfully within a month or two we moved up to SQL*Forms V3, SQL*reportwriter V1.1 and SQL*Menu 5 – who remembers SQL*Menu?). Why were we called Builders? I guess as you could get a long way with those tools by drawing screens, utilising the (pretty much new) RI in the underlying Oracle V7 (more...)



We have a number of updates to partitioned tables that are run from within pl/sql blocks which have either an execute immediate ‘alter session enable parallel dml’ or execute immediate ‘alter session force parallel dml’ in the same pl/sql block. It appears that the alter session is not having any effect as we are ending up with non-parallel plans. When the same queries are run outside pl/sql either in sqlplus or sqldeveloper sessions the (more...)

Migrating tablespaces across endian platforms

T 4 HP-UX IA (64-bit)   Big 13 Linux x86 64-bit   Little[/code]


Set the tablespace EXAMPLE read only


 alter tablespace example read only;

Tablespace altered.

select file_name from dba_data_files;



PL/SQL procedure successfully completed.

SELECT * FROM transport_set_violations;

no rows selected

Export the data using the keywords transport_tablespaces


expdp directory=data_pump_dir transport_tablespaces=example dumpfile=hpux.dmp logfile=hpux.log Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": /******** AS SYSDBA

Processing  (more...)

How to Remove an Exadata Server from OEM

Just like everything else in Enterprise Manager, an Exadata is a target and all of its components are targets.  All of these pieces can be removed through the 12c console.

Select Exadata from the bottom of the main Targets drop-down to display a list of Database Machines in your environment.  Highlight the row containing the subject machine and press the Big Red X to take you into the detail page.


The left panel shows you the (more...)

After startup trigger on RAC

Recently, a colleague of mine had some problems with pinning application procedures into the shared pool. His database was upgraded to RAC and he wanted to pin the application procedures and packages into shared pool upon the database startup.
The non-RAC version of the database was using a shell script, something like $ORACLE_HOME/local/scripts/ in the script that was starting DB when the system was booted
However, RAC starts the database automatically and no user (more...)

Applied July Patch Sets To Test Databases

I applied the current July patch sets to a 11.2 and a 12.1 test database.  Now I have a and a test database.  It is helpful to have test databases that are on the most current patch sets and releases.  If I see unexpected behavior on some other database I can try the same thing on the patched test databases to see if some (more...)

Installing the Oracle database in docker

This blogpost is about how to install and run the Oracle database in docker. Please mind this is not an officially supported virtualisation platform for the Oracle database. This is a proof of concept setup.

Linux host setup.
In my setup, I used a linux host, freshly installed with Oracle Linux 6.7, which is going to be used as docker server. Please mind you need to leave diskspace (or a disk device) unused for (more...)

dbms_redefinition houskeeping

dbms_redefinition actually is a nifty, but powerful little toolkit that let’s you change table-definitions without actually locking the table in such a manner that it would prevent regular operations from being interrupted.

You can read loads about it in the Oracle documentation or in the wealthy library by Mr. Tim Hall.

housekeepingOne thing I noticed, and which I want to share here has lots to do with the house keeping that is automatically done by (more...)

Why users or sysadmin login is taking time

If users or sysadmin user trying to login in r12, Its taking time for login process. The problem most probably its is something to do with profile option. Please make sure the debug and diagnostics is not enable at the user level for sysadmin user or users.