OraFAQ Forum: Performance Tuning » Shall I kill these process...

Home » RDBMS Server » Performance Tuning » Shall I kill these process... (Oracle 10g rel 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shall I kill these process... [message #502949]

Mon, 11 April 2011 14:47

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

prd> select count(*),STATE,P1TEXT,EVENT,WAIT_CLASS
2 from v$session
3 where username='XXXXXX' and MACHINE='XXX' and status='INACTIVE'
4 group by STATE,P1TEXT,EVENT,WAIT_CLASS
5 order by EVENT,WAIT_CLASS;

COUNT(*) STATE P1TEXT
---------- ------------------- ----------------------------------------------------------------
EVENT
----------------------------------------------------------------
WAIT_CLASS
----------------------------------------------------------------
493 WAITING driver id
SQL*Net message from client
Idle

Sriram

Report message to a moderator

Re: Shall I kill these process... [message #502952 is a reply to message #502949]

Mon, 11 April 2011 14:55

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As I said in PM, only you can know if you should kill this session or not.
For me, you can kill all sessions, I don't care.

Why is this a performances question?

Regards
Michel

[Updated on: Mon, 11 April 2011 14:56]

Report message to a moderator

Re: Shall I kill these process... [message #502953 is a reply to message #502952]

Mon, 11 April 2011 15:01

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

For me, you can kill all sessions, I don't care.

Good response

Sriram

Report message to a moderator

Previous Topic:	Hier - Query Perfomance (3 Merged)
Next Topic:	Tuning Insert

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 10:45:29 CDT 2024