| 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.
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
| Re: Flashback SCN [message #249061 is a reply to message #249054] |
Tue, 03 July 2007 04:03 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
