Re: some additional information ...

Frank Ratzlow wrote:

> 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

I can't remember if this is the Solaris install from earlier in the day ... but if it is your /etc/system settings don't even remote resemble those recommended by Oracle.

If not ... installation of Java requires about a 30MB Java Pool to run well which can later be dropped to 32K if you are not using any Java.

Daniel Morgan Received on Mon Sep 16 2002 - 15:26:23 CDT