Member for

10 years 4 months

Publicaciones

  • V$DATABASE

    By jcpelaez on Tue, 09/27/2016 - 08:23
    Forums
    Oracle Database

    Hola. Tengo una consulta:

    Hago una select sobre la vista V$DATABASE y obtengo lo siguiente:

     

    SELECT CREATED,RESETLOGS_TIME,PRIOR_RESETLOGS_TIME,CONTROLFILE_CREATED FROM V$DATABASE;

    CREATED                  RESETLOGS_TIME        PRIOR_RESETLOGS_TIME  CONTROLFILE_CREATED  

    -----------------------------    ------------------------------        ------------------------------------------  -------------------------------------------

    03/12/2015 08:57:09   26/06/2013 08:50:58         30/03/2010 10:07:44               03/12/2015 08:57:09   

     

    SELECT INCARNATION#,RESETLOGS_TIME,PRIOR_RESETLOGS_TIME,PRIOR_INCARNATION#

    FROM V$DATABASE_INCARNATION;