 ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395032] |
Tue, 31 March 2009 02:30  |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel dev_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/hp4syspwd@EAITEST"
ORA-04031: unable to allocate 27992 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param val
ues")
Please FInd The shared pool memory here..
hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 3355443
shared_pool_size big integer 67108864
shared_server_sessions integer 0
shared_servers integer 0
Can Any one help me..Thanks In advance..
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395104 is a reply to message #395078] |
Tue, 31 March 2009 05:40  |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
SQL> show parameter shared
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 3355443
shared_pool_size big integer 67108864
shared_server_sessions integer 0
shared_servers integer 0
SQL> show parameter large
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 16777216
SQL>
The Large pool memory is alredy..having 40% of Shared pool
memory..
How much can i increase ?
Whether Large pool r shared poool?
Current shrepool size=64mb
" Large pool size=16mb.
Help me.
|
|
|
|
|
|
| Re: ORA-04031: unable to allocate 27992 bytes of shared memory While Taking RMAN Backup. [message #395109 is a reply to message #395108] |
Tue, 31 March 2009 05:49 |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
eaitnacc:EAITEST:>top
last pid: 8046; load averages: 2.29, 2.20, 2.20 12:48:36
679 processes: 673 sleeping, 1 zombie, 3 stopped, 2 on cpu
CPU states: 87.0% idle, 1.4% user, 11.5% kernel, 0.0% iowait, 0.0% swap
Memory: 32G real, 17G free, 18G swap in use, 48G swap free
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
21860 eaiuser1 18 60 0 82M 29M cpu/8 231.7H 4.00% stceway.exe
29259 eaiuser1 27 59 0 104M 54M sleep 71:02 2.88% stceway.exe
21797 root 1 1 19 12M 10M sleep 184:58 0.71% lsof
163 eaiuser1 52 59 0 15M 9464K sleep 666:10 0.17% stciqmgrd.exe
366 eaiuser1 15 1 0 95M 50M sleep 654:53 0.17% stcewjx.exe
8983 root 1 59 0 19M 6112K sleep 211:08 0.15% scopeux
14808 eaiuser1 2 1 0 1606M 48M sleep 23.9H 0.13% stccb.exe
5343 eaiuser1 17 58 0 82M 34M sleep 21.1H 0.12% stceway.exe
8010 oracle 1 59 0 4360K 2856K cpu/1 0:00 0.09% top
26507 eaiuser1 17 59 0 92M 47M sleep 410:07 0.09% stceway.exe
5342 eaiuser1 17 59 0 82M 34M sleep 21.1H 0.07% stceway.exe
162 eaiuser1 145 59 0 23M 13M sleep 198:07 0.06% stciqmgrd.exe
395 eaiuser1 30 59 0 72M 27M sleep 183:01 0.05% stceway.exe
4018 root 3 59 0 5192K 2424K sleep 21.8H 0.05% MultiNICBAgent
392 eaiuser1 26 59 0 71M 27M sleep 157:02 0.05% stceway.exe
Plese fid the TOP out put..
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
