initsidname.ora file

you'll find it in the operating system  it should be in $ORACLE_HOME/dbs

It is your pfile, startup, for the oracle database.

You cannot locate it in exnterprise namager.  If is in a default location:  %ORACLE_HOME%/dbs

Now if you are using a stored,  or spfile, there is an spfile database parameter that can tell you the location.

slighttwv

I have opened the spfile now . can you tell me about that parameter?

Also I am just checking into one of the manuals I have been provided by my senior at the company I work and it says I have to modify the parameters like open_cursors and hash parameters in the initsidname.ora using oracle enterprise manager.

Thanks.

from a sql prompt

alter system set open_cursors= <<<some value>>>  scope=spfile

this will take affect on next restart

or


alter system set open_cursors= <<<some value>>>  scope=both  

this will take affect immediately and also write to spfile for future restarts

Okay thanks

I have modified the open cursors parameter but could not locate the hash join enabled parameter . I am using oracle 10g. I heard that its obsolete or is having an alternate name in 10g. Is it true? and if it is true what is the new name.

Thanks

alter system set hash_area_size=12345678 scope=spfile


you can't do "both" with this parameter

The online docs are your friend.  It will have the old depreciated  parameters and new replacement ones.