You can do
select * from v$parameter ;

This is what is set with your init.ora or you can do

select * from sys.props$;

That gives you who the db have been setup. ( Never update this table : sys.props$ ).