Skip to content

Instantly share code, notes, and snippets.

@gowatana
Created September 30, 2023 10:46
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save gowatana/bbdc65039895300d1bec75bcce355244 to your computer and use it in GitHub Desktop.
{
"engineType": "oracle_database",
"type": "Database_Parameter",
"topology": "ALL",
"dbVersion": "ALL",
"systemProfile": false,
"properties": [
{
"name": "UNDO_TABLESPACE",
"value": "1024",
"secure": false,
"description": "Undo Tablespace (MiB)"
},
{
"name": "TEMP_TABLESPACE",
"value": "256",
"secure": false,
"description": "Temp Tablespace (MiB)"
},
{
"name": "MEMORY_TARGET",
"value": "",
"secure": false,
"description": "Total Memory (MiB): Total memory (AKA MEMORY_TARGET) specifies the Oracle systemwide usable memory. The database tunes memory to the total memory value, reducing or enlarging the SGA and PGA as needed."
},
{
"name": "SGA_TARGET",
"value": "",
"secure": false,
"description": "SGA (MiB): Provide a value here to disable automatic shared memory management. Providing a value enables you to determine how the SGA memory is distributed among the SGA memory components."
},
{
"name": "PGA_AGGREGATE_TARGET",
"value": "",
"secure": false,
"description": "PGA (MiB): Provide a value here to disable automatic shared memory management. Providing a value enables you to determine how the PGA memory is distributed among the PGA memory components."
},
{
"name": "SHARED_SERVERS",
"value": "0",
"secure": false,
"description": "Number of shared servers: Specify this number when the connection mode is set to 'shared'"
},
{
"name": "DB_BLOCK_SIZE",
"value": "8",
"secure": false,
"description": "Block Size (KiB): Oracle Database data is stored in data blocks of the size specified. One data block corresponds to a specific number of bytes of physical space on the disk. Selecting a block size other than the default 8 kilobytes (KiB) value requires advanced knowledge and should be done only when absolutely required."
},
{
"name": "PROCESSES",
"value": "300",
"secure": false,
"description": "Number of processes: Specify the maximum number of processes that can simultaneously connect to the database. Enter a number or accept the default value of 300. The default value for this parameter is appropriate for many environments. The value you select should allow for all background processes, user processes, and parallel execution processes."
},
{
"name": "JOB_QUEUE_PROCESSES",
"value": "",
"secure": false,
"description": "Number of processes: Specify the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs."
},
{
"name": "NLS_LANGUAGE",
"value": "AMERICAN",
"secure": false,
"description": "Default Language: The default language determines how the database supports locale-sensitive information such as day and month abbreviations, default sorting sequence for character data, and reading direction (left to right ir right to left)."
},
{
"name": "NLS_TERRITORY",
"value": "AMERICA",
"secure": false,
"description": "Default Territory: Select the name of the territory whose conventions are to be followed for day and week numbering or accept the default. The default territory also establishes the default date format, the default decimal character and group separator, and the default International Standardization Organization (ISO) and local currency symbols."
}
]
}
@gowatana
Copy link
Author

下記の投稿むけ。

NDB の Oracle Database パラメータ プロファイルに初期化パラメータを追加してみる。
https://blog.ntnx.jp/entry/2023/09/30/212544

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment