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…

Oracle Interview Questions And Answers For DBA

Oracle Interview Questions And Answers

Whether you’re just starting out on your Oracle DBA career or you’re an experienced DBA looking to switch jobs, you’re going to have to face interviews where you’ll be asked technical DBA questions as well as the usual “Tell us about yourself” type interview questions. List Of Oracle DBA Interview Questions And Answers To help 

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.