A streams apply process which applies to a sql sever database is increasing its pga use continually until i stop the process and restart it.
I need to stop it once every week or it will use too much of the pga and the database will hand causin paging etc.
ANyone had this issue before?
which version of database you are using? check for wait dependency bug?
<moderator edit - delelted link signature - see FAQ on top right>