Killing oracle sessions

Tags

shell scripts

Top Forums Shell Programming and Scripting Killing oracle sessions

07-27-2011

Registered User

10, 0

Join Date: Mar 2011

Last Activity: 12 October 2011, 2:21 AM EDT

Posts: 10

Thanks Given: 0

Thanked 0 Times in 0 Posts

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.

rohan10k

View Public Profile for rohan10k

Find all posts by rohan10k

07-27-2011

Registered User

28, 6

Join Date: Jul 2011

Last Activity: 26 August 2011, 9:49 AM EDT

Posts: 28

Thanks Given: 7

Thanked 6 Times in 6 Posts

Here is an article with everything you need to know:

ORACLE-BASE - Killing Oracle Sessions

Nitrodist

View Public Profile for Nitrodist

Find all posts by Nitrodist

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....

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 )...

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? :)

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

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

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...

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... ...

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?

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...

Shell Programming and Scripting