SQL> select * from v$pgastat;

NAME                                                    VALUE UNIT
-------------------------------------------------- ---------- ------------
aggregate PGA target parameter                      524288000 bytes
aggregate PGA auto target                           450146304 bytes
global memory bound                                  26214400 bytes
total PGA inuse                                      36227072 bytes
total PGA allocated                                  95754240 bytes
maximum PGA allocated                               518062080 bytes
total freeable PGA memory                            19398656 bytes
PGA memory freed back to OS                        1152909312 bytes
total PGA used for auto workareas                     6087680 bytes
maximum PGA used for auto workareas                 201482240 bytes
total PGA used for manual workareas                         0 bytes
maximum PGA used for manual workareas                 1060864 bytes
over allocation count                                       0
bytes processed                                    9126839296 bytes
extra bytes read/written                            234164224 bytes
cache hit percentage                                    97.49 percent

16 rows selected.

SQL> select name,value from v$sysstat
  2  where name like 'workarea executions%';

NAME                                                    VALUE
-------------------------------------------------- ----------
workarea executions - optimal                          182563
workarea executions - onepass                              38
workarea executions - multipass                             0

SQL>

ORA-1652: unable to extend temp segment by 1024 in tablespace                 TEMP