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.
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>Flashback DATABASE TO SCN <STANDBY_BECAME_PRIMARY_SCN>;
ORIG_STANDBY>ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
ORIG_STANDBY>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT CONTROLFILE DISCONNECT;
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>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Thanks and Regards!
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
Online reviews of the book –
Lewis Cunningham – best review because he gives both pros and cons.
Short interview on Tech Target