Possible Issue with Memory??
I have a Oracle 18.104.22.168 database on Solaris. We are testing some new code. It grabs a list of transactions by account number, does some manipulation and inserts it into another table.
The process is flying, processing around 200 transactions per second, then it hits this one account number and goes down to 20 transactions per second. This account number contains 200,000 transactions whereas the rest of them have around 3,000 -4,000 each.
I am thinking that I should take a hit when the cursor is grabbing all those transactions and loading them into memory but once they are there I would think that I would start loading at 200 per second but that is not happening. Any ideas what I should check? The PGA_FREEABLE_MEM hits zero when this account comes up.