SCN at particular time (Oracle database)

Asked By 7060 points N/A Posted on -
qa-featured

Hi,

Please can anybody tell me that how we can get SCN at a particular time of a  database.?

Please advice.

SHARE
Best Answer by Sharath Reddy
Answered By 0 points N/A #82589

SCN at particular time (Oracle database)

qa-featured

System Change Number also known as SCN is an increasing number.  It is an Oracle's clock, whenever a transaction is committed, it incremented.

 However it is not possible to know the System Change Number that corresponds to the same transaction because the SCN is committed after the transaction.

 I guess the best thing that you can do is get or grab the SCN immediately after you commit.  In addition to that, a commit does not write data files and it does not update or control files.  Moreover, flashblack can never recall any uncommitted work even you own.

I Hope this helps.

Best Answer
Best Answer
Answered By 564735 points N/A #82590

SCN at particular time (Oracle database)

qa-featured

In database, SCN stands for System Change Number. It is the chief means of maintaining data regularity or consistency in Oracle database. Here are some of the areas where you can use SCN:

  • There is an SCN version in every redo record in the redo header. This also means that redo records may contain non-unique SCN version.
  • Each data block contains block SCN and the block SCN is known also as block version.​
  • SCN is used as well in read consistency. Each query made in the database contains query environment that contains SCN at the beginning of the query.
  • Each commit generates an SCN which is known as commit SCN. It marks the limit of the transaction.

An SCN is composed of 2 components, the Base and the Wrap.

The Wrap component is a 16-bit number while the Base component is 32-bit.

Answered By 0 points N/A #82591

SCN at particular time (Oracle database)

qa-featured

Hello Techyv experts, as always your advise is genius and it goes without saying. So thanks, to both of you especially to Sharath for giving excellent performing answers. He is providing some areas in how to use and access SCN easily. Indeed, I am a complete layman about the areas where I can use SCN. After studying your free and easy comments I have achieved my desired information which I have mentioned in my question. Thanks from the core of my heart guys again as well also grateful to Techyv.com for giving space to post this.

Login/Register to Answer

Related Questions