db_block_buffer,와 shared_pool_size를 좀 늘려주심 되겠슴다.

오전에 답변을 올렸는디...... 올라가질 않았습니다..

db_block_buffer = 5000

shared_pool_size = 20480000

정도로 하시고 오라클을 리스타트하셔서

해보기 바랍니다.

>>황선웅 님께서 쓰시길<<

:: memory 128M

:: swap 1.5Gb

:: os linux 6.2(red hat)

::

:: # replace DEFAULT with your database name

:: db_name=DEFAULT

::

:: db_files = 80 # SMALL

:: # db_files = 400 # MEDIUM

:: # db_files = 1500 # LARGE

::

:: db_file_multiblock_read_count = 8 # SMALL

:: # db_file_multiblock_read_count = 16 # MEDIUM

:: # db_file_multiblock_read_count = 32 # LARGE

::

:: db_block_buffers = 100 # SMALL

:: # db_block_buffers = 550 # MEDIUM

:: # db_block_buffers = 3200 # LARGE

::

:: shared_pool_size = 3500000 # SMALL

:: # shared_pool_size = 5000000 # MEDIUM

:: # shared_pool_size = 9000000 # LARGE