Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    42

    Red face Unanswered: cant understand v$undostat

    i m learning Oracle.
    i read from a tutorial that the V$undostat view shows undo blocks used in a time interval of 10 mins.
    whn i tried the same in my windows machine on which Oracle 9.2 is installed i get the following.
    the end time n begin time is not 10 mins and looks wierd.
    cud someone plz explain this to me. am i missing something?
    i referred this also
    Code:
    SQL> select to_char(end_time,'DD-Mon-YY hh24:mm:ss'),to_char(begin_time,'DD-Mon-YY hh24:mm:ss'),UNDOBLKS from v$undostat;
    
    TO_CHAR(END_TIME,' TO_CHAR(BEGIN_TIME   UNDOBLKS   
    ------------------ ------------------ ----------   
    26-Jun-08 22:06:59 26-Jun-08 21:06:28          0   
    26-Jun-08 21:06:28 26-Jun-08 21:06:28          1   
    26-Jun-08 21:06:28 26-Jun-08 21:06:28          0   
    26-Jun-08 21:06:28 26-Jun-08 21:06:28          0   
    26-Jun-08 21:06:28 26-Jun-08 21:06:28          0   
    26-Jun-08 21:06:28 26-Jun-08 20:06:28          0   
    26-Jun-08 20:06:28 26-Jun-08 20:06:28          1   
    26-Jun-08 20:06:28 26-Jun-08 19:06:28          0   
    26-Jun-08 19:06:28 26-Jun-08 19:06:28          1   
    26-Jun-08 19:06:28 26-Jun-08 19:06:28          0   
    26-Jun-08 19:06:28 26-Jun-08 19:06:28          1   
    26-Jun-08 19:06:28 26-Jun-08 19:06:28          0   
    26-Jun-08 19:06:28 26-Jun-08 18:06:28          0   
    26-Jun-08 18:06:28 26-Jun-08 18:06:28          0   
    26-Jun-08 18:06:28 26-Jun-08 18:06:28          0   
    26-Jun-08 18:06:28 26-Jun-08 18:06:28          0   
    26-Jun-08 18:06:28 26-Jun-08 17:06:28          0   
    26-Jun-08 17:06:28 26-Jun-08 17:06:28          0   
    26-Jun-08 17:06:28 26-Jun-08 16:06:28          0   
    26-Jun-08 16:06:28 26-Jun-08 16:06:28          1   
    26-Jun-08 16:06:28 26-Jun-08 15:06:28          0   
    26-Jun-08 15:06:28 26-Jun-08 15:06:28          0   
    26-Jun-08 15:06:28 26-Jun-08 14:06:28          0   
    26-Jun-08 14:06:28 26-Jun-08 14:06:28          0   
    26-Jun-08 14:06:28 26-Jun-08 14:06:28          1   
    26-Jun-08 14:06:28 26-Jun-08 14:06:28          0   
    26-Jun-08 14:06:28 26-Jun-08 13:06:28          1   
    26-Jun-08 13:06:28 26-Jun-08 13:06:28          0   
    26-Jun-08 13:06:28 26-Jun-08 13:06:28          1   
    26-Jun-08 13:06:28 26-Jun-08 13:06:28          0   
    26-Jun-08 13:06:28 26-Jun-08 13:06:28          1   
    26-Jun-08 13:06:28 26-Jun-08 12:06:28          0   
    26-Jun-08 12:06:28 26-Jun-08 12:06:28          0   
    26-Jun-08 12:06:28 26-Jun-08 10:06:28          0   
    26-Jun-08 10:06:28 26-Jun-08 10:06:28          0   
    26-Jun-08 10:06:28 26-Jun-08 09:06:28          0   
    26-Jun-08 09:06:28 26-Jun-08 09:06:28          1   
    26-Jun-08 09:06:28 26-Jun-08 02:06:28          0   
    26-Jun-08 02:06:28 26-Jun-08 01:06:28          1   
    26-Jun-08 01:06:28 26-Jun-08 01:06:28          0   
    26-Jun-08 01:06:28 26-Jun-08 01:06:28          0   
    26-Jun-08 01:06:28 26-Jun-08 00:06:28          0   
    26-Jun-08 00:06:28 26-Jun-08 00:06:28          1   
    26-Jun-08 00:06:28 26-Jun-08 00:06:28          0   
    
     
    
    90 rows selected.
    
    Elapsed: 00:00:00.00
    SQL> spool off

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >cud someone plz explain this to me. am i missing something?

    "mm" is MONTH; not minute!
    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.

  3. #3
    Join Date
    May 2006
    Posts
    42
    oooooooooohhhhhhhh!! damn ..
    all the while i was wondering wat was going wrong. i started the db shut it down. went over to my other machine and chkd. phew!!
    wat a shame i got this wrong. and i had scored 48/52 in 1Z0-007 ...
    i gota practice more n concentrate harder :|
    thanks for ur help sir

Posting Permissions

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