SP2-0618 and SP2-0611 An user reported errors SP2-0618 and SP2-0611 when he tried to enable AUTOTRACE at his session-time. SQL> show user USER is "HR"… Read More »How to Resolve SP2-0618 and SP2-0611
Importing Stuck at STATISTICS When I imported data via a network link, I found it stuck at STATISTICS. ... Import: Release 12.1.0.2.0 - Production on… Read More »How to Resolve impdp STATISTICS Stuck
How to Use DBMS_STATS.GATHER_DATABASE_STATS ? We usually gather statistics of the database globally after data migration. The following examples are very practical in post-migration phase.… Read More »Gather Database Statistics Examples