-
shared memory error
Hi,
How to solve below error msg. Just restarted that particular database. users can able to access now.
DISTRIB TRAN MIMS.WORLD.d0c46b42.5.16.9664
is local tran 5.16.9664 (hex=05.10.25c0)
insert pending collecting tran, scn=621062569 (hex=0.2504a9a9)
*** 2006-08-06 07:47:05.923
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
n object","sga heap","multiblock rea")
*** 2006-08-06 09:50:00.500
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
n object","sga heap","multiblock rea")
Regards.
Last edited by vijill; 08-06-2006 at 11:25 PM.
-
either your shared pool isnt being enough, or you arent using bind variables
-
What is the formula to increase shared pool. Please let me know.
regards.
-
There was 6 instances are running on same server.rest of the instances shared memory is lower than this . Do not know why this database instance is having shared memory error very frequent. Please advice me on this.
db_name = "RIS"
db_domain = WORLD
instance_name = RIS
service_names = RIS.WORLD
control_files = ("/ris1/RIS/control01.ctl", "/ris1/RIS/control02.ctl", "/ris1/RI
S/control03.ctl")
open_cursors = 300
max_enabled_roles = 30
db_block_buffers = 8000
db_file_multiblock_read_count=8
shared_pool_size = 52428800
large_pool_size = 10485760
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 3600
processes = 80
log_buffer = 163840
# audit_trail = false # if you want auditing
timed_statistics = true # if you want timed statistics
max_dump_file_size = 10000 # limit trace file size to 5M each
-
6 instances on one server? deary me
original statement still holds, either you arent using bind variables or your shared pool isnt big enough
-
How do we increase shared pool size. what is the formula for this. please advise me on this.
regards.
-
Originally Posted by davey23uk
6 instances on one server? deary me
The biggest server I have ever seen is with 70 instances in an old Fujitsu-Siemens RM-600 Server. We never got a chance to re-boot the because of the various appliations for 248 days and finally hit the bug: 1084273 ( Note: 118228.1).
-
how much memory do you have on that server
-
lol... Sorry Devey, I don't remember the specs of the server as this is something 5 years back!
-
the question was aimed at the OP :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|