Killing oracle sessions

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Killing oracle sessions
# 1  
Old 07-27-2011
Killing oracle sessions

Hi, I need to write a shell script to kill all oracle sessions.

I have to login in unix with unix userid and have to use sudo command to login with oracle userid and has to find out all oracle related sessions that are running currently and has to kill all sessions.
please suggest me the way to follow.

I am using sun unix OS and ksh shell.
oracle 10g

Thanks in advance.
# 2  
Old 07-27-2011
Here is an article with everything you need to know:

ORACLE-BASE - Killing Oracle Sessions
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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.... (1 Reply)
Discussion started by: senkerth
1 Replies

2. 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 )... (2 Replies)
Discussion started by: jimthompson
2 Replies

3. 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? :) (1 Reply)
Discussion started by: anandgodse
1 Replies

4. 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 (2 Replies)
Discussion started by: yoavbe
2 Replies

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"... (1 Reply)
Discussion started by: poweroflinux
1 Replies

6. 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... (0 Replies)
Discussion started by: sukerman
0 Replies

7. 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... ... (3 Replies)
Discussion started by: xaviraan
3 Replies

8. 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? (1 Reply)
Discussion started by: eleia
1 Replies

9. 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... (1 Reply)
Discussion started by: oracle8
1 Replies
Login or Register to Ask a Question