sort_area_size

[edoward]

Hi guys!

How would I know the current sort area size for a particular session? Is there any view.column that could provide me this information?
Just want to check if an 'alter session set sort_area_size=' took effect.

Thanks!

Regards,

Edo

[hacketta1]

SQL PROD|SYS> select value from v$parameter where name = 'sort_area_size';

VALUE
----------
512000

1 row selected.

SQL PROD|SYS> alter session set sort_area_size = 33554432;

Session altered.

SQL PROD|SYS> select value from v$parameter where name = 'sort_area_size';

VALUE
----------
33554432

1 row selected.

SQL PROD|SYS>

[rajabalachandra]

also, from sqlplus

SQL> sho parameter sort_area_size

NAME TYPE VALUE
------------------------------------ ------- ---------
sort_area_size integer 1000000
SQL>