|
-
Some parameters can be changed while the database is up, some can not. For a list of the parameters that can be changed:
select name from v$parameter
where issys_modifiable = 'IMMEDIATE'
Otherwise, you will have to bounce your database for the parameter to become effective.
To change a value, use:
alter system set your_parameter_name = new_value;
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|