Search

OakieTags

more tags

Who's online

There are currently 0 users and 24 guests online.

Recent comments

Affiliations

Home

ORA-600 [2252]

SCN – What, why, and how?

Submitted by rshamsud on Thu, 2012-01-19 21:48

In this blog entry, we will explore the wonderful world of SCNs and how Oracle database uses SCN internally. We will also explore few new bugs and clarify few misconceptions about SCN itself.

What is SCN?

SCN (System Change Number) is a primary mechanism to maintain data consistency in Oracle database. SCN is used primarily in the following areas, of course, this is not a complete list: