DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2001

    Question how am i know the database limits values ?

    Hi, I would like to know the value of the limits MAXLOGFILES, MAXLOGMEMBERS, etc of an existing database.
    Anybody know what is the command that I need to apply to see that information ?

    Thanks for your help

  2. #2
    Join Date
    May 2002
    One way:

    alter database backup controlfile to trace;

    Go find the trace file in your udump (if specified) directory and open it.

  3. #3
    Join Date
    Sep 2001
    Thank you very much for your answer. I thought there was some sql to check these values directly from sqlplus.

  4. #4
    Join Date
    May 2002
    Okay, another way, but the results are harder to interpret:

    select TYPE,RECORDS_TOTAL from v$controlfile_record_section;
    TYPE              RECORDS_TOTAL
    ----------------- -------------
    DATABASE                      1
    CKPT PROGRESS                 1
    REDO THREAD                   1
    REDO LOG                     32
    DATAFILE                    254
    FILENAME                    319
    TABLESPACE                  254
    RESERVED1                   254
    RESERVED2                     1
    LOG HISTORY                3598
    OFFLINE RANGE               289
    ARCHIVED LOG                  3
    BACKUP SET                  303
    BACKUP PIECE                508
    BACKUP DATAFILE             523
    BACKUP REDOLOG               79
    DATAFILE COPY               509
    BACKUP CORRUPTION           276
    COPY CORRUPTION             303
    DELETED OBJECT              101
    PROXY COPY                  572
    RESERVED4                  2024
    22 rows selected.
    Only MAXLOGMEMBERS is available via x$kccdi.dimlm

    NOTE: Contents of the x$tables are not guaranteed to stay the same between releases anyway so caution should be used when referencing them.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.