I got this query from the list. I can try it.
JOan
select
decode (indx,
3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY
') , rsnum from x$kccrs
where indx in (3,4,2,9)
union all
select 'MAXLOGMEMBERS ',dimlm from x$kccdi
/
Rachel Carmichael wrote:
I believe that
I believe that the only way to see that information is to do an alter
database backup controlfile to trace
as it is stored only in the controlfiles. This was true in 7.3 and 8.x
--- Sinard Xing [EMAIL PROTECTED] wrote:
Hi all,
Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ?
Hi all,
Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ?
I mean which views or tables (DD) to query from.
Note:
Oracle doc said see your operating system-specific Oracle documentation,
which is I don't have any : (
Thank you
Sinardy
--
Please see the official ORACLE-L
One sure way I know is
ALTER DATABASE BACKUP CONTROLFILE TO TRACE ;
May be someone can point out other methods..
HTH,
Rajesh
-Original Message-
Sent: Wednesday, January 16, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Where to find information about my