Results 1 to 2 of 2

Thread: Checkpoint

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Checkpoint

    Hi all,

    Which query i need to use to get current checkpoint information?

    regards
    sudheer

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Try with below query

    select name, checkpoint_change#, to_char(checkpoint_time, 'DD.MM.YYYY HH24:MIS') from v$datafile_header
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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