Home » RDBMS Server » Server Administration » identify the current SCN ?
identify the current SCN ? [message #177737] Fri, 16 June 2006 06:07 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
how do i know the current SCN ???

Report message to a moderator

Re: identify the current SCN ? [message #177739 is a reply to message #177737] Fri, 16 June 2006 06:23 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Using DBMS_FLASHBACK Package

Select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;

Regards
Salih KM

Report message to a moderator

Re: identify the current SCN ? [message #178261 is a reply to message #177739] Tue, 20 June 2006 06:38 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Could you please explain me what is SCN? from my knowledge whenever transaction either commited or rollback then SCN will be generated!am i right? if this is the case then i made only one transaction but your query results with different number?

Report message to a moderator

Re: identify the current SCN ? [message #178416 is a reply to message #177737] Wed, 21 June 2006 01:56 Go to previous message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
when commited yes NEW SCN generated.

but for rollback i dont know ??

dba gurus ?? any answer ??

Report message to a moderator

Previous Topic: Anything comparable with Bufferpools?
Next Topic: question regarding recovery parameters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:50:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.