Hello,
Can you please tell me why immediate resize operation looped and didn't succeed? Why granule wasn't moved from default buffer cache to large pool?
*** 2017-08-28 11:03:25.776
AUTO SGA: move req 0x1401980878, 0, 4a, 109, 0
AUTO SGA: inprog proc req 0x1401980878, 0, 4a, 7, 2, 109
*** 2017-08-28 11:03:25.776
AUTO SGA: Request 0x1401980878 after pre-processing, ret=0
AUTO SGA: IMMEDIATE, FG request 0x1401980878
AUTO SGA: Receiver is large pool, size=4, state=3, flg=81
AUTO SGA: Donor is DEFAULT buffer cache, size=281, state=4, flg=81
AUTO SGA: requested=252780456, remaining=252780456, flg=4a, (0,0)
AUTO SGA: received=0, minreq=252780456, seq=109, gransz=268435456
AUTO SGA: Request 0x1401980878 status is INACTIVE
*** 2017-08-28 11:03:30.890
AUTO SGA: Process req 0x1401980878 ret 2, 1, 4a, 7, 2
AUTO SGA: IMMEDIATE, FG request 0x1401980878
AUTO SGA: Receiver is large pool, size=4, state=3, flg=81
AUTO SGA: Donor is DEFAULT buffer cache, size=281, state=4, flg=81
AUTO SGA: requested=252780456, remaining=252780456, flg=4a, (1,1)
AUTO SGA: received=0, minreq=252780456, seq=109, gransz=268435456
AUTO SGA: Request 0x1401980878 status is PENDING
Best Regards,
Damian