home *** CD-ROM | disk | FTP | other *** search
/ PC World Komputer 1996 February / PCWK0296.iso / po7_win / db / rdbms71 / vsp10.ini < prev    next >
Encoding:
INI File  |  1995-03-17  |  29.2 KB  |  1,181 lines

  1. [SERVER_VERSIONS]
  2. NT 7.0=
  3. NT 7.1=
  4. Windows 7.1=
  5. Solaris 7.1=
  6. Netware 7.1=
  7. SCO 7.1=
  8. UnixWare 7.1=
  9. HP-UX 7.1=
  10.  
  11. [CONFIGURATIONS_NT 7.0]
  12. NT 7.0 OWS Small=
  13. NT 7.0 OWS Medium=
  14. NT 7.0 OWS Large=
  15.  
  16. [CONFIGURATIONS_Windows 7.1]
  17. Windows 7.1 PL/SQL=
  18. Windows 7.1 No PL/SQL=
  19. Windows 7.1 Default=
  20.  
  21. [CONFIGURATIONS_NT 7.1]
  22. NT 7.1 O7S Small=
  23. NT 7.1 O7S Medium=
  24. NT 7.1 O7S Large=
  25.  
  26. [CONFIGURATIONS_Solaris 7.1]
  27. Solaris 7.1 OWS Small=
  28. Solaris 7.1 OWS Medium=
  29. Solaris 7.1 OWS Large=
  30.  
  31. [CONFIGURATIONS_HP-UX 7.1]
  32. HP-UX 7.1 OWS Small=
  33. HP-UX 7.1 OWS Medium=
  34. HP-UX 7.1 OWS Large=
  35.  
  36. [CONFIGURATIONS_Netware 7.1]
  37. Netware 7.1 OWS Small=
  38. Netware 7.1 OWS Medium=
  39. Netware 7.1 OWS Large=
  40.  
  41. [CONFIGURATIONS_SCO 7.1]
  42. SCO 7.1 OWS Small=
  43. SCO 7.1 OWS Medium=
  44. SCO 7.1 OWS Large=
  45.  
  46. [CONFIGURATIONS_UnixWare 7.1]
  47. UnixWare 7.1 OWS Small=
  48. UnixWare 7.1 OWS Medium=
  49. UnixWare 7.1 OWS Large=
  50.  
  51. [TYPES]
  52. ASYNC_READ=B
  53. ASYNC_WRITE=B
  54. AUDIT_FILE_DEST=S
  55. AUDIT_TRAIL=S
  56. AUTO_MOUNTING=S
  57. BACKGROUND_CORE_DUMP=S
  58. BACKGROUND_DUMP_DEST=S
  59. BLANK_TRIMMING=B
  60. CACHE_SIZE_THRESHOLD=N
  61. CCF_IO_SIZE=I
  62. CHECKPOINT_PROCESS=B
  63. CLEANUP_ROLLBACK_ENTRIES=N
  64. CLOSE_CACHED_OPEN_CURSORS=B
  65. COMMIT_POINT_STRENGTH=N
  66. COMPATIBLE=S
  67. COMPATIBLE_NO_RECOVERY=S
  68. CONTROL_FILES=S
  69. CORE_DUMP_DEST=S
  70. CURSOR_SPACE_FOR_TIME=B
  71. DBLINK_ENCRYPT_LOGIN=B
  72. DB_BLOCK_BUFFERS=N
  73. DB_BLOCK_CHECKPOINT_BATCH=N
  74. DB_BLOCK_LRU_EXTENDED_STATISTICS=N
  75. DB_BLOCK_LRU_STATISTICS=B
  76. DB_BLOCK_SIZE=N
  77. DB_DOMAIN=S
  78. DB_FILES=N
  79. DB_FILE_MULTIBLOCK_READ_COUNT=N
  80. DB_FILE_SIMULTANEOUS_WRITES=N
  81. DB_MOUNT_MODE=S
  82. DB_NAME=S
  83. DB_WRITERS=1
  84. DISCRETE_TRANSACTIONS_ENABLED=B
  85. DISTRIBUTED_LOCK_TIMEOUT=N
  86. DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME=N
  87. DISTRIBUTED_TRANSACTIONS=N
  88. DML_LOCKS=N
  89. ENQUEUE_RESOURCES=N
  90. EVENT=S
  91. FIXED_DATE=S
  92. GC_DB_LOCKS=S
  93. GC_FILES_TO_LOCKS=S
  94. GC_LCK_PROCS=S
  95. GC_ROLLBACK_LOCKS=S
  96. GC_ROLLBACK_SEGMENTS=N
  97. GC_SAVE_ROLLBACK_LOCKS=S
  98. GC_SEGMENTS=N
  99. GC_TABLESPACES=N
  100. GLOBAL_NAMES=B
  101. IFILE=S
  102. INIT_SQL_FILES=S
  103. INSTANCE_NUMBER=S
  104. JOB_QUEUE_INTERVAL=N
  105. JOB_QUEUE_KEEP_CONNECTIONS=B
  106. JOB_QUEUE_PROCESSES=N
  107. LABEL_CACHE_SIZE=S
  108. LGWR_USE_ASYNC_IO=B
  109. LICENSE_MAX_SESSIONS=N
  110. LICENSE_MAX_USERS=N
  111. LICENSE_SESSIONS_WARNING=N
  112. LOG_ARCHIVE_BUFFER_SIZE=N
  113. LOG_ARCHIVE_BUFFERS=N
  114. LOG_ARCHIVE_DEST=S
  115. LOG_ARCHIVE_FORMAT=S
  116. LOG_ARCHIVE_START=B
  117. LOG_BUFFER=N
  118. LOG_CHECKPOINTS_TO_ALERT=B
  119. LOG_CHECKPOINT_INTERVAL=N
  120. LOG_CHECKPOINT_TIMEOUT=N
  121. LOG_FILES=N
  122. LOG_SIMULTANEOUS_COPIES=N
  123. LOG_SMALL_ENTRY_MAX_SIZE=N
  124. MAX_BACKOFF=N
  125. MAX_COMMIT_PROPAGATION_DELAY=N
  126. MAX_DUMP_FILE_SIZE=N
  127. MAX_ENABLED_ROLES=N
  128. MAX_ROLLBACK_SEGMENTS=N
  129. MLS_LABEL_FORMAT=S
  130. MTS_DISPATCHERS=S
  131. MTS_LISTENER_ADDRESS=S
  132. MTS_MAX_DISPATCHERS=N
  133. MTS_MAX_SERVERS=N
  134. MTS_SERVERS=N
  135. MTS_SERVICE=S
  136. NLS_CURRENCY=S
  137. NLS_DATE_FORMAT=S
  138. NLS_DATE_LANGUAGE=S
  139. NLS_ISO_CURRENCY=S
  140. NLS_LANGUAGE=S
  141. NLS_NUMERIC_CHARACTERS=S
  142. NLS_SORT=S
  143. NLS_TERRITORY=S
  144. OPEN_CURSORS=N
  145. OPEN_LINKS=N
  146. OPEN_MOUNTS=N
  147. OPTIMIZER_COMP_WEIGHT=N
  148. OPTIMIZER_MODE=S
  149. OS_AUTHENT_PREFIX=S
  150. OS_ROLES=B
  151. PARALLEL_DEFAULT_MAX_INSTANCES=N                                                                      
  152. PARALLEL_DEFAULT_MAX_SCANS=N
  153. PARALLEL_DEFAULT_SCANSIZE=N                                                                           
  154. PARALLEL_MAX_SERVERS=N                                                                                
  155. PARALLEL_MIN_SERVERS=N                                                                                                    
  156. PARALLEL_SERVER_IDLE_TIME=N
  157. POST_WAIT_DEVICE=S                                                                           
  158. PRE_PAGE_SGA=B
  159. PROCESSES=N
  160. RECOVERY_PARALLELISM=N
  161. REDUCE_ALARM=B                                                                                                  
  162. REMOTE_LOGIN_PASSWORDFILE=S                                                                                                
  163. REMOTE_OS_AUTHENT=B
  164. REMOTE_OS_ROLES=B
  165. RESOURCE_LIMIT=B
  166. ROLLBACK_SEGMENTS=S
  167. ROW_CACHE_CURSORS=N
  168. ROW_LOCKING=S
  169. SEQUENCE_CACHE_ENTRIES=N
  170. SEQUENCE_CACHE_HASH_BUCKETS=N
  171. SERIALIZABLE=B
  172. SESSION_CACHED_CURSORS=N
  173. SESSIONS=N
  174. SHADOW_CORE_DUMP=S
  175. SHARED_POOL_SIZE=N
  176. SINGLE_PROCESS=B
  177. SMALL_TABLE_THRESHOLD=N
  178. SNAPSHOT_REFRESH_INTERVAL=N
  179. SNAPSHOT_REFRESH_KEEP_CONNECTIONS=B
  180. SNAPSHOT_REFRESH_PROCESSES=N
  181. SORT_AREA_RETAINED_SIZE=N
  182. SORT_AREA_SIZE=N
  183. SORT_MTS_BUFFER_FOR_FETCH_SIZE=N
  184. SORT_READ_FAC=N
  185. SORT_SPACEMAP_SIZE=N
  186. SPIN_COUNT=N
  187. SQL92_SECURITY=B                                                                                               
  188. SQL_TRACE=B
  189. TEMPORARY_TABLE_LOCKS=N
  190. THREAD=N
  191. TIMED_STATISTICS=B
  192. TRANSACTIONS=N
  193. TRANSACTIONS_PER_ROLLBACK_SEGMENT=N
  194. USE_ASYNC_IO=B
  195. USE_ISM=B
  196. USE_POST_WAIT_DRIVER=B
  197. USE_READV=B
  198. USER_DUMP_DEST=S
  199.  
  200. [CONFIGURATION__Windows 7.1]
  201. VS__SUBLAYER=CONFIGURATION__NT 7.1
  202. VS__SERVER_VERSION=Windows 7.1
  203. VS__REQUIRED=CONTROL_FILES,DB_NAME,REMOTE_LOGIN_PASSWORDFILE
  204. VS__COMMENT=Windows 7.1 Database Default
  205. EDITED=2.0
  206. CONTROL_FILES=(%RDBMS71_CONTROL%\ctl1.ora, %RDBMS71_ARCHIVE%\ctl1.ora)
  207. LICENSE_MAX_SESSIONS=25
  208. REMOTE_LOGIN_PASSWORDFILE=SHARED
  209.  
  210. [CONFIGURATION__NT 7.1]
  211. VS__SERVER_VERSION=NT 7.1
  212. VS__SUBLAYER=CONFIGURATION__NT 7.0
  213. VS__COMMENT=NT 7.1 Database Default
  214. VS__DISALLOWED=INIT_SQL_FILES,SMALL_TABLE_THRESHOLD
  215. EDITED=2.0
  216. BLANK_TRIMMING=FALSE
  217. CACHE_SIZE_THRESHOLD=3
  218. CLOSE_CACHED_OPEN_CURSORS=FALSE
  219. CONTROL_FILES=%RDBMS71_CONTROL%\ctl1.ora
  220. DBLINK_ENCRYPT_LOGIN=FALSE
  221. GC_ROLLBACK_SEGMENTS=20
  222. GC_SEGMENTS=10
  223. GC_TABLESPACES=5
  224. IFILE=
  225. JOB_QUEUE_INTERVAL=60
  226. JOB_QUEUE_KEEP_CONNECTIONS=FALSE
  227. JOB_QUEUE_PROCESSES=0
  228. LICENSE_MAX_SESSIONS=0
  229. LOG_ARCHIVE_DEST=%RDBMS71%\
  230. MAX_ENABLED_ROLES=20
  231. MTS_MAX_DISPATCHERS=0
  232. MTS_MAX_SERVERS=0
  233. PARALLEL_DEFAULT_MAX_INSTANCES=0                                                                      
  234. PARALLEL_DEFAULT_MAX_SCANS=0
  235. PARALLEL_DEFAULT_SCANSIZE=100                                                                           
  236. PARALLEL_MAX_SERVERS=5                                                                                
  237. PARALLEL_MIN_SERVERS=0                                                                                                    
  238. PARALLEL_SERVER_IDLE_TIME=5                                                                           
  239. RECOVERY_PARALLELISM=0                                                                                                  
  240. REMOTE_LOGIN_PASSWORDFILE=NONE                                                                                                
  241. SQL92_SECURITY=FALSE                                                                                               
  242.  
  243. [CONFIGURATION__NT 7.0]
  244. VS__SERVER_VERSION=NT 7.0
  245. VS__REQUIRED=CONTROL_FILES,DB_NAME
  246. VS__COMMENT=NT 7.0 Database Default
  247. EDITED=2.0
  248. AUDIT_TRAIL=NONE
  249. BACKGROUND_DUMP_DEST=
  250. CHECKPOINT_PROCESS=FALSE
  251. CLEANUP_ROLLBACK_ENTRIES=20
  252. COMMIT_POINT_STRENGTH=1
  253. COMPATIBLE=
  254. COMPATIBLE_NO_RECOVERY=
  255. CONTROL_FILES=%RDBMS70_CONTROL%\ctl1.ora
  256. CURSOR_SPACE_FOR_TIME=FALSE
  257. DB_BLOCK_BUFFERS=32
  258. DB_BLOCK_CHECKPOINT_BATCH=8
  259. DB_BLOCK_LRU_EXTENDED_STATISTICS=0
  260. DB_BLOCK_LRU_STATISTICS=FALSE
  261. DB_BLOCK_SIZE=2048
  262. DB_DOMAIN=WORLD
  263. DB_FILES=32
  264. DB_FILE_MULTIBLOCK_READ_COUNT=4
  265. DB_FILE_SIMULTANEOUS_WRITES=4
  266. DB_NAME=oracle
  267. DISCRETE_TRANSACTIONS_ENABLED=FALSE
  268. DISTRIBUTED_LOCK_TIMEOUT=60
  269. DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME=200
  270. DISTRIBUTED_TRANSACTIONS=8
  271. DML_LOCKS=140
  272. ENQUEUE_RESOURCES=160
  273. EVENT=
  274. FIXED_DATE=
  275. GLOBAL_NAMES=FALSE
  276. INIT_SQL_FILES=%RDBMS70%\ADMIN\SQL.BSQ
  277. LICENSE_MAX_SESSIONS=25
  278. LICENSE_MAX_USERS=0
  279. LICENSE_SESSIONS_WARNING=0
  280. LOG_ARCHIVE_BUFFER_SIZE=127
  281. LOG_ARCHIVE_BUFFERS=4
  282. LOG_ARCHIVE_DEST=%RDBMS70%\
  283. LOG_ARCHIVE_FORMAT=ARC%S.%T
  284. LOG_ARCHIVE_START=FALSE
  285. LOG_BUFFER=32768
  286. LOG_CHECKPOINTS_TO_ALERT=FALSE
  287. LOG_CHECKPOINT_INTERVAL=8000
  288. LOG_CHECKPOINT_TIMEOUT=0
  289. LOG_FILES=255
  290. LOG_SIMULTANEOUS_COPIES=0
  291. LOG_SMALL_ENTRY_MAX_SIZE=800
  292. MAX_COMMIT_PROPAGATION_DELAY=90000
  293. MAX_DUMP_FILE_SIZE=500
  294. MAX_ENABLED_ROLES=22
  295. MAX_ROLLBACK_SEGMENTS=30
  296. MTS_DISPATCHERS=
  297. MTS_LISTENER_ADDRESS=(address=(protocol=ipc)(key=%s))
  298. MTS_MAX_DISPATCHERS=5
  299. MTS_MAX_SERVERS=20
  300. MTS_SERVERS=0
  301. MTS_SERVICE=
  302. NLS_CURRENCY=
  303. NLS_DATE_FORMAT=
  304. NLS_DATE_LANGUAGE=
  305. NLS_ISO_CURRENCY=
  306. NLS_LANGUAGE=AMERICAN
  307. NLS_NUMERIC_CHARACTERS=
  308. NLS_SORT=
  309. NLS_TERRITORY=AMERICA
  310. OPEN_CURSORS=50
  311. OPEN_LINKS=4
  312. OPTIMIZER_COMP_WEIGHT=0
  313. OPTIMIZER_MODE=CHOOSE
  314. OS_AUTHENT_PREFIX=OPS$
  315. OS_ROLES=FALSE
  316. PRE_PAGE_SGA=FALSE
  317. PROCESSES=25
  318. REMOTE_OS_AUTHENT=FALSE
  319. REMOTE_OS_ROLES=FALSE
  320. RESOURCE_LIMIT=FALSE
  321. ROLLBACK_SEGMENTS=
  322. ROW_CACHE_CURSORS=10
  323. ROW_LOCKING=default
  324. SEQUENCE_CACHE_ENTRIES=10
  325. SEQUENCE_CACHE_HASH_BUCKETS=7
  326. SERIALIZABLE=FALSE
  327. SESSIONS=32
  328. SHARED_POOL_SIZE=3500000
  329. SINGLE_PROCESS=FALSE
  330. SMALL_TABLE_THRESHOLD=4
  331. SNAPSHOT_REFRESH_INTERVAL=60
  332. SNAPSHOT_REFRESH_KEEP_CONNECTIONS=FALSE
  333. SNAPSHOT_REFRESH_PROCESSES=0
  334. SORT_AREA_RETAINED_SIZE=65536
  335. SORT_AREA_SIZE=65536
  336. SORT_MTS_BUFFER_FOR_FETCH_SIZE=0
  337. SORT_READ_FAC=20
  338. SORT_SPACEMAP_SIZE=512
  339. SQL_TRACE=FALSE
  340. TEMPORARY_TABLE_LOCKS=32
  341. THREAD=0
  342. TIMED_STATISTICS=FALSE
  343. TRANSACTIONS=35
  344. TRANSACTIONS_PER_ROLLBACK_SEGMENT=16
  345. USER_DUMP_DEST=
  346.  
  347. [CONFIGURATION_NT 7.0 OWS Medium]
  348. VS__SUBLAYER=CONFIGURATION__NT 7.0
  349. VS__COMMENT=OWS Medium Memory
  350. EDITED=2.0
  351. BACKGROUND_DUMP_DEST=%RDBMS70%\trace
  352. CONTROL_FILES=(%RDBMS70_CONTROL%\ctl1.ora, %RDBMS70_ARCHIVE%\ctl1.ora)
  353. DB_BLOCK_BUFFERS=1000
  354. DISTRIBUTED_LOCK_TIMEOUT=0
  355. DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME=0
  356. DISTRIBUTED_TRANSACTIONS=0
  357. GLOBAL_NAMES=TRUE
  358. LOG_ARCHIVE_DEST=%RDBMS70_ARCHIVE%\
  359. LOG_BUFFER=65536
  360. LOG_CHECKPOINT_INTERVAL=1000
  361. MAX_ENABLED_ROLES=8
  362. OPEN_LINKS=0
  363. PROCESSES=50
  364. ROW_LOCKING=ALWAYS
  365. SEQUENCE_CACHE_HASH_BUCKETS=10
  366. SORT_AREA_RETAINED_SIZE=262144
  367. SORT_AREA_SIZE=262144
  368. USER_DUMP_DEST=%RDBMS70%\trace
  369.  
  370. [CONFIGURATION_PSET_CONVERSION]
  371. VS__SUBLAYER=CONFIGURATION_NT 7.0 OWS Medium
  372. EDITED=2.0
  373.  
  374. [CONFIGURATION_NT 7.0 OWS Small]
  375. EDITED=2.0
  376. VS__SUBLAYER=CONFIGURATION_NT 7.0 OWS Medium
  377. VS__COMMENT=OWS Small Memory
  378. DB_BLOCK_BUFFERS=16
  379.  
  380. [CONFIGURATION_NT 7.0 OWS Large]
  381. EDITED=2.0
  382. VS__SUBLAYER=CONFIGURATION_NT 7.0 OWS Medium
  383. VS__COMMENT=OWS Large Memory
  384. DB_BLOCK_BUFFERS=4000
  385.  
  386. [CONFIGURATION_NT 7.1 OWS Medium]
  387. VS__SUBLAYER=CONFIGURATION__NT 7.1
  388. VS__COMMENT=OWS Medium Memory
  389. EDITED=2.0
  390. BACKGROUND_DUMP_DEST=%RDBMS71%\trace
  391. CONTROL_FILES=(%RDBMS71_CONTROL%\ctl1orcl.ora, %RDBMS71_ARCHIVE%\ctl1orcl.ora)
  392. DB_BLOCK_BUFFERS=1000
  393. DB_FILE_MULTIBLOCK_READ_COUNT=16
  394. DISTRIBUTED_LOCK_TIMEOUT=0
  395. DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME=0
  396. DISTRIBUTED_TRANSACTIONS=20
  397. GLOBAL_NAMES=TRUE
  398. LOG_ARCHIVE_DEST=%RDBMS71_ARCHIVE%\
  399. LOG_BUFFER=32768
  400. LOG_CHECKPOINT_INTERVAL=1000
  401. MAX_ENABLED_ROLES=8
  402. OPEN_LINKS=10
  403. PROCESSES=100
  404. ROW_LOCKING=ALWAYS
  405. SEQUENCE_CACHE_HASH_BUCKETS=23
  406. SNAPSHOT_REFRESH_PROCESSES=1
  407. SORT_AREA_RETAINED_SIZE=262144
  408. SORT_AREA_SIZE=262144
  409. USER_DUMP_DEST=%RDBMS71%\trace
  410. SHARED_POOL_SIZE=6000000
  411. DML_LOCKS=200
  412. LOG_BUFFER=32768
  413. SEQUENCE_CACHE_ENTRIES=10
  414.  
  415. [CONFIGURATION_NT 7.1 OWS Small]
  416. VS__SUBLAYER=CONFIGURATION_NT 7.1 OWS Medium
  417. VS__COMMENT=OWS Small Memory
  418. EDITED=2.0
  419. DB_FILE_MULTIBLOCK_READ_COUNT=8
  420. DB_BLOCK_BUFFERS=500
  421. SHARED_POOL_SIZE=3500000
  422. PROCESSES=50
  423. DML_LOCKS=100
  424. LOG_BUFFER=16384
  425. SEQUENCE_CACHE_ENTRIES=30
  426. SEQUENCE_CACHE_HASH_BUCKETS=10
  427.  
  428. [CONFIGURATION_NT 7.1 OWS Large]
  429. VS__SUBLAYER=CONFIGURATION_NT 7.1 OWS Medium
  430. VS__COMMENT=OWS Large Memory
  431. EDITED=2.0
  432. DB_FILE_MULTIBLOCK_READ_COUNT=32
  433. DB_BLOCK_BUFFERS=3200
  434. SHARED_POOL_SIZE=9000000
  435. PROCESSES=200
  436. DML_LOCKS=500
  437. LOG_BUFFER=65536
  438. SEQUENCE_CACHE_ENTRIES=100
  439. SEQUENCE_CACHE_HASH_BUCKETS=89
  440.  
  441. [CONFIGURATION_NT 7.1 O7S Medium]
  442. VS__SUBLAYER=CONFIGURATION__NT 7.1
  443. VS__COMMENT=Oracle7 Server Medium Memory
  444. EDITED=2.0
  445. BACKGROUND_DUMP_DEST=%RDBMS71%\trace
  446. CONTROL_FILES=(%RDBMS71_CONTROL%\ctl1orcl.ora, %RDBMS71_ARCHIVE%\ctl1orcl.ora)
  447. DB_BLOCK_BUFFERS=1000
  448. DB_FILE_MULTIBLOCK_READ_COUNT=16
  449. DISTRIBUTED_LOCK_TIMEOUT=0
  450. DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME=0
  451. DISTRIBUTED_TRANSACTIONS=20
  452. GLOBAL_NAMES=TRUE
  453. LOG_ARCHIVE_DEST=%RDBMS71_ARCHIVE%\
  454. LOG_BUFFER=32768
  455. LOG_CHECKPOINT_INTERVAL=1000
  456. MAX_ENABLED_ROLES=8
  457. OPEN_LINKS=10
  458. PROCESSES=100
  459. ROW_LOCKING=ALWAYS
  460. SEQUENCE_CACHE_HASH_BUCKETS=23
  461. SNAPSHOT_REFRESH_PROCESSES=1
  462. SORT_AREA_RETAINED_SIZE=262144
  463. SORT_AREA_SIZE=262144
  464. USER_DUMP_DEST=%RDBMS71%\trace
  465. SHARED_POOL_SIZE=6000000
  466. DML_LOCKS=200
  467. LOG_BUFFER=32768
  468. SEQUENCE_CACHE_ENTRIES=10
  469.  
  470. [CONFIGURATION_NT 7.1 O7S Small]
  471. VS__SUBLAYER=CONFIGURATION_NT 7.1 O7S Medium
  472. VS__COMMENT=Oracle7 Server Small Memory
  473. EDITED=2.0
  474. DB_FILE_MULTIBLOCK_READ_COUNT=8
  475. DB_BLOCK_BUFFERS=500
  476. SHARED_POOL_SIZE=3500000
  477. PROCESSES=50
  478. DML_LOCKS=100
  479. LOG_BUFFER=16384
  480. SEQUENCE_CACHE_ENTRIES=30
  481. SEQUENCE_CACHE_HASH_BUCKETS=10
  482.  
  483. [CONFIGURATION_NT 7.1 O7S Large]
  484. VS__SUBLAYER=CONFIGURATION_NT 7.1 O7S Medium
  485. VS__COMMENT=Oracle7 Server Large Memory
  486. EDITED=2.0
  487. DB_FILE_MULTIBLOCK_READ_COUNT=32
  488. DB_BLOCK_BUFFERS=3200
  489. SHARED_POOL_SIZE=9000000
  490. PROCESSES=200
  491. DML_LOCKS=500
  492. LOG_BUFFER=65536
  493. SEQUENCE_CACHE_ENTRIES=100
  494. SEQUENCE_CACHE_HASH_BUCKETS=89
  495.  
  496. [CONFIGURATION_Windows 7.1 No PL/SQL]
  497. VS__SUBLAYER=CONFIGURATION_Windows 7.1 PL/SQL
  498. EDITED=2.0
  499. DB_BLOCK_BUFFERS=200
  500. SHARED_POOL_SIZE=400000
  501.  
  502. [CONFIGURATION_Windows 7.1 PL/SQL]
  503. VS__SUBLAYER=CONFIGURATION__Windows 7.1
  504. EDITED=2.0
  505. BACKGROUND_DUMP_DEST=%RDBMS71%\trace
  506. DB_BLOCK_BUFFERS=400        
  507. db_file_multiblock_read_count=8
  508. distributed_lock_timeout=10 
  509. distributed_recovery_connection_hold_time=0
  510. distributed_transactions=10  
  511. dml_locks=100                
  512. log_archive_dest=%RDBMS71_ARCHIVE%
  513. log_buffer=65596
  514. log_checkpoint_interval=1000 
  515. max_dump_file_size=5120
  516. max_enabled_roles=8
  517. open_links=20                                             
  518. processes=50
  519. row_locking=ALWAYS                                                       
  520. sequence_cache_hash_buckets=10
  521. sort_area_retained_size=262144
  522. sort_area_size=262144
  523. user_dump_dest=%RDBMS71%\trace
  524.  
  525. [CONFIGURATION_Windows 7.1 Default]
  526. VS__SUBLAYER=CONFIGURATION__Windows 7.1
  527. EDITED=2.0
  528. BACKGROUND_DUMP_DEST=%RDBMS71%\trace
  529. log_archive_dest=%RDBMS71_ARCHIVE%
  530. user_dump_dest=%RDBMS71%\trace
  531.  
  532. [CONFIGURATION__Solaris 7.1]
  533. VS__SERVER_VERSION=Solaris 7.1
  534. VS__REQUIRED=CONTROL_FILES,DB_NAME
  535. VS__COMMENT=Solaris 7.1 Database Default
  536. EDITED=2.0
  537. ASYNC_READ=TRUE
  538. ASYNC_WRITE=TRUE
  539. AUDIT_FILE_DEST=?/rdbms/audit
  540. BACKGROUND_DUMP_DEST=?/rdbms/log
  541. BLANK_TRIMMING=FALSE
  542. CACHE_SIZE_THRESHOLD=3
  543. CCF_IO_SIZE=65536
  544. CHECKPOINT_PROCESS=FALSE
  545. CLEANUP_ROLLBACK_ENTRIES=20
  546. CLOSE_CACHED_OPEN_CURSORS=FALSE
  547. COMMIT_POINT_STRENGTH=1
  548. COMPATIBLE=
  549. COMPATIBLE_NO_RECOVERY=
  550. CONTROL_FILES=(?/dbs/cntrl@.dbf)
  551. CORE_DUMP_DEST=?/dbs
  552. CURSOR_SPACE_FOR_TIME=FALSE
  553. DB_BLOCK_BUFFERS=32
  554. DB_BLOCK_CHECKPOINT_BATCH=8
  555. DB_BLOCK_LRU_EXTENDED_STATISTICS=0
  556. DB_BLOCK_LRU_STATISTICS=FALSE
  557. DB_BLOCK_SIZE=2048
  558. DB_DOMAIN=WORLD
  559. DB_FILE_MULTIBLOCK_READ_COUNT=4
  560. DB_FILE_SIMULTANEOUS_WRITES=4
  561. DB_FILES=30
  562. DB_NAME=OWS
  563. DB_WRITERS=1
  564. DB_LINK_ENCRYPT_LOGIN=FALSE
  565. DISCRETE_TRANSACTIONS_ENABLED=FALSE
  566. DISTRIBUTED_LOCK_TIMEOUT=60
  567. DISTRIBUTED_RECOVERY_CONNECTION_HOLD=200
  568. DISTRIBUTED_TRANSACTIONS=8
  569. DML_LOCKS=140
  570. ENQUEUE_RESOURCES=160
  571. EVENT=
  572. FIXED_DATE=
  573. GC_DB_LOCKS=32
  574. GC_FILES_TO_LOCKS=
  575. GC_LCK_PROCS=1
  576. GC_ROLLBACK_LOCKS=20
  577. GC_ROLLBACK_SEGMENTS=20
  578. GC_SAVE_ROLLBACK_LOCKS=20
  579. GC_SEGMENTS=10
  580. GC_TABLESPACES=5
  581. GLOBAL_NAMES=FALSE
  582. IFILE=
  583. INSTANCE_NUMBER=0
  584. JOB_QUEUE_INTERVAL=60
  585. JOB_QUEUE_KEEP_CONNECTIONS=FALSE
  586. JOB_QUEUE_PROCESSES=0
  587. LICENSE_MAX_SESSIONS=0
  588. LICENSE_MAX_USERS=0
  589. LICENSE_SESSIONS_WARNING=O
  590. LOG_ARCHIVE_BUFFER_SIZE=64
  591. LOG_ARCHIVE_BUFFERS=4
  592. LOG_ARCHIVE_DEST=?/dbs/arch
  593. LOG_ARCHIVE_FORMAT=%t_%s.dbf
  594. LOG_ARCHIVE_START=FALSE
  595. LOG_BUFFER=32768
  596. LOG_CHECKPOINT_INTERVAL=8000
  597. LOG_CHECKPOINT_TIMEOUT=0
  598. LOG_CHECKPOINTS_TO_ALERT=FALSE
  599. LOG_FILES=255
  600. LOG_SIMULTANEOUS_COPIES=0
  601. LOG_SMALL_ENTRY_MAX_SIZE=800
  602. MAX_COMMIT_PROPAGATION_DELAY=90000
  603. MAX_DUMP_FILE_SIZE=500
  604. MAX_ENABLED_ROLES=20
  605. MAX_ROLLBACK_SEGMENTS=30
  606. MTS_DISPATCHERS=
  607. MTS_LISTENER_ADDRESS=(address=(protocol=ipc)(key=%s))
  608. MTS_MAX_DISPATCHERS=0
  609. MTS_MAX_SERVERS=0
  610. MTS_SERVERS=0
  611. MTS_SERVICE=
  612. NLS_CURRENCY=
  613. NLS_DATE_FORMAT=
  614. NLS_DATE_LANGUAGE=
  615. NLS_ISO_CURRENCY=
  616. NLS_LANGUAGE=AMERICAN
  617. NLS_NUMERIC_CHARACTERS=
  618. NLS_SORT=
  619. NLS_TERRITORY=AMERICA
  620. OPEN_CURSORS=50
  621. OPEN_LINKS=4
  622. OPTIMIZER_COMP_WEIGHT=0
  623. OPTIMIZER_MODE=CHOOSE
  624. OS_AUTHENT_PREFIX=ops$
  625. OS_ROLES=FALSE
  626. PARALLEL_DEFAULT_MAX_INSTANCES=0
  627. PARALLEL_DEFAULT_MAX_SCANS=0
  628. PARALLEL_DEFAULT_SCANSIZE=100
  629. PARALLEL_MAX_SERVERS=5
  630. PARALLEL_MIN_SERVERS=0
  631. PARALLEL_SERVER_IDLE_TIME=5
  632. PRE_PAGE_SGA=FALSE
  633. PROCESSES=25
  634. RECOVERY_PARALLELISM=0
  635. REDUCE_ALARM=FALSE
  636. REMOTE_LOGIN_PASSWORDFILE=NONE
  637. REMOTE_OS_AUTHENT=FALSE
  638. REMOTE_OS_ROLES=FALSE
  639. RESOURCE_LIMIT=FALSE
  640. ROLLBACK_SEGMENTS=
  641. ROW_CACHE_CURSORS=10
  642. ROW_LOCKING=default
  643. SEQUENCE_CACHE_ENTRIES=10
  644. SEQUENCE_CACHE_HASH_BUCKETS=7
  645. SERIALIZABLE=FALSE
  646. SESSION_CACHED_CURSORS=0
  647. SESSIONS=32
  648. SHARED_POOL_SIZE=3500000
  649. SINGLE_PROCESS=FALSE
  650. SNAPSHOT_REFRESH_INTERVAL=60
  651. SNAPSHOT_REFRESH_KEEP_CONNECTIONS=FALSE
  652. SNAPSHOT_REFRESH_PROCESSES=0
  653. SORT_AREA_RETAINED_SIZE=65536
  654. SORT_AREA_SIZE=65536
  655. SORT_MTS_BUFFER_FOR_FETCH_SIZE=0
  656. SORT_READ_FAC=5
  657. SORT_SPACEMAP_SIZE=512
  658. SPIN_COUNT=200
  659. SQL92_SECURITY=FALSE
  660. SQL_TRACE=FALSE
  661. TEMPORARY_TABLE_LOCKS=32
  662. THREAD=0
  663. TIMED_STATISTICS=FALSE
  664. TRANSACTIONS=35
  665. TRANSACTIONS_PER_ROLLBACK_SEGMENT=16
  666. USE_ISM=TRUE
  667. USE_READV=FALSE
  668. USER_DUMP_DEST=?/rdbms/log
  669.  
  670. [CONFIGURATION_Solaris 7.1 OWS Small]
  671. VS__SUBLAYER=CONFIGURATION__Solaris 7.1
  672. VS__COMMENT=OWS Small Memory
  673. EDITED=2.0
  674. DB_FILES=20
  675. DB_FILE_MULTIBLOCK_READ_COUNT=16
  676. DB_BLOCK_BUFFERS=550
  677. SHARED_POOL_SIZE=3500000
  678. LOG_CHECKPOINT_INTERVAL=10000
  679. PROCESSES=50
  680. DML_LOCKS=100
  681. LOG_BUFFER=32768
  682. SEQUENCE_CACHE_ENTRIES=10
  683. SEQUENCE_CACHE_HASH_BUCKETS=10
  684. MAX_DUMP_FILE_SIZE=10240
  685.  
  686. [CONFIGURATION_Solaris 7.1 OWS Medium]
  687. VS__SUBLAYER=CONFIGURATION_Solaris 7.1 OWS Small
  688. VS__COMMENT=OWS Medium Memory
  689. EDITED=2.0
  690. DB_BLOCK_BUFFERS=1000
  691. SHARED_POOL_SIZE=6000000
  692. DML_LOCKS=200
  693. SEQUENCE_CACHE_ENTRIES=30
  694. SEQUENCE_CACHE_HASH_BUCKETS=23
  695.  
  696. [CONFIGURATION_Solaris 7.1 OWS Large]
  697. VS__SUBLAYER=CONFIGURATION_Solaris 7.1 OWS Small
  698. VS__COMMENT=OWS Large Memory
  699. EDITED=2.0
  700. DB_FILE_MULTIBLOCK_READ_COUNT=32
  701. DB_BLOCK_BUFFERS=3200
  702. SHARED_POOL_SIZE=9000000
  703. DML_LOCKS=500
  704. LOG_BUFFER=163840
  705. SEQUENCE_CACHE_ENTRIES=100
  706. SEQUENCE_CACHE_HASH_BUCKETS=89
  707.  
  708. [CONFIGURATION__HP-UX 7.1]
  709. VS__SERVER_VERSION=HP-UX 7.1
  710. VS__REQUIRED=CONTROL_FILES,DB_NAME
  711. VS__COMMENT=HP-UX 7.1 Database Default
  712. VS__SUBLAYER=CONFIGURATION__Solaris 7.1
  713. EDITED=2.0
  714. CONTROL_FILES=(?/dbs/ctrl1@.ctl, ?/dbs/ctrl2@.ctl, ?/dbs/ctrl3@.ctl)
  715. REMOTE_LOGIN_PASSWORDFILE=exclusive
  716.  
  717. [CONFIGURATION_HP-UX 7.1 OWS Small]
  718. VS__SUBLAYER=CONFIGURATION__HP-UX 7.1
  719. VS__COMMENT=OWS Small Memory
  720. EDITED=2.0
  721. DB_FILES=20
  722. DB_FILE_MULTIBLOCK_READ_COUNT=16
  723. DB_BLOCK_BUFFERS=550
  724. SHARED_POOL_SIZE=3500000
  725. LOG_CHECKPOINT_INTERVAL=10000
  726. PROCESSES=50
  727. DML_LOCKS=100
  728. LOG_BUFFER=32768
  729. SEQUENCE_CACHE_ENTRIES=10
  730. SEQUENCE_CACHE_HASH_BUCKETS=10
  731. MAX_DUMP_FILE_SIZE=10240
  732.  
  733. [CONFIGURATION_HP-UX 7.1 OWS Medium]
  734. VS__SUBLAYER=CONFIGURATION_HP-UX 7.1 OWS Small
  735. VS__COMMENT=OWS Medium Memory
  736. EDITED=2.0
  737. DB_BLOCK_BUFFERS=1000
  738. SHARED_POOL_SIZE=6000000
  739. DML_LOCKS=200
  740. SEQUENCE_CACHE_ENTRIES=30
  741. SEQUENCE_CACHE_HASH_BUCKETS=23
  742.  
  743. [CONFIGURATION_HP-UX 7.1 OWS Large]
  744. VS__SUBLAYER=CONFIGURATION_HP-UX 7.1 OWS Small
  745. VS__COMMENT=OWS Large Memory
  746. EDITED=2.0
  747. DB_FILE_MULTIBLOCK_READ_COUNT=32
  748. DB_BLOCK_BUFFERS=3200
  749. SHARED_POOL_SIZE=9000000
  750. DML_LOCKS=500
  751. LOG_BUFFER=163840
  752. SEQUENCE_CACHE_ENTRIES=100
  753. SEQUENCE_CACHE_HASH_BUCKETS=89
  754.  
  755. [CONFIGURATION__Netware 7.1]
  756. VS__SUBLAYER=CONFIGURATION__NT 7.1
  757. VS__SERVER_VERSION=Netware 7.1
  758. VS__COMMENT=Netware Default
  759. VS__REQUIRED=CONTROL_FILES,DB_NAME,REMOTE_LOGIN_PASSWORDFILE
  760. VS__DISALLOWED=INIT_SQL_FILES,SMALL_TABLE_THRESHOLD
  761. EDITED=2.0
  762. CONTROL_FILES=%RDBMS71%\CTL1%ORACLE_SID%.ORA
  763. DB_BLOCK_SIZE=4096
  764. LOG_ARCHIVE_BUFFER_SIZE=32
  765. SORT_AREA_RETAINED_SIZE=16384
  766. SORT_AREA_SIZE=16384
  767. TRANSACTIONS_PER_ROLLBACK_SEGMENT=38
  768. GC_LCK_PROCS=1
  769. GC_DB_LOCKS=32
  770. GC_ROLLBACK_LOCKS=20
  771. GC_SAVE_ROLLBACK_LOCKS=20
  772. GC_FILES_TO_LOCKS=
  773. INSTANCE_NUMBER=0
  774. SESSION_CACHED_CURSORS=0
  775. REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
  776.  
  777. [CONFIGURATION_Netware 7.1 OWS Small]
  778. VS__SUBLAYER=CONFIGURATION__Netware 7.1
  779. VS__COMMENT=OWS Small Memory
  780. EDITED=2.0
  781. CONTROL_FILES=%oracle_home%\database\wgctl.ora
  782. DB_BLOCK_SIZE=2048
  783. BACKGROUND_DUMP_DEST=%RDBMS71%\trace
  784. DB_BLOCK_BUFFERS=200
  785. DB_FILES=20
  786. DB_FILE_MULTIBLOCK_READ_COUNT=8
  787. DML_LOCKS=100
  788. LOG_BUFFER=8192
  789. LOG_CHECKPOINT_INTERVAL=10000
  790. MAX_DUMP_FILE_SIZE=10240
  791. PROCESSES=50
  792. SEQUENCE_CACHE_ENTRIES=10
  793. SEQUENCE_CACHE_HASH_BUCKETS=10
  794. SHARED_POOL_SIZE=3500000
  795. USER_DUMP_DEST=%RDBMS71%\trace
  796.  
  797. [CONFIGURATION_Netware 7.1 OWS Medium]
  798. VS__SUBLAYER=CONFIGURATION_Netware 7.1 OWS Small
  799. VS__COMMENT=OWS Medium Memory
  800. EDITED=2.0
  801. DB_BLOCK_BUFFERS=550
  802. DB_FILE_MULTIBLOCK_READ_COUNT=16
  803. DML_LOCKS=200
  804. LOG_BUFFER=32768
  805. PROCESSES=100
  806. SEQUENCE_CACHE_ENTRIES=30
  807. SEQUENCE_CACHE_HASH_BUCKETS=23
  808. SHARED_POOL_SIZE=6000000
  809.  
  810. [CONFIGURATION_Netware 7.1 OWS Large]
  811. VS__SUBLAYER=CONFIGURATION_Netware 7.1 OWS Small
  812. VS__COMMENT=OWS Large Memory
  813. EDITED=2.0
  814. DB_BLOCK_BUFFERS=3200
  815. DB_FILE_MULTIBLOCK_READ_COUNT=32
  816. DML_LOCKS=500
  817. LOG_BUFFER=163840
  818. PROCESSES=200
  819. SEQUENCE_CACHE_ENTRIES=100
  820. SEQUENCE_CACHE_HASH_BUCKETS=89
  821. SHARED_POOL_SIZE=9000000
  822.  
  823. [CONFIGURATION__SCO 7.1]
  824. VS__SERVER_VERSION=SCO 7.1
  825. VS__REQUIRED=CONTROL_FILES,DB_NAME
  826. VS__COMMENT=SCO 7.1 Database Default
  827. EDITED=2.0
  828. ASYNC_WRITE=FALSE
  829. AUDIT_FILE_DEST=?/rdbms/audit
  830. AUDIT_TRAIL=NONE
  831. BACKGROUND_CORE_DUMP=FULL
  832. BACKGROUND_DUMP_DEST=?/rdbms/log
  833. BLANK_TRIMMING=FALSE
  834. CACHE_SIZE_THRESHOLD=3
  835. CCF_IO_SIZE=8388608
  836. CHECKPOINT_PROCESS=FALSE
  837. CLEANUP_ROLLBACK_ENTRIES=20
  838. CLOSE_CACHED_OPEN_CURSORS=FALSE
  839. COMMIT_POINT_STRENGTH=1
  840. COMPATIBLE=
  841. COMPATIBLE_NO_RECOVERY=
  842. CONTROL_FILES=?/dbs/cntrl@.dbf
  843. CORE_DUMP_DEST=?/dbs
  844. CURSOR_SPACE_FOR_TIME=FALSE
  845. DB_BLOCK_BUFFERS=32
  846. DB_BLOCK_CHECKPOINT_BATCH=8
  847. DB_BLOCK_LRU_EXTENDED_STATISTICS=0
  848. DB_BLOCK_LRU_STATISTICS=FALSE
  849. DB_BLOCK_SIZE=2048
  850. DB_DOMAIN=WORLD
  851. DB_FILE_MULTIBLOCK_READ_COUNT=4
  852. DB_FILE_SIMULTANEOUS_WRITES=4
  853. DB_FILES=254
  854. DB_NAME=
  855. DB_WRITERS=1
  856. DBLINK_ENCRYPT_LOGIN=FALSE
  857. DISCRETE_TRANSACTIONS_ENABLED=FALSE
  858. DISTRIBUTED_LOCK_TIMEOUT=60
  859. DISTRIBUTED_RECOVERY_CONNECTION_HOLD=200
  860. DISTRIBUTED_TRANSACTIONS=8
  861. DML_LOCKS=140
  862. ENQUEUE_RESOURCES=160
  863. EVENT=
  864. FIXED_DATE=
  865. GC_DB_LOCKS=32
  866. GC_FILES_TO_LOCKS=
  867. GC_LCK_PROCS=1
  868. GC_ROLLBACK_LOCKS=20
  869. GC_ROLLBACK_SEGMENTS=20
  870. GC_SAVE_ROLLBACK_LOCKS=20
  871. GC_SEGMENTS=10
  872. GC_TABLESPACES=5
  873. GLOBAL_NAMES=FALSE
  874. IFILE=
  875. INSTANCE_NUMBER=0
  876. JOB_QUEUE_INTERVAL=60
  877. JOB_QUEUE_KEEP_CONNECTIONS=FALSE
  878. JOB_QUEUE_PROCESSES=0
  879. LICENSE_MAX_SESSIONS=0
  880. LICENSE_MAX_USERS=0
  881. LICENSE_SESSIONS_WARNING=0
  882. LOG_ARCHIVE_BUFFER_SIZE=16
  883. LOG_ARCHIVE_BUFFERS=4
  884. LOG_ARCHIVE_DEST=?/dbs/arch
  885. LOG_ARCHIVE_FORMAT=%t_%s.dbf
  886. LOG_ARCHIVE_START=FALSE
  887. LOG_BUFFER=32768
  888. LOG_CHECKPOINT_INTERVAL=2000
  889. LOG_CHECKPOINT_TIMEOUT=0
  890. LOG_CHECKPOINTS_TO_ALERT=FALSE
  891. LOG_FILES=255
  892. LOG_SIMULTANEOUS_COPIES=0
  893. LOG_SMALL_ENTRY_MAX_SIZE=800
  894. MAX_BACKOFF=0
  895. MAX_COMMIT_PROPAGATION_DELAY=90000
  896. MAX_DUMP_FILE_SIZE=500
  897. MAX_ENABLED_ROLES=20
  898. MAX_ROLLBACK_SEGMENTS=30
  899. MTS_DISPATCHERS=
  900. MTS_LISTENER_ADDRESS=(address=(protocol=ipc)(key=%s))
  901. MTS_MAX_DISPATCHERS=0
  902. MTS_MAX_SERVERS=0
  903. MTS_SERVERS=0
  904. MTS_SERVICE=
  905. NLS_CURRENCY=
  906. NLS_DATE_FORMAT=
  907. NLS_DATE_LANGUAGE=
  908. NLS_ISO_CURRENCY=
  909. NLS_LANGUAGE=AMERICAN
  910. NLS_NUMERIC_CHARACTERS=
  911. NLS_SORT=
  912. NLS_TERRITORY=AMERICA
  913. OPEN_CURSORS=50
  914. OPEN_LINKS=4
  915. OPTIMIZER_COMP_WEIGHT=0
  916. OPTIMIZER_MODE=CHOOSE
  917. OS_AUTHENT_PREFIX=ops$
  918. OS_ROLES=FALSE
  919. PARALLEL_DEFAULT_MAX_INSTANCES=0
  920. PARALLEL_DEFAULT_MAX_SCANS=0
  921. PARALLEL_DEFAULT_SCANSIZE=100
  922. PARALLEL_MAX_SERVERS=5
  923. PARALLEL_MIN_SERVERS=0
  924. PARALLEL_SERVER_IDLE_TIME=5
  925. POST_WAIT_DEVICE=?/dbs/pw_@.ora
  926. PRE_PAGE_SGA=FALSE
  927. PROCESSES=25
  928. RECOVERY_PARALLELISM=0
  929. REMOTE_LOGIN_PASSWORDFILE=NONE
  930. REMOTE_OS_AUTHENT=FALSE
  931. REMOTE_OS_ROLES=FALSE
  932. RESOURCE_LIMIT=FALSE
  933. ROLLBACK_SEGMENTS=
  934. ROW_CACHE_CURSORS=10
  935. ROW_LOCKING=default
  936. SEQUENCE_CACHE_ENTRIES=10
  937. SEQUENCE_CACHE_HASH_BUCKETS=7
  938. SERIALIZABLE=FALSE
  939. SESSION_CACHED_CURSORS=0
  940. SESSIONS=32
  941. SHADOW_CORE_DUMP=FULL
  942. SHARED_POOL_SIZE=3500000
  943. SINGLE_PROCESS=FALSE
  944. SNAPSHOT_REFRESH_INTERVAL=60
  945. SNAPSHOT_REFRESH_KEEP_CONNECTIONS=FALSE
  946. SNAPSHOT_REFRESH_PROCESSES=0
  947. SORT_AREA_RETAINED_SIZE=65536
  948. SORT_AREA_SIZE=65536
  949. SORT_MTS_BUFFER_FOR_FETCH_SIZE=0
  950. SORT_READ_FAC=5
  951. SORT_SPACEMAP_SIZE=512
  952. SQL92_SECURITY=FALSE
  953. SQL_TRACE=FALSE
  954. TEMPORARY_TABLE_LOCKS=32
  955. THREAD=0
  956. TIMED_STATISTICS=FALSE
  957. TRANSACTIONS=35
  958. TRANSACTIONS_PER_ROLLBACK_SEGMENT=16
  959. USE_POST_WAIT_DRIVER=FALSE
  960. USER_DUMP_DEST=?/rdbms/log
  961.  
  962. [CONFIGURATION_SCO 7.1 OWS Small]
  963. VS__SUBLAYER=CONFIGURATION__SCO 7.1
  964. VS__COMMENT=OWS Small Memory
  965. EDITED=2.0
  966. DB_FILE_MULTIBLOCK_READ_COUNT=8
  967. DB_BLOCK_BUFFERS=200
  968. SHARED_POOL_SIZE=3500000
  969. PROCESSES=50
  970. DML_LOCKS=100
  971. LOG_BUFFER=8192
  972. SEQUENCE_CACHE_ENTRIES=10
  973. SEQUENCE_CACHE_HASH_BUCKETS=10
  974.  
  975. [CONFIGURATION_SCO 7.1 OWS Medium]
  976. VS__SUBLAYER=CONFIGURATION_SCO 7.1 OWS Small
  977. VS__COMMENT=OWS Medium Memory
  978. EDITED=2.0
  979. DB_FILE_MULTIBLOCK_READ_COUNT=16
  980. DB_BLOCK_BUFFERS=550
  981. SHARED_POOL_SIZE=6000000
  982. PROCESSES=100
  983. DML_LOCKS=200
  984. LOG_BUFFER=32768
  985. SEQUENCE_CACHE_ENTRIES=30
  986. SEQUENCE_CACHE_HASH_BUCKETS=23
  987.  
  988. [CONFIGURATION_SCO 7.1 OWS Large]
  989. VS__SUBLAYER=CONFIGURATION_SCO 7.1 OWS Small
  990. VS__COMMENT=OWS Large Memory
  991. EDITED=2.0
  992. DB_FILE_MULTIBLOCK_READ_COUNT=32
  993. DB_BLOCK_BUFFERS=3200
  994. SHARED_POOL_SIZE=9000000
  995. PROCESSES=200
  996. DML_LOCKS=500
  997. LOG_BUFFER=163840
  998. SEQUENCE_CACHE_ENTRIES=100
  999. SEQUENCE_CACHE_HASH_BUCKETS=89
  1000.  
  1001. [CONFIGURATION__UnixWare 7.1]
  1002. VS__SERVER_VERSION=UnixWare 7.1
  1003. VS__REQUIRED=CONTROL_FILES,DB_NAME
  1004. VS__COMMENT=UnixWare 7.1 Database Default
  1005. EDITED=2.0
  1006. AUDIT_FILE_DEST=?/rdbms/audit
  1007. AUDIT_TRAIL=NONE
  1008. BACKGROUND_CORE_DUMP=FULL
  1009. BACKGROUND_DUMP_DEST=?/rdbms/log
  1010. BLANK_TRIMMING=FALSE
  1011. CACHE_SIZE_THRESHOLD=3
  1012. CCF_IO_SIZE=32768
  1013. CHECKPOINT_PROCESS=FALSE
  1014. CLEANUP_ROLLBACK_ENTRIES=20
  1015. CLOSE_CACHED_OPEN_CURSORS=FALSE
  1016. COMMIT_POINT_STRENGTH=1
  1017. COMPATIBLE=
  1018. COMPATIBLE_NO_RECOVERY=
  1019. CONTROL_FILES=?/dbs/cntrl@.dbf
  1020. CORE_DUMP_DEST=?/dbs
  1021. CURSOR_SPACE_FOR_TIME=FALSE
  1022. DB_BLOCK_BUFFERS=32
  1023. DB_BLOCK_CHECKPOINT_BATCH=8
  1024. DB_BLOCK_LRU_EXTENDED_STATISTICS=0
  1025. DB_BLOCK_LRU_STATISTICS=FALSE
  1026. DB_BLOCK_SIZE=2048
  1027. DB_DOMAIN=WORLD
  1028. DB_FILE_MULTIBLOCK_READ_COUNT=4
  1029. DB_FILE_SIMULTANEOUS_WRITES=4
  1030. DB_FILES=30
  1031. DB_NAME=
  1032. DB_WRITERS=1
  1033. DBLINK_ENCRYPT_LOGIN=FALSE
  1034. DISCRETE_TRANSACTIONS_ENABLED=FALSE
  1035. DISTRIBUTED_LOCK_TIMEOUT=60
  1036. DISTRIBUTED_RECOVERY_CONNECTION_HOLD=200
  1037. DISTRIBUTED_TRANSACTIONS=8
  1038. DML_LOCKS=140
  1039. ENQUEUE_RESOURCES=160
  1040. EVENT=
  1041. FIXED_DATE=
  1042. GC_DB_LOCKS=32
  1043. GC_FILES_TO_LOCKS=
  1044. GC_LCK_PROCS=1
  1045. GC_ROLLBACK_LOCKS=20
  1046. GC_ROLLBACK_SEGMENTS=20
  1047. GC_SAVE_ROLLBACK_LOCKS=20
  1048. GC_SEGMENTS=10
  1049. GC_TABLESPACES=5
  1050. GLOBAL_NAMES=FALSE
  1051. IFILE=
  1052. INSTANCE_NUMBER=0
  1053. JOB_QUEUE_INTERVAL=60
  1054. JOB_QUEUE_KEEP_CONNECTIONS=FALSE
  1055. JOB_QUEUE_PROCESSES=0
  1056. LGWR_USE_ASYNC_IO=FALSE
  1057. LICENSE_MAX_SESSIONS=0
  1058. LICENSE_MAX_USERS=0
  1059. LICENSE_SESSIONS_WARNING=0
  1060. LOG_ARCHIVE_BUFFER_SIZE=16
  1061. LOG_ARCHIVE_BUFFERS=4
  1062. LOG_ARCHIVE_DEST=?/dbs/arch
  1063. LOG_ARCHIVE_FORMAT=%t_%s.dbf
  1064. LOG_ARCHIVE_START=FALSE
  1065. LOG_BUFFER=32768
  1066. LOG_CHECKPOINT_INTERVAL=2000
  1067. LOG_CHECKPOINT_TIMEOUT=0
  1068. LOG_CHECKPOINTS_TO_ALERT=FALSE
  1069. LOG_FILES=255
  1070. LOG_SIMULTANEOUS_COPIES=0
  1071. LOG_SMALL_ENTRY_MAX_SIZE=800
  1072. MAX_COMMIT_PROPAGATION_DELAY=90000
  1073. MAX_DUMP_FILE_SIZE=500
  1074. MAX_ENABLED_ROLES=20
  1075. MAX_ROLLBACK_SEGMENTS=30
  1076. MTS_DISPATCHERS=
  1077. MTS_LISTENER_ADDRESS=(address=(protocol=ipc)(key=%s))
  1078. MTS_MAX_DISPATCHERS=0
  1079. MTS_MAX_SERVERS=0
  1080. MTS_SERVERS=0
  1081. MTS_SERVICE=
  1082. NLS_CURRENCY=
  1083. NLS_DATE_FORMAT=
  1084. NLS_DATE_LANGUAGE=
  1085. NLS_ISO_CURRENCY=
  1086. NLS_LANGUAGE=AMERICAN
  1087. NLS_NUMERIC_CHARACTERS=
  1088. NLS_SORT=
  1089. NLS_TERRITORY=AMERICA
  1090. OPEN_CURSORS=50
  1091. OPEN_LINKS=4
  1092. OPTIMIZER_COMP_WEIGHT=0
  1093. OPTIMIZER_MODE=CHOOSE
  1094. OS_AUTHENT_PREFIX=ops$
  1095. OS_ROLES=FALSE
  1096. PARALLEL_DEFAULT_MAX_INSTANCES=0
  1097. PARALLEL_DEFAULT_MAX_SCANS=0
  1098. PARALLEL_DEFAULT_SCANSIZE=100
  1099. PARALLEL_MAX_SERVERS=5
  1100. PARALLEL_MIN_SERVERS=0
  1101. PARALLEL_SERVER_IDLE_TIME=5
  1102. POST_WAIT_DEVICE=?/dbs/pw_@.ora
  1103. PRE_PAGE_SGA=FALSE
  1104. PROCESSES=25
  1105. RECOVERY_PARALLELISM=0
  1106. REDUCE_ALARM=FALSE
  1107. REMOTE_LOGIN_PASSWORDFILE=NONE
  1108. REMOTE_OS_AUTHENT=FALSE
  1109. REMOTE_OS_ROLES=FALSE
  1110. RESOURCE_LIMIT=FALSE
  1111. ROLLBACK_SEGMENTS=
  1112. ROW_CACHE_CURSORS=10
  1113. ROW_LOCKING=default
  1114. SEQUENCE_CACHE_ENTRIES=10
  1115. SEQUENCE_CACHE_HASH_BUCKETS=7
  1116. SERIALIZABLE=FALSE
  1117. SESSION_CACHED_CURSORS=0
  1118. SESSIONS=32
  1119. SHADOW_CORE_DUMP=FULL
  1120. SHARED_POOL_SIZE=3500000
  1121. SINGLE_PROCESS=FALSE
  1122. SNAPSHOT_REFRESH_INTERVAL=60
  1123. SNAPSHOT_REFRESH_KEEP_CONNECTIONS=FALSE
  1124. SNAPSHOT_REFRESH_PROCESSES=0
  1125. SORT_AREA_RETAINED_SIZE=65536
  1126. SORT_AREA_SIZE=65536
  1127. SORT_MTS_BUFFER_FOR_FETCH_SIZE=0
  1128. SORT_READ_FAC=5
  1129. SORT_SPACEMAP_SIZE=512
  1130. SPIN_COUNT=0
  1131. SQL92_SECURITY=FALSE
  1132. SQL_TRACE=FALSE
  1133. TEMPORARY_TABLE_LOCKS=32
  1134. THREAD=0
  1135. TIMED_STATISTICS=FALSE
  1136. TRANSACTIONS=35
  1137. TRANSACTIONS_PER_ROLLBACK_SEGMENT=16
  1138. USE_ASYNC_IO=FALSE
  1139. USE_POST_WAIT_DRIVER=FALSE
  1140. USE_READV=FALSE
  1141. USER_DUMP_DEST=?/rdbms/log
  1142.  
  1143. [CONFIGURATION_UnixWare 7.1 OWS Small]
  1144. VS__SUBLAYER=CONFIGURATION__UnixWare 7.1
  1145. VS__COMMENT=OWS Small Memory
  1146. EDITED=2.0
  1147. DB_FILE_MULTIBLOCK_READ_COUNT=8
  1148. DB_BLOCK_BUFFERS=200
  1149. SHARED_POOL_SIZE=3500000
  1150. PROCESSES=50
  1151. DML_LOCKS=100
  1152. LOG_BUFFER=8192
  1153. SEQUENCE_CACHE_ENTRIES=10
  1154. SEQUENCE_CACHE_HASH_BUCKETS=10
  1155.  
  1156. [CONFIGURATION_UnixWare 7.1 OWS Medium]
  1157. VS__SUBLAYER=CONFIGURATION_UnixWare 7.1 OWS Small
  1158. VS__COMMENT=OWS Medium Memory
  1159. EDITED=2.0
  1160. DB_FILE_MULTIBLOCK_READ_COUNT=16
  1161. DB_BLOCK_BUFFERS=550
  1162. SHARED_POOL_SIZE=6000000
  1163. PROCESSES=100
  1164. DML_LOCKS=200
  1165. LOG_BUFFER=32768
  1166. SEQUENCE_CACHE_ENTRIES=30
  1167. SEQUENCE_CACHE_HASH_BUCKETS=23
  1168.  
  1169. [CONFIGURATION_UnixWare 7.1 OWS Large]
  1170. VS__SUBLAYER=CONFIGURATION_UnixWare 7.1 OWS Small
  1171. VS__COMMENT=OWS Large Memory
  1172. EDITED=2.0
  1173. DB_FILE_MULTIBLOCK_READ_COUNT=32
  1174. DB_BLOCK_BUFFERS=3200
  1175. SHARED_POOL_SIZE=9000000
  1176. PROCESSES=200
  1177. DML_LOCKS=500
  1178. LOG_BUFFER=163840
  1179. SEQUENCE_CACHE_ENTRIES=100
  1180. SEQUENCE_CACHE_HASH_BUCKETS=89
  1181.