Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How should i set the parameter for Oracle Database 12c 12.1.0.1.0- 64bit

GRINTEC GmbHOct 14 2015 — edited Oct 19 2015

Hi,

i get this error message:

ORA-04031: unable to allocate 67344 bytes of shared memory

I've tried increasing my init.ora shared_pool_size, but to no avail.

I also tried to set the parameter in sqlplus and now i can only start the database with the pfile.

How can I fix it?

Here are my parameters:

SQL> show parameters size;

NAME

TYPE

VALUE

------------------------------------ ----------- ------------------------------

bitmap_merge_area_size	integer	1048576
client_result_cache_size	big integer 0
create_bitmap_area_size	integer	8388608
db_16k_cache_size	big integer 0
db_2k_cache_size	big integer 0
db_32k_cache_size	big integer 0
db_4k_cache_size	big integer 0
db_8k_cache_size	big integer 0
db_block_size	integer	8192
db_cache_size	big integer 0
db_flash_cache_size	big integer 0

NAME

TYPE

VALUE

------------------------------------ ----------- ------------------------------

db_keep_cache_size	big integer 0
db_recovery_file_dest_size	big integer 4800M
db_recycle_cache_size	big integer 0
dnfs_batch_size	integer	4096
global_context_pool_size	string
hash_area_size	integer	131072
java_max_sessionspace_size	integer	0
java_pool_size	big integer 0
large_pool_size	big integer 0
max_dump_file_size	string	unlimited
max_string_size	string	STANDARD

NAME

TYPE

VALUE

------------------------------------ ----------- ------------------------------

object_cache_max_size_percent	integer	10
object_cache_optimal_size	integer	102400
olap_page_pool_size	big integer 0
parallel_execution_message_size	integer	16384
result_cache_max_size	big integer 0
sga_max_size	big integer 800M
shared_pool_reserved_size	big integer 7549747
shared_pool_size	big integer 0
sort_area_retained_size	integer	0
sort_area_size	integer	65536
streams_pool_size	big integer 0

NAME

TYPE

VALUE

------------------------------------ ----------- ------------------------------

unified_audit_sga_queue_size	integer	1048576
workarea_size_policy	string	AUTO

Thanks in advance.

Nicole Wieser

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2015

Added on Oct 14 2015

#general-database-discussions

16 comments

1,895 views