Link to home
Create AccountLog in
Avatar of questil
questil

asked on

Query for threads states

Hi, how can i query for threads states in windows environment? Especially for Oracle threads.

Thanks!
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

What 'states' are you looking to get?
Avatar of questil

ASKER

Maybe i mixing with 'status' instead of 'states'
I still don't understand what you are looking for.  Can you provide more detail?
check the v$process and v$session table

select p.PNAME, p.USERNAME, p.PROGRAM, s.TERMINAL, s.STATUS
from v$process p, v$session s
where p.addr = s.paddr;
ASKER CERTIFIED SOLUTION
Avatar of Devinder Singh Virdi
Devinder Singh Virdi
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
no split points ? ah well, then you didn't use my comment i guess ?