Home » RDBMS Server » Backup & Recovery » What is the System Change Number?
What is the System Change Number? [message #241567] Wed, 30 May 2007 01:10 Go to next message
Messages: 666
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all and especially Michel!

I am wondering about the SCN - System Change Number. I know it is a sequence number whenever Database is being opened reset log. But I don't know where is the view V$ to see it, and when does SCN occur?

Would you like to guide me, and send me a document (or link) to learn about it carefully?

Thank you very much!
Re: What is the System Change Number? [message #241580 is a reply to message #241567] Wed, 30 May 2007 01:40 Go to previous message
Michel Cadot
Messages: 63931
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select current_scn from v$database;

1 row selected.

SQL> select dbms_flashback.get_system_change_number from dual;

1 row selected.

Many things can change SCN mostly user and internal commits.
As you can see in my example, I was alone on my db but the time I typed the 2 statements SCN increased of 1.
SCN is just a tick (like clock tick) to measure db internal time (like clock measures "real" time).

Previous Topic: IMP-00017: following statement failed with ORACLE error 2237
Next Topic: export user's structure
Goto Forum:

Current Time: Thu Oct 27 05:53:29 CDT 2016

Total time taken to generate the page: 0.11056 seconds