[Oracle true 2 series] the initialization parameters are static and dynamic

Source: Internet
Author: User
In When learning Oracle, we will find that many of Oracle's knowledge points are in pairs.
So, in order to facilitate understanding and memory, I will make a summary of this series.

The first part of this series is: Is the initialization parameter static or dynamic?
In Oracle, spfile is introduced from 9i. Many parameters support online modification, that is, the modification will take effect immediately.

The official documentation provides the following instructions:

 
The issys_modifiable column in V $ parameter tells us whether the parameters are static or dynamicstatic parameters require the instance to be restarted while dynamic parameters can take effect immediately upon being changed


Check the value of issys_modifiable:

 
Sys @ orcl> select distinct issys_modifiable from V $ parameter; ISSYS_MOD---------IMMEDIATEFALSEDEFERRED

Parameter value description:

● False: If issys_modifiable is changed to this value, the parameter is static.
● Immediate: Indicates that the parameter is dynamic, can be modified online, and takes effect online.
● Deferred: This parameter is dynamic. However, the modification is invalid in the current session and takes effect only for the next session.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.