Killing oracle sessions Post: 302542426

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

killing parallel oracle process

Hi guys: I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through...

2. Programming

C programming sessions

Hey guys, i'm in trouble, i'm high school teacher, and a student ask me for help, he want's to know where he can study C language for his application exam. Somebody could help us?

3. Shell Programming and Scripting

script : How many sessions are there ?

Hi everybody, I need a script that shows the total number of sessions there are ... This shows how many sessions are open... echo "Number of open sessions: " w | grep :0 | wc | awk '{print $1} But how can I see how many sessions there are in total?? I hope someone can help me... ...

4. Shell Programming and Scripting

Finding the age of a unix process, killing old processes, killing zombie processes

I had issues with processes locking up. This script checks for processes and kills them if they are older than a certain time. Its uses some functions you'll need to define or remove, like slog() which I use for logging, and is_running() which checks if this script is already running so you can...

5. Shell Programming and Scripting

Getting error while getting status of active and inactive sessions from ORACLE DB

Hi All, I have a written a test script which retrieves the status of active and inactive sessions from oracle DB, but i am receiving error while executing. My script is filepath="/home/ocsg/scripts/db_session_report/current_session_report.txt"...

6. Shell Programming and Scripting

Kill sessions

Hi , I am connecting to the linux redhat machine as user : APPS I would like to know how i can kill -9 , all APPS sessions beside me . Please advice Thanks

7. HP-UX

Idle sessions.

What kind of problems can be faced if any session which connects to unix server is open for longer time? How to find out from how much time that session is idle? :)

8. AIX

SIGHUP killing Oracle Listener Process

I have a cold backup script which backs up my database and then restarts the oracle listener and database at around 01:30 I can see at this time that my database and listener are indeed running. However at around 02:17 my listener process receives a SIGHUP 1 signal from the AIX OS ( version 5.3 )...

9. UNIX for Advanced & Expert Users

Help in Oracle Inactive Sessions

hi , i could see 50-60 oracle inactive session running under my application name, does this cause any issue.. or can this inactive session be excluded , if so how can we reduce them or exclude them , your inputs are much required. my application runs on C++ with oracle , pro*c involved....

LEARN ABOUT OPENSOLARIS

purple-url-handler

purple-url-handler(1)						   User Commands					     purple-url-handler(1)

NAME

       purple-url-handler - Python script to handle URL with purple

SYNOPSIS

       purple-url-handler [-URL]

DESCRIPTION

       Python script to handle URL with purple.

OPTIONS

       Usage: purple-url-handler URL

       Example:

	 purple-url-handler "xmpp:romeo@montague.net?message"

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-im-client	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Volatile			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       purple-remote(1), purple-send(1), purple-send-async(1), attributes(5)

       purple-url-handler Manual, http://pidgin.im/

NOTES

       Updated by Lei Ju, Sun Microsystems Inc., 2006, 2007.

SunOS 5.11							    02 Apr 2008 					     purple-url-handler(1)