Errata

Oracle Essentials

Errata for Oracle Essentials

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
PDF Page 53
Table 2-1. Partial list of database components and their related data dictionary views

V$CPOOL_STAT

I should be V$CPOOL_STATS

 Surachart Opun  Sep 03, 2013 
PDF Page 63
4th paragraph

"The SYSTEM tablespace always contains the data dictionary tables. Data dictionary
tables that are preceded by the V$ or GV$ prefixes are dynamic tables, which are continually
updated to reflect the current state of the Oracle Database. Static data dictionary
tables can have a prefix such as DBA_, ALL_, or USER_ to indicate the scope of the
objects listed in the table."

In my opinion, It should be "Dynamic Performance Views that are preceded by the V$ or GV$" and "Data Dictionary Views can have a prefix such as DBA_, ALL_, or USER_" not data dictionary tables and static data dictionary tables.

 Cuong Nguyen  Feb 17, 2014 
PDF Page 213
3rd paragraph from the bottom (ie. pt. 4)

This looks to me as a potential serious mistake (please double check with professional Oracle expert).

"The server writes the old image of the data to the redo buffers, and then writes the changes to an undo segment [..]"

I suppose it should be other way around. Old image is written to UNDO segment, and then changes -- both in data block and in UNDO segment (ie. their change vectors) -- along with transaction table are written to redo buffer.

 PaichiWo  Jun 07, 2015