2 You did bounce the instance after the chance?Hi, I understand where you coming from but for the sake of enlightment (btw I couldn t recreate this problem!!!) - when I do that I do become always the actual info (with me, testdb instead of testdb01) so I am guessing that he must have bounced the db;
instance_name is a static parameter.
Also : show parameter will always use your session
parameters. It will not read the pfile.
if if show parameter command is not reading pfile from where it gets the session parameters?it reads from the pfile which is a init.ora file but it is not actually reading from the parameter file rather it gives the settings that are set by the init.ora during startup and also the dynamic values ..I am not 100% sure here