Welcome to alphaora
Be persistent in what you do !
Latest from the Blog
Brief view on OWI ORACLE WAIT EVENTS part 1
Types of wait events: foreground Background Idle Non Idle RESPONSE TIME = SERVICE TIME + WAIT TIME or CPU TIME + QUEUE TIME CPU used for normal work (CPU_W) = CPU used when call started – parse time CPU – recursive CPU usage In 11g, below are the list of wait events which i used … Continue reading Brief view on OWI ORACLE WAIT EVENTS part 1
VSSWRITER service stopped
WHAT: VSSwriter is one of the services on windows used specifically for writing backup and recovery information in the form of snapshots and create volume based and component based shadow copies If oracle database reside on windows OS,then oracle VSS writer enables all types of backup like log,copy,full,incremental differential and cumulative All the options used … Continue reading VSSWRITER service stopped
ORA-12838: cannot read/modify an object after modifying it in parallel
Cause: The error occur when multiple session try to load data on the same table with direct path load operation + parallel Workaround: There are no constraints on the table where data load happen so constraints error were skipped and ora 12838 is thrown.Four sessions were connected to same database and all sessions perform insert … Continue reading ORA-12838: cannot read/modify an object after modifying it in parallel
