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
alter database backup controlfile to trace;
Go find the trace file in your udump (if specified) directory and open it.
Thank you very much for your answer. I thought there was some sql to check these values directly from sqlplus.
Okay, another way, but the results are harder to interpret:
Only MAXLOGMEMBERS is available via x$kccdi.dimlm
select TYPE,RECORDS_TOTAL from v$controlfile_record_section;
CKPT PROGRESS 1
REDO THREAD 1
REDO LOG 32
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
22 rows selected.
NOTE: Contents of the x$tables are not guaranteed to stay the same between releases anyway so caution should be used when referencing them.
Click Here to Expand Forum to Full Width