OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Flashback SCN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Flashback SCN [message #249033]

Tue, 03 July 2007 02:11

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.

Report message to a moderator

Re: Flashback SCN [message #249037 is a reply to message #249033]

Tue, 03 July 2007 02:25

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Flashback SCN [message #249054 is a reply to message #249037]

Tue, 03 July 2007 03:27

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.

Report message to a moderator

Re: Flashback SCN [message #249057 is a reply to message #249054]

Tue, 03 July 2007 03:31

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

Report message to a moderator

Re: Flashback SCN [message #249061 is a reply to message #249054]

Tue, 03 July 2007 04:03

Michel Cadot
Messages: 68686
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

Report message to a moderator

Previous Topic:	FIXED ORA-12514 When Setting up a Servive Name using Net Configuration Assistant
Next Topic:	OEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:02:00 CDT 2024