Re: parallel query

Martin Douglas <dafis_at_ppp.test.jccbi.gov> wrote:

>I have three processors on a DEC 2100 Alpha. And when I'm running parallel
>query, I get multiple sessions for a users login. These are just the
>processes that are started and are associated with the one user. In my Data
>Warehouse, My users will sometimes reboot thier own system because of a bad
>quiry. And then log back in. Conseqently, there are sometimes more sessions
>going than just the number associated with the "Degree of Parallelism". You
>should assume, (with OS striping), that your table is spread over all of the
>drives that your tablespace is spread over. You should beable to identify
>what datafiles are used by your tablespace. Ask your System Administrator
>What drives these datafiles are striped on.
>
>Martin Douglas
>

Thanks for the info.

BTW, is there an easy way to tell which session is the one the user actually connected as? When our users reboot because of a bad query, they call me and I kill their orphaned session with server manager. With all these extra sessions showing up with the same user name however, it's not easy to determine which is which. I usually go for the lowest SID# and start from there.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!