From: Yong Huang <yong321@yahoo.com>
Subject: Re: database parameter
Date: 2000/07/07
Message-ID: <3965E0EC.89B6ED77@yahoo.com>#1/1
Content-Transfer-Encoding: 7bit
References: <k0495.1536$0x.49169@nuq-read.news.verio.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@cwomnes.net
X-Trace: news.sinet.slb.com 962978067 12962 163.188.121.35 (7 Jul 2000 13:54:27 GMT)
Organization: Schlumberger Omnes
Mime-Version: 1.0
NNTP-Posting-Date: 7 Jul 2000 13:54:27 GMT
Newsgroups: comp.databases.oracle.server


select * from v$parameter

answers both your questions.

Yong Huang

SP wrote:

> How can I look at database parameter.  Can I make the paramter changes when
> the instance is up and running?  Thanks.
> SP