-
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
-
One way:
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:
Code:
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|