| Database query [message #50245] |
Thu, 07 March 2002 00:24  |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
How can i find out what the values of maxlogfiles, maxlogmembers, maxdatafiles and maxloghistory were set to when a database was created. Just a matter of interest only. Where using ORACLE 8i on Unix (Sun Solaris 8).
Thanks.
|
|
|
|
| Re: Database query [message #50252 is a reply to message #50245] |
Thu, 07 March 2002 08:15  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
alter database backup controlfile to trace;
This will create a trace file in the udump directory. It has all your looking for.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
