V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the
V$SYSTEM_PARAMETER view.

1. ISDEFAULT 是否是默認(rèn)值
Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE)

2. ISSES_MODIFIABLE 是否可在 SESSION 級(jí)別修改
Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)

3. ISSYS_MODIFIABLE 是否可以在 SYSTEM 級(jí)別修改
Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:
    # 立即對(duì)所有 SESSION 生效
    IMMEDIATE- Parameter can be changed with
    ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.

    # 對(duì)修改完成之后建立的 SESSION 生效
    DEFERRED- Parameter can be changed with
    ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.

    # 需重啟實(shí)例才能生效
    FALSE- Parameter cannot be changed with
    ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.

4. ISINSTANCE_MODIFIABLE 集群的不同節(jié)點(diǎn)是否可以設(shè)置不同的參數(shù)值
For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). If the ISSYS_MODIFIABLE column is FALSE, then this column is always FALSE.

5. ISMODIFIED 參數(shù)是否被修改過(guò)以及修改的級(jí)別
Indicates whether the parameter has been modified after instance startup:
    MODIFIED- Parameter has been modified with
    ALTER SESSION
    SYSTEM_MOD- Parameter has been modified with
    ALTER SYSTEM (which causes all the currently logged in sessions' values to be modified)
    FALSE- Parameter has not been modified after instance startup

6. ISADJUSTED
Indicates whether Oracle adjusted the input value to a more suitable value (for example, the parameter value should be prime, but the user input a non-prime number, so Oracle adjusted the value to the next prime number)

7. ISDEPRECATED
Indicates whether the parameter has been deprecated (TRUE) or not (FALSE)

8. ISBASIC
Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE)

18C 新增參數(shù)
9. CON_ID 容器 ID
The ID of the container to which the data pertains. Possible values include:

    0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
    1: This value is used for rows containing data that pertain to only the root
    n: Where n is the applicable container ID for the rows containing data

19C 新增參數(shù)
10. ISPDB_MODIFIABLE 是否可在 PDB 級(jí)別修改
Indicates whether the parameter can be modified inside a PDB (TRUE) or not (FALSE)

創(chuàng)新互聯(lián)成立于2013年，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項(xiàng)目成都做網(wǎng)站、成都網(wǎng)站制作網(wǎng)站策劃，項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢(mèng)想脫穎而出為使命，1280元岳池做網(wǎng)站,已為上家服務(wù),為岳池各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:18980820575

網(wǎng)頁(yè)標(biāo)題：通過(guò)v$parameter視圖看參數(shù)修改級(jí)別(11g,18c,19c)
網(wǎng)址分享：http://chinadenli.net/article40/pigjeo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供ChatGPT、企業(yè)建站、網(wǎng)站制作、小程序開發(fā)、App開發(fā)、定制網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)