Underground Book Revisions, Reviews and Interviews

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

Online reviews of the book –

Alejandro Vargas

http://blogs.oracle.com/AlejandroVargas/2010/05/oracle_database_11g_undergroun.html

Lewis Cunningham – best review because he gives both pros and cons.

http://it.toolbox.com/blogs/oracle-guide/oracle-11g-underground-advice-for-database-administrators-review-38794

Aman Sharma

http://blog.aristadba.com/?p=131

Short interview on Tech Target

http://searchoracle.techtarget.com/news/2240018735/New-Oracle-Database-11g-book-offers-underground-tips

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s