Oracle Errors
Oracle 12c Datapump Segmentation Error

Oracle 12c Datapump Segmentation Error

I was recently working for a client who has just done a new install of the Oracle 12c database. While attempting to import data into their new database using datapump, they got a segmentation error as follows: oracle:/u01/app/oracle/product/12.1.0/dbhome_1/bin: impdp Import: Release 12.1.0.2.0 – Production on Fri May 15 10:17:32 2015 Copyright (c) 1982, 2014, Oracle 

Continue Reading…

Excessive Deletes From SMON_SCN_TIME Error

Excessive Deletes From SMON_SCN_TIME

I got a support call late last Friday afternoon (why do most call seem to come on a Friday afternoon just before you finish for the weekend?) about bad performance on one of our applications we host for a customer.

When I logged into the server and took a look at what it was doing, the CPU was getting hammered by the Oracle SMON process.