Oracle Scratchpad

OC 1 Introduction

Addenda and Errata for Oracle Core Chapter 1 Introduction

Back to Index


p.2 Paragraph after the note: “The SCN will be incremented on other occasions …”, but I don’t give any examples of other occasions, except for a brief note on page 38; so here are a couple of examples:

If you make a number of changes to the same block at the same SCN (with no other possible transactions going on) then eventually Oracle will increase the SCN.

There is a single byte on each block that counts the number of changes made to the block at the current SCN; historically this meant that you could change the block 254 times before it was necessary for Oracle to increment the SCN and set the counter back to 1 (zero is a special value for this counter that marks the block as logically corrupt – ORA-01578). In recent versions of Oracle the SCN seems to change long before you get to 254 block changes.

The SCN also changes when an incoming distributed query or transaction has a lower SCN than the current instance – the two databases synchronise their SCNs to the higher value (at the start of any select, and at the end of any transaction). The same sort of thing happens with RAC instances, but there’s a constant cross-chat between instances – and a “broadcase on commit” feature that makes this behaviour almost invisible.



Back to Index


  1. Hi Jonathan,

    I need a good performance tunning book. Please suggest which can guide me.

    I am aware while working on practical issues it will be different , But I think it will be helpful to narrow down the performance.

    Sourabh Gupta

    Comment by Sourabh Gupta — August 27, 2013 @ 3:35 pm BST Aug 27,2013 | Reply

  2. Hi Jonathan ,

    you wrote on P3 the following
    “When the software is running under UNIX (or virtually any other operating system), a number of
    copies of the same oracle process are running in memory, and these copies share a large segment of

    could you please give examples and how the oracle process is running in memory?


    Comment by Samer — May 17, 2014 @ 10:43 pm BST May 17,2014 | Reply

  3. hi jonathan,

    on page 2 figure 1-1 paragraph 1 tells something about the types of files. the data files and redo log files. the figure 1-1 does not tells exactly or labels the objects about it. can you tell which one is the data file is it the arrow that points from the LGWR or DBWR and the redo log?


    Comment by Warren — March 21, 2019 @ 12:25 pm GMT Mar 21,2019 | Reply

RSS feed for comments on this post.

Comments and related questions are welcome.

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by