Home » RDBMS Server » Server Administration » Oracle settings printout
Oracle settings printout [message #54431] Mon, 18 November 2002 04:08 Go to next message
Matt
Messages: 43
Registered: September 1999
Member
Hi,

We have a problem with an Oracle 9i installation in a remote location.

What we'd like to do is print out a listing of all settings in Oracle, so that we can compare the configuration of the remote installation with the installation at our office.

Is there anything in Oracle 9i which does this ?

Best.

Matt.

Report message to a moderator

Re: Oracle settings printout [message #54444 is a reply to message #54431] Mon, 18 November 2002 18:50 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Try these:
Select * from v$paramter order by 1;
Select * from v$spparamter order by 1;
Select * from v$nls_parameters;

Report message to a moderator

Re: Oracle settings printout [message #54447 is a reply to message #54431] Mon, 18 November 2002 22:38 Go to previous messageGo to next message
gp
Messages: 46
Registered: September 2002
Member
just
show parameter
on sql prompt can also help

Report message to a moderator

Re: Oracle settings printout [message #54503 is a reply to message #54444] Wed, 20 November 2002 04:32 Go to previous message
Matt
Messages: 43
Registered: September 1999
Member
Hi,

Select * from v$paramter order by 1;
Select * from v$spparamter order by 1;

I tried these, but got the error "Table or view does not exist".

I also tried :

Select * from v$parameter order by 1;
Select * from v$spparameter order by 1;

with the same result.

Best.

Matt.

Report message to a moderator

Previous Topic: replication and DDL
Next Topic: Max size of table and column names
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 16:35:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.