ORA-04031

Category: Performance and Tunning 10 years ago
Buenas me sale este error:

ORA-04031: unable to allocate 27516 bytes of shared memory ...

mi Servidor tiene 3GB de RAM

mi archivo init tiene lo siguiente:

orcl.__shared_pool_size=83886080
*.audit_trail='DB_EXTENDED'
*.background_dump_dest='I:\oracle\product\10.1.0\admin\orcl\bdump'
*.compatible='10.1.0.2.0'
*.control_files='I:\oracle\product\10.1.0\oradata\orcl\control01.ctl','I:\oracle\product\10.1.0\oradata\orcl\control02.ctl','I:\oracle\product\10.1.0\oradata\orcl\control03.ctl'
*.core_dump_dest='I:\oracle\product\10.1.0\admin\orcl\cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='E:\Oracle\orcl\flash_recovery_area'
*.db_recovery_file_dest_size=60000000000
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.java_pool_size=50331648
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=400
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=65536
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='I:\oracle\product\10.1.0\admin\orcl\udump'



Mi ppregunta es que parametros tengo que modificar con respecto a mi memoria.


Gracias.
Like it on Facebook, +1 on Google, Tweet it or share this topic on other bookmarking websites.
You do not have permissions to reply to this topic.
Powered by CjForum