how to find size of query output result?
hi,
Is there a way to find the top sql results returned in terms or memory, and also in terms of number of rows?
I'm not sure I could find anything in HIST tables. Buf if you have queries that help with this, that would be great. I remember I used to have a query like that but I just can't find it
I'm using
Oracle 19c RAC 19.4.0.0. , Linux 7, I use normal OS storage (not ASM)
thank you