Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2009
    Posts
    46

    Unanswered: How to see current SCN

    Hello to all the help family members,

    I would like someone to help me out on the above issue

    That is, how can I check the current Sytem Change Number (SCN) from my database concerning flashback purposes bearing the following in mind:

    1. The alert_log SCN always laggs behind in hours or minutes so is not the best source to look up the current scn

    2. Flashback database has been enabled

    3. audit trail is not enabled

    Platform : Win 2003 R2
    Oracle Version : 10gR2

    Any help is much welcome
    Thanks

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    select current_scn from v$database
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Mar 2009
    Posts
    46
    Hi Cis Groupie,

    Much thanks for your help

  4. #4
    Join Date
    Mar 2009
    Posts
    46
    Quote Originally Posted by FoKwame
    Hi Cis Groupie,

    Much thanks for your help
    Knowledge is a Baobad Tree and cannot be embraced by one man

    More hands make less work

  5. #5
    Join Date
    Mar 2009
    Posts
    46
    Hello to all,

    Thank for the help in tracking the current SCN

    But in which table or view is the SCN tracked ?

  6. #6
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I'm not sure I understand you. It's tracked (i.e. the current one is recorded) in the view v$database. Or do you mean something else?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  7. #7
    Join Date
    Mar 2009
    Posts
    46
    Hi CIS

    My issue is whether there is any table or view which keeps track of SCNs in the database.

    The current SCN is gotten from v$database

    However, assume you want to Flashback database to an SCN of sey 30min before, where do u get the tracks of SCNs to points in time

    I hope I have made myself sufficiently clear

    Thanks

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> desc timestamp_to_scn
    FUNCTION timestamp_to_scn RETURNS NUMBER
     Argument Name			Type			In/Out Default?
     ------------------------------ ----------------------- ------ --------
     QUERY_TIME			TIMESTAMP		IN
    
    SQL> desc scn_to_timestamp
    FUNCTION scn_to_timestamp RETURNS TIMESTAMP
     Argument Name			Type			In/Out Default?
     ------------------------------ ----------------------- ------ --------
     QUERY_SCN			NUMBER			IN
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •