Home » RDBMS Server » Server Administration » SCN Values
SCN Values [message #171735] Thu, 11 May 2006 05:29 Go to next message
Bharath Kumar ,V
Messages: 18
Registered: February 2004
Junior Member
As per tom site a SCN will be generated after every commit, does it mean after internal commit or after user commit?

Report message to a moderator

Re: SCN Values [message #171738 is a reply to message #171735] Thu, 11 May 2006 05:34 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Both.

Report message to a moderator

Re: SCN Values [message #171784 is a reply to message #171738] Thu, 11 May 2006 08:02 Go to previous messageGo to next message
Bharath Kumar ,V
Messages: 18
Registered: February 2004
Junior Member
I'm using oracle 10gR2 in this I've open two session in one session I'm keep on chking the SCN ID(ever 3 sec, it has been changed). In my second session I do fire my commit.. immediately I try to get the SCN number in the first session but it never change(I mean it change only every 3 sec)

--
Bharath

Report message to a moderator

Re: SCN Values [message #171823 is a reply to message #171735] Thu, 11 May 2006 11:02 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
You might be interested in the new AskTom thread, "DB transaction per day".

Report message to a moderator

Previous Topic: SP2-0613 / 0611??
Next Topic: X orale
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:46:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.