OraFAQ Forum: Server Administration » Need help with monitoring user session and killing it

Home » RDBMS Server » Server Administration » Need help with monitoring user session and killing it (8.1.7)

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

Need help with monitoring user session and killing it [message #459754]

Tue, 08 June 2010 04:32

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Hi,

I am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.

My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.

Please suggest.

Best Regards,

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459768 is a reply to message #459754]

Tue, 08 June 2010 04:58

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes do it.

Regards
Michel

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459771 is a reply to message #459768]

Tue, 08 June 2010 05:02

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Shall i kill the session or wait till its cleared ?

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459775 is a reply to message #459771]

Tue, 08 June 2010 05:11

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If it does not matter for him then do as you want.

What does mean "80% of Overall resources"?

Regards
Michel

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459792 is a reply to message #459775]

Tue, 08 June 2010 06:10

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

In toad, we can see the resources(CPU,Network,IO etc) being used by a particular user.

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459794 is a reply to message #459792]

Tue, 08 June 2010 06:11

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And so what does mean you sentence?

Regards
Michel

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459801 is a reply to message #459754]

Tue, 08 June 2010 06:41

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Killing the session on regular basis ? Sounds like an unhealthy approach.

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459816 is a reply to message #459801]

Tue, 08 June 2010 07:19

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

A better way would be for the user to to close / exit the client program, then the session should go away.

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459823 is a reply to message #459816]

Tue, 08 June 2010 07:33

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

If the user doesnt close his application after finishing his/her job, will it still affect the overall performance of the database. This user runs a very big job.

Report message to a moderator

Re: Need help with monitoring user session and killing it [message #459825 is a reply to message #459823]

Tue, 08 June 2010 07:44

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, no, maybe, maybe not, it depends.
Does someone complain about something?

Through away a tool if you don't know what its reports mean (as you seem to don't understand what TOAD tells you).

Regards
Michel

Report message to a moderator

Previous Topic:	flashback table
Next Topic:	different sids on one oracle home

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 08:52:06 CST 2025