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.
at sqlplus you can type in:
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.