Home » RDBMS Server » Server Administration » Flashback SCN
Flashback SCN [message #249033] Tue, 03 July 2007 02:11 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
I ran the following snippet couple of time, but i get different o/p, why?
Meantime i haven't performed any operation.

declare
a number;
begin
a:=dbms_flashback.get_system_change_number;
dbms_output.put_line(a);
end;


Thanks.
Re: Flashback SCN [message #249037 is a reply to message #249033] Tue, 03 July 2007 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you are not the only one to work.
Even if you are alone, Oracle works too.

Regards
Michel
Re: Flashback SCN [message #249054 is a reply to message #249037] Tue, 03 July 2007 03:27 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Michel,
But no body works on this DB.
You said oracle works too!! but no transaction is happening in this database, then what exactly oracle is doing in this context?

Thanks,
Shahnaz.
Re: Flashback SCN [message #249057 is a reply to message #249054] Tue, 03 July 2007 03:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You said oracle works too!! but no transaction is happening in this database, then what exactly oracle is doing in this context?


just check when nobady access database.
select username from v$session where status = 'ACTIVE';

you will see blank in username those are process running on oracle database.

Regards
Taj
Re: Flashback SCN [message #249061 is a reply to message #249054] Tue, 03 July 2007 04:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PMON, SMON... awake periodically to check and manange the database.
You may have jobs.
If you are in 10g, MMAN, MMON, MMNL processes collect statistics...

Regards
Michel
Previous Topic: **FIXED** ORA-12514 When Setting up a Servive Name using Net Configuration Assistant
Next Topic: OEM
Goto Forum:
  


Current Time: Sat Dec 03 12:06:57 CST 2016

Total time taken to generate the page: 0.08632 seconds