Oracle EBS裡查看資料庫參數路徑:System Administration > Oracle Applications Manager > Initialization Parameters
或者
路徑:System Administration > Oracle Applications Manager > System Configuration Overview > Database > Init.ora Parameters
可以查看DB的資料庫parameter(init.ora或者pfile parameter)
關於Oracle Parameter可以參見我之前寫得文章：Oracle Parameters
如果是使用的init<sid>.ora的話，這個DB參數檔案預設放在$RDBMS_ORACLE_HOME/dbs/init<sid>.ora
你可以在這個檔案中修改DB參數，注意，修改完之後，需要重啟資料庫才會生效。
EBS的DB init.ora參數檔案的設定
另外這裡有兩篇不錯的metalink notes可以協助你來設定EBS的init.ora參數檔案，給出了一些設定的建議
Note: 216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
Note: 396009.1 - Database Initialization Parameters for Oracle Applications Release 12
Index for Note 396009.1
This document describes the database initialization parameter settings required for Oracle E-Business Suite Release 12.
- Section 1: Common Database Initialization Parameters For All Releases
- Section 2: Release-Specific Database Initialization Parameters For Oracle 10g Release 2
- Section 3: Release-Specific Database Initialization Parameters For Oracle 11g Release 1
- Section 4: Release-Specific Database Initialization Parameters For Oracle 11g Release 2
- Section 5: Using System Managed Undo (SMU)
- Section 6: Temporary Tablespace Setup
- Section 7: Database Initialization Parameter Sizing
Key Points
* The document consists of a common section, which provides a common set of database initialization parameters used for all releases of the Oracle Database, followed by several release-specific sections, which list parameters and settings required for a particular release of the Oracle Database.
* Put together, the parameters from the common section and appropriate release-specific section formulate a complete set of database initialization parameters.
* Parameters may appear on a removal list either because they are obsolete, or because the default value is required and no other value may be set.
* In the various parameter lists, check for comments giving any platform-specific exceptions. Such comments will apply only to the exact platform mentioned: for example, a reference to HP-UX (PA-RISC) will not apply to HP-UX (Itanium IA-64).
* The "X" notation used in the release-specific section denotes all patchset releases within that major version. For example, "10.2.0.X" refers to all releases of 10.2.0, such as 10.2.0.2 and 10.2.0.3.
* Oracle E-Business Suite Release 12 requires Oracle Database 10g Release 2 (10.2.0.2) Enterprise Edition as a minimum release level and edition. No earlier releases, or other editions of any release, may be used.
