Hi everyone,

Could someone please tell me which data dictionary view contains the information which sort of initialisation file my instance is using?

I tried the obvious ones: v$parameter and v$system_parameter, but the information is only shown for some databases (their location, anyway), but not always. Quite often the values for 'ifile' and /or 'spfile' are just empty.

Thanks
Peer