scott_m_ruby
asked on
Changing an Initilization Parmeter in Oracle 10g release 2.
I want to increase the HASH_AREA_SIZE parmeter for my oracle 10g instance on startup. I understand that the init.ora is not any longer. How can this be done?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Badri,
How do you go about setting that for the instance?
Thanks,
Scott
How do you go about setting that for the instance?
Thanks,
Scott
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
There is a new parameter in Oracle 10g. That is workarea_size_policy, with which all the *area_size will be managed internally by Oracle.
HTH
Regards,
Badri.