Initialization Parameter Changes from 9i to 10g
Initialization Parameter and Data Dictionary Changes
1.Initialization Parameter Changes
A. Deprecated Initialization Parameters
SQL> SELECT name FROM v$parameter
WHERE isdeprecated = 'TRUE';
Note:A deprecated parameter behaves the same way as a regular parameter,but if a deprecated parameter is specified in the parameter file,
then a warning message is displayed at instance startup .
Initialization Parameters Deprecated in Release 10.2
LOGMNR_MAX_PERSISTENT_SESSIONS
MAX_COMMIT_PROPAGATION_DELAY
REMOTE_ARCHIVE_ENABLE
SERIAL_REUSE
SQL_TRACE
B. Obsolete Initialization Parameters
Note:An attempt to start a release 10.1 database using one or more of these obsolete initialization parameters will succeed, but a warning will be returned and recorded in the alert log.
Initialization Parameters Obsolete in Release 10.2
ENQUEUE_RESOURCES
2.Compatibility Issues with Initialization Parameters
A. OPEN_CURSORS --> SESSION_CACHED_CURSORS (>=10.1 release:the number of SQL cursors cached by PL/SQL was determined )
待續
參考文獻:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9252210/viewspace-604131/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- The SPFILE Initialization Parameter
- Initialization Parameter Files and Server Parameter Files (287)Server
- Special Characters in Initialization Parameter Files
- OPTIMIZER_MODE Initialization Parameter
- Rules Governing Initialization Parameter FilesGo
- DB_NAME Initialization Parameter (87)
- DB_DOMAIN Initialization Parameter (88)AI
- The SGA_TARGET Initialization Parameter (74)
- Step 3: Create the Initialization Parameter File (61)
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- The SGA_MAX_SIZE Initialization Parameter (72)
- UNDO_MANAGEMENT Initialization Parameter (118)
- DB_CACHE_SIZE Initialization Parameter (109)
- Oracle 10g DML Table Monitoring ChangesOracle 10g
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- Oracle修改初始化引數(initialization parameter)scope的選項Oracle
- The COMPATIBLE Initialization Parameter and Irreversible Compatibility (119)
- Oracle Flashback (9i & 10g) [zt]Oracle
- DELETE from DBA_TABLESPACES IN 10Gdelete
- 9I 10g LISTENER 加密 的不同加密
- upgrade oracle version 9i to 10gOracle
- oracle 9i/10g merge 用法Oracle
- Oracle 9i/10g的官方教材Oracle
- Migrate from SQL SERVER to Oracle 10GSQLServerOracle 10g
- Initialization
- Oracle 9i, 10g jdbc driver 檔案OracleJDBC
- 轉:oracle 9i/10g merge 用法Oracle
- oracle 10g的dmp如何匯入9iOracle 10g
- list initialization
- Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4Oracle 10g
- 10g和9i執行計劃差異
- Oracle Advanced Replication 1 例 9i to 10g MVROracleVR
- Windows下9i,10g共存9i dbca無法啟動的解決辦法Windows
- Upgrading from Oracle Database 10g to 11gOracleDatabase
- Oracle 9i、10g 常用軟體補丁下載地址Oracle
- Oracle 補丁全集 (Oracle 9i 10g 11g Path)Oracle
- Oracle 9i和10G軟體及補丁下載地址Oracle
- 9I 資料庫升級到10g的步驟資料庫