Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center