init parameters

[mary]

Where in the database do I find my initialization parameters?
I thought you can type 'show parameter parameter_name' in sqlplus. Well, it doesn't work.
I was looking for an ORACLE_HOME setting and typed the following query:
select * from v$parameter where name ='ORACLE_HOME';
It didn't find anything either.
I know you can always go and look at your init.ora file but I prefer a quick look up through sqlplus. It saves me time since I am already logged onto sqlplus.

[mhaller]

What version of Oracle? In 8i, you can can do this from sqlplus. In Oracle 7, you need to go into Server Manager.

[nirasha]

Hi there...

There are two ways:

at sqlplus you can type in:
sho parameters
or show parameters

or you can use the v$parameter view by either selecting * from it for all or if you are looking for a particular parameter, then use the where clause for name (name here is the name of the parameter, e.g. db_block_buffers, and remember to put it in correct case and in quotes... the value is the entry.. etc..) just do a desc of V$parameter.

Good luck,
Nirasha

[maachan]

ORACLE_HOME is not an Oracle parameter.
This is set at the OS level. Therefore you cannot search for this OS parameter through SQLPLUS.

All DATABASE parameters are searchable through show parameter command or in the V$PARAMETER view.

[Halo]

ORACLE_HOME is not a valid parameter in v$parameter. Is this Unix or NT?? If you type just 'show parameter', all parameters will get listed.

[mary]

I am using NT.
I found the valid command would be
show or sho [parameter name\all].

[nabaig]

On Nt to determine your Oracle Home setting (not parameter) go into the registry>Local Machine>Software>HomeX and take a look.

Nizar