Oracle Scratchpad

OC 1 Introduction

Addenda and Errata for Oracle Core Chapter 1 Introduction

Back to Index

Addenda

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.

Errata

Typos/Grammar/Style/Punctuation

Back to Index

2 Comments »

  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.

    Regards
    Sourabh Gupta

    Comment by Sourabh Gupta — August 27, 2013 @ 3:35 pm GMT 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
    memory.”

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

    thanks
    Sam

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


RSS feed for comments on this post.

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

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,430 other followers