remote agent component in shared pool
Hello,
We are having some performance problems with one of our databases.
I surprisingly found in v$sgasta a component called 'remote agent' which uses 21G .. most of our memory .
(memory_max_target is set to 22G , machine has 32G)
Does anyone have an idea what that one is used for ?
Is there a way to control it's size ?
select pool,name,bytes/1024/1024 M from v$sgastat where pool = 'shared pool' order by 3 desc;
shared pool remote agent 21281.5226516724
shared pool sql area 5303.2459564209
shared pool free memory 2914.70404052734
shared pool remote agent addr 1505.94664001465
shared pool PCursor 1173.78492736816
shared pool CCursor 990.054260253906
shared pool agent name2 984.75560760498
We are having some performance problems with one of our databases.
I surprisingly found in v$sgasta a component called 'remote agent' which uses 21G .. most of our memory .
(memory_max_target is set to 22G , machine has 32G)
Does anyone have an idea what that one is used for ?
Is there a way to control it's size ?
select pool,name,bytes/1024/1024 M from v$sgastat where pool = 'shared pool' order by 3 desc;
shared pool remote agent 21281.5226516724
shared pool sql area 5303.2459564209
shared pool free memory 2914.70404052734
shared pool remote agent addr 1505.94664001465
shared pool PCursor 1173.78492736816
shared pool CCursor 990.054260253906
shared pool agent name2 984.75560760498
0