sort_area_size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sort_area_size

  1. #1
    Join Date
    Jan 2004
    Posts
    4

    sort_area_size

    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

  2. #2
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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>

  3. #3
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    also, from sqlplus

    SQL> sho parameter sort_area_size

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width