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.