Illinois School of Technology IST
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment