The PX sessions will stay there but they won't be active. I notice it
happening on alot of tools, not just TOAD. I haven't actually done anything
about it except to try and educate the users. My tables aren't defined as
parallel, only the indexes so the select * aren't affected. I shouldn't say
I haven't done anything, people are assigned a profile which will snipe them
if idle > 2hrs. This gets rid of the idle PX sessions and only there main
session is shown as sniped.
Mike
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 09:39:02 CDT
