Monday, July 25, 2022

how to check PGA size in use

select name, ROUND(value/1024/1024) "SIZE MB" from v$pgastat where NAME in('aggregate PGA target parameter','total PGA inuse','total PGA allocated','maximum PGA allocated')

No comments:

Post a Comment