MAXDATAFILES and other files in Oracle

This Post is about the trick by which we can use to monitor the CRDs of Oracle Database. Monitoring is the most important and common task in RDBMS. Without monitoring CDR

Let’s have look on the query which we use to monitor main elements of Oracle Database CDRs.

— MAXDATAFILES

Select ‘MAXDATAFILES ‘ || records_total from v$controlfile_record_section where type = ‘DATAFILE’;

— MAXLOGHISTORY

Select ‘MAXLOGHISTORY ‘ || records_total from v$controlfile_record_section where type = ‘LOG HISTORY’;

— MAXINSTANCES

Select ‘MAXINSTANCES ‘ || records_total from v$controlfile_record_section where type = ‘DATABASE’;

— MAXLOGFILES

Select ‘ MAXLOGFILES ‘ || records_total from v$controlfile_record_section where type = ‘REDO LOG’;

— MAXLOGMEMBERS

Select ‘MAXLOGMEMBERS ‘ || dimlm from x$kccdi;

Thank you for giving your valuable time to add more gems to Oracle treasure.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp