This is an ongoing post about any mistakes or misunderstandings in the book.

In 11g running utlrp.sql automatically runs it in parallel if you pass no parameters to it. A technical reviewer caught that misstep in the book during the review process but I didn’t quite understand what he was trying to tell me. Dope slap!

See in Chapter 8 – Upgrading, in two different places. Not sure where I got this information, it first showed up in a presentation I had done. I just repeated the BAD info in my book. I am guessing that I quoted someone directly who happened to say the wrong thing. What I should have done was doublecheck that the syntax was correct.

WRONG DBMS_STATS.SET_GLOBAL_PREFS(‘PENDING’,'TRUE’);

CORRECT … exec DBMS_STATS.SET_GLOBAL_PREFS (‘PUBLISH’,'FALSE’);

WRONG: ORCL11>execute DBMS_STATS.SET_GLOBAL_PREFS(‘PENDING’,'FALSE’);

CORECT: ORCL11>execute DBMS_STATS.SET_GLOBAL_PREFS(‘PUBLISH’,'TRUE’);

The RDBMS controls pending statistics publishing at the database level by the following initialization parameter: optimizer_use_pending_statistics

Another mistake found by a reader: Suneet. Thanks so much.

“I bought your book recently. Overall I liked the book especially since you are giving MOS DOC ID which is quite useful and at times difficult to find. I had similar bad experiences with Oracle 9i Logical Standby and I agree that standby’s got stable only in 10.2.0.4/5.

I think on page 173 there is an errata.

ORIG_STANDBY>SHUTDOWN IMMEDIATE;
ORIG_STANDBY>STARTUP MOUNT;
ORIG_STANDBY>Flashback DATABASE TO SCN <STANDBY_BECAME_PRIMARY_SCN>;
ORIG_STANDBY>ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
ORIG_STANDBY>SHUTDOWN IMMEDIATE;
ORIG_STANDBY>STARTUP MOUNT;
ORIG_STANDBY>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT CONTROLFILE DISCONNECT;

Should be

ORIG_PRIMARY >SHUTDOWN IMMEDIATE;
ORIG_PRIMARY >STARTUP MOUNT;
ORIG_PRIMARY >Flashback DATABASE TO SCN <STANDBY_BECAME_PRIMARY_SCN>;
ORIG_PRIMARY >ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
NEW_STANDBY>SHUTDOWN IMMEDIATE;
NEW_STANDBY>STARTUP MOUNT;
NEW_STANDBY>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Thanks and Regards!
______________________________________________
Suneet Kapoor”

This error came from a tweet….April, there is a mistake on the page 51 of your new book, the task says …files greater/less than 2GB, but the command do 200M