Originally posted by dsr
1.Where will the path for parameter file be taken from(if we dont specify it during startup)?
2.Should i place pfile only in Oraclehome\database?
1. In Windows it will be taken from ORA_%ORACLE_SID%_PFILE reg parameter.

2. Not necessary.. Good practice will be to place in
?\ADMIN\%ORACLE_SID%\PFILE\init%ORACLE_SID%.ora

Originally posted by dsr
3.Or is it ok if i place it in a different directory and give that path in the registry.
3. Its okay.. Not a good practice