some additional information ...

From: Frank Ratzlow <frank_ratzlow_at_hotmail.com>
Date: 16 Sep 2002 13:16:39 -0700
Message-ID: <5ef29569.0209161216.676a9b71@posting.google.com>

Hi,

the settins in this file are untouched values of the default init.ora.

----only-uncommented-values----
db_name=DEFAULT
db_files = 80
# SMALL

db_file_multiblock_read_count = 8
# SMALL

db_block_buffers = 100
# SMALL

shared_pool_size = 3500000
# SMALL

log_checkpoint_interval = 10000
processes = 50
# SMALL

parallel_max_servers = 5
# SMALL

log_buffer = 32768
# SMALL

max_dump_file_size = 10240 # limit trace file size to 5 Meg each global_names = TRUE
control_files = (ora_control1, ora_control2)

I didn't checked these parameters yet if the comply to the requirements of this configuration.

After starting dbca I leave all the default settings for a general purpose db:

shared pool:	117440512
Buffer Cache:	32 (MB)
Java Pool:	117440512
Large Pool:	16777216
PGA:		25165824
------------------------------

output at the beginning of the creation (copying db files)

swap -s
total: 46064k bytes allocated + 4376k reserved = 50440k used, 2838400k available

the output of "vmstat 5 " with the start of the creation till shortly after the message "out of memory" appears and I stop dbca

kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr f0 m1 m2 m5 in sy cs us sy id
0 0 0 2855584 920696 7 8 68 1 1 0 5 0 0 0 1 526 357 252 1 2 97
0 0 0 2843224 891448 12 68 134 0 0 0 0 0 0 0 0 639 3193 2349 24 2 74
0 0 0 2839408 875464 54 106 222 26 26 0 0 0 0 0 0 861 4222 1192 36 11 54
0 0 0 2838736 806480 5 0 0 10 10 0 0 0 0 0 0 818 4912 1582 38 14 48
0 0 0 2838696 772744 3 0 195 0 0 0 0 0 0 0 0 826 4744 1488 40 12 48
0 0 0 2838664 772392 4 0 204 0 0 0 0 0 0 0 0 822 4713 1456 39 13 48
0 0 0 2838600 773280 51 45 414 59 59 0 0 0 0 0 0 813 4978 1638 36 15 48
0 0 0 2838536 779856 270 22 2044 0 0 0 0 0 0 0 0 794 4499 1442 39 13 48
0 0 0 2838520 789296 239 0 1900 0 0 0 0 0 0 0 0 802 4336 1403 36 13 51
0 0 0 2838504 794224 320 0 2494 0 0 0 0 0 0 0 0 815 4435 1595 40 11 49
0 0 0 2838480 796872 358 0 2901 0 0 0 0 0 0 0 0 819 4284 1449 42 9 50
0 0 0 2838456 800168 357 0 2916 2 2 0 0 0 0 0 0 807 4393 1626 39 11 50
0 0 0 2838440 800104 315 0 2402 3 3 0 0 0 0 0 0 785 4396 1450 37 14 48
0 0 0 2838416 798032 348 0 2913 2 2 0 0 0 0 0 0 805 4310 1457 41 9 50
0 0 0 2838392 798728 303 0 2454 0 0 0 0 0 0 0 0 775 4456 1550 40 11 49
0 0 0 2838344 790368 47 0 409 27 27 0 0 0 0 0 0 805 4625 1461 40 11 50
0 0 0 2838288 786232 375 0 2860 0 0 0 0 0 0 0 0 808 4395 1456 42 10 48
0 0 0 2838264 794240 319 0 2533 0 0 0 0 0 0 0 0 807 4335 1604 40 11 49
0 0 0 2838232 798904 315 0 2577 0 0 0 0 0 0 0 0 824 4287 1460 39 11 50
0 0 0 2838160 792904 91 0 653 72 72 0 0 0 0 0 0 795 4030 798 39 11 50
0 0 0 2837784 786976 271 103 2719 96 96 0 0 0 0 0 1 860 3501 497 31 13 55
0 0 0 2838984 788456 8 139 276 2 2 0 0 0 0 0 0 703 2060 899 3 4 92
0 0 0 2839528 788936 0 0 0 0 0 0 0 0 0 0 0 642 1809 773 0 1 99
0 0 0 2839528 788936 0 0 0 0 0 0 0 0 1 1 1 626 1884 842 0 1 99

In my opion there must be something wrong either with the init.ora or default-settings of the dbca-GUI (e.g. shared pool == java pool ???!)

I would be very glad if someone could use this information to give me a hint what to change. I cannot imagine that Oracle doesn't let me create a damn empty database with 1 person access only.

TIA Frank
frank_ratzlow_at_nojunk.hotmail.com Received on Mon Sep 16 2002 - 15:16:39 CDT