Session parameter value of another session

Giganews Newsgroups
Subject: Session parameter value of another session
Posted by:  Pratap (pratap_f…@rediffmail.com)
Date: 21 Dec 2004

Hi,

In session 1 I did -

alter session set sort_area_size=100;
I fired some long running query in session 1.

Now from session 2 can I find out what value of sort_area_size has
been set for session 1? Using v$sql is one way. Is there any another
way of finding this out?

Regards,

Pratap

Replies