6
(Test Files) 35.25 water
8
llx lly 12 add translate
10
/x0 x v get 4.431713 add sx cw mul add store
11
/y0 y v get bfs th add sub store
14
0 T (##############################################################################) N
15
0 T (# Example INIT.ORA ) S
25
( Oracle Corporation ) p
27
( help you customize) p n
28
0 T (# your RDBMS installation ) S
30
( your site. Important ) p
33
0 T (# are discussed, ) S
35
( example settings given.) p n
39
( parameter settings are ) p
50
( parameters that require different ) p
57
(# installations, three scenarios have been provided: SMALL, MEDIUM) p n
62
( parameter that needs ) p
64
( be tuned according ) p
69
( will have three settings, ) p
84
( approximate the SGA ) p
89
0 T (# three scenarious provided ) S
96
(-------Installation/Database Size------) c n
98
(# SMALL MEDIUM LARGE) p n
101
( 2K 4500K 6800K 17000K) p n
104
( 4K 5500K 8800K 21000K) p n
112
( that multiple instances will be ) p
119
(-specific parameters ) p
132
( these files point ) p
138
( the IFILE command.) p n
146
(# parameter, it will automatically ) p
152
( instances. This ) p
155
(# necessary, since ) p
164
(30) # (# parameters. ) S
177
0 T (# these must be specified ) S
179
( different files, but since ) p
182
0 T (# parameters must be the same ) S
186
( instances, they should be ) p
192
0 T (# INSTRUCTIONS: Edit this ) S
196
( the other INIT files it calls ) p
199
(# your site, either ) p
214
( place an IFILE= line ) p
228
0 T (###############################################################################) N
230
(40) # (db_name = oracle) N
231
0 T (db_files = 20) N
232
0 T (control_files = \(%RDBMS_FILES%\\ctl1orcl.ora\)) N
234
0 T (compatible = 7.3.0.0.0) N
236
0 T (db_file_multiblock_read_count = 8) S 40 T () S 48 T () S 56 T () S 64 T ( # ) S
239
(# db_file_multiblock_read_count = 8 # SMALL) p n
240
0 T (# db_file_multiblock_read_count = 16 # MEDIUM) N
241
0 T (# db_file_multiblock_read_count = 32 # LARGE) N
243
0 T (db_block_buffers = 50) S 24 T () S 32 T () S 40 T ( # ) S
246
(# db_block_buffers = 200 # SMALL) p n
247
0 T (# db_block_buffers = 550 # MEDIUM) N
248
0 T (# db_block_buffers = 3200 # LARGE) N
250
0 T (shared_pool_size = 500000 # ) S
253
(# shared_pool_size = 3500000 # SMALL) p n
254
0 T (# shared_pool_size = 6000000 # MEDIUM) N
255
0 T (# shared_pool_size = 9000000 # LARGE) N
257
0 T (log_checkpoint_interval = 10000) N
259
0 T (processes = 50 # ) S
262
(# processes = 50 # SMALL) p n
263
(65) # (# processes = 100 # MEDIUM) N
264
0 T (# processes = 200 # LARGE) N
266
0 T (dml_locks = 100 # ) S
269
(# dml_locks = 100 # SMALL) p n
270
(70) # (# dml_locks = 200 # MEDIUM) N
271
(sqlinit.ora) (right) (1) title
274
(The room for the header) rhead
275
(Printed by Somebody from a machine) (Right) (1) footer
284
(Test Files) 35.25 water
286
llx lly 12 add translate
288
/x0 x v get 4.431713 add sx cw mul add store
289
/y0 y v get bfs th add sub store
291
0 T (# dml_locks = 500 # LARGE) p n
293
0 T (log_buffer = 1000 # ) S
296
(# log_buffer = 8192 # SMALL) p n
297
(75) # (# log_buffer = 32768 # MEDIUM) N
298
0 T (# log_buffer = 163840 # LARGE) N
300
0 T (sequence_cache_entries = 10 # ) S
303
(# sequence_cache_entries = 10 # SMALL) p n
304
(80) # (# sequence_cache_entries = 30 # MEDIUM) N
305
0 T (# sequence_cache_entries = 100 # LARGE) N
307
0 T (sequence_cache_hash_buckets = 10 # ) S
310
(# sequence_cache_hash_buckets = 10 # SMALL) p n
311
(85) # (# sequence_cache_hash_buckets = 23 # MEDIUM) N
312
0 T (# sequence_cache_hash_buckets = 89 # LARGE) N
314
0 T (# audit_trail = ) S
318
( you want auditing) p n
319
0 T (# timed_statistics = ) S
326
(max_dump_file_size = 10240 # limit trace ) p
336
(# log_archive_start = ) p
340
( you want automatic archiving) p n
349
(95) # (background_dump_dest=%RDBMS73%\\TRACE) N
350
0 T (user_dump_dest=%RDBMS73%\\TRACE) N
352
0 T (db_block_size = 2048) N
354
(100) # (snapshot_refresh_processes = 0) N
357
(remote_login_passwordfile = shared) c n
358
(sqlinit.ora) (right) (2) title
361
(The room for the header) rhead
362
(Printed by Somebody from a machine) (Right) (2) footer