Where do I see the value of Maxdatafiles 2

[Rmcta]

Which view can I use to see the value set for Maxdatafiles. maxlogmembers, maxloghistory and maxinstances?

 

[sybaseguru]

These are static parameters at the time of database creation. The way I normally find out about these parameters is to do a command (which I gave to your question in another thread) as follows:

sys@TEST.WORLD> alter database backup controlfile to trace;

Database altered.

sys@TEST.WORLD> !ls -t /u001/oracle/admin/TEST/udump|head -1
test_ora_1197.trc

sys@TEST.WORLD> !cat /u001/oracle/admin/TEST/udump/test_ora_1197.trc|egrep -i 'max'
# LOG_ARCHIVE_MAX_PROCESSES=2
# LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
     SIZE 41943040  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
     SIZE 104857600  REUSE AUTOEXTEND ON NEXT 104857600  MAXSIZE 32767M;
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
     SIZE 41943040  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
     SIZE 104857600  REUSE AUTOEXTEND ON NEXT 104857600  MAXSIZE 32767M;

No hassle.

 

[dbalearner]

sybaseguru,

You are really a practitioner. Nice one

 

[Rmcta]

GOT IT! Thank you so much

 

[nassrin5]

That is the best example of a command line utility within Oracle I have seen for a long time as long as I remember the directory path!