Re: idle transactions vs memory

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sunday, December 6, 2020, Atul Kumar <akumar14871@xxxxxxxxx> wrote:
> Hi,
>
> I have a basic query that do idle transactions (idle more than 5
> minutes) occupy system memory (RAM) or CPU usage ?
>
>
> Please help me.

Help you what?  Queries don’t idle so I don’t even know what you are looking at.  But, generally, long-lived idle in transaction session are bad for many reasons and you should fix your application code to avoid them.

David J.