Home » RDBMS Server » Server Administration » Pid= oracle
Pid= oracle [message #264022] Fri, 31 August 2007 09:28 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
I have a problem
my database is too slow and when i type TOP (under linux) i see a PID
after that i run a ps -ef|grep pid
oracle 24504 1 43 Jul 14 ? 58115:27 oracleEDUPROD (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

ok
now my problem is how to see what is doing that session and after that
how to close that session?
i am trying to look into v$session view but i dont find anything


i was searching and i find

ALTER SESSION CLOSE DATABASE LINK linkname;

where i can find that linkname?
thnx in advance

Report message to a moderator

Re: Pid= oracle [message #264023 is a reply to message #264022] Fri, 31 August 2007 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how to close that session?
kill -9 24504

[Updated on: Fri, 31 August 2007 09:31] by Moderator

Report message to a moderator

Re: Pid= oracle [message #264026 is a reply to message #264023] Fri, 31 August 2007 09:33 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
anacedent wrote on Fri, 31 August 2007 09:31
kill -9 24504

yes but first i must to know what user is, and what is he doing
if he is using a sqlldr (as for example) maybe it is a long operation and i cant just kill it
maybe is an rman,

and at last, my idea is close that session using oracle not kill that operation.
Thnx for your quick reply Very Happy

Report message to a moderator

Re: Pid= oracle [message #264030 is a reply to message #264022] Fri, 31 August 2007 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>my idea is close that session using oracle not kill that operation.
Good luck. IIRC, joining V$SESSION with V$TRANSACTION will provide the SID of this rogue process.

I'm about 2,000 kilometers from my office & bandwidth limited now; so I can not assist in more detail.

[Updated on: Fri, 31 August 2007 09:42] by Moderator

Report message to a moderator

Re: Pid= oracle [message #264036 is a reply to message #264030] Fri, 31 August 2007 09:48 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
anacedent wrote on Fri, 31 August 2007 09:41
>my idea is close that session using oracle not kill that operation.
Good luck. IIRC, joining V$SESSION with V$TRANSACTION will provide the SID of this rogue process.

I'm about 2,000 kilometers from my office & bandwidth limited now; so I can not assist in more detail.


wow you are too far from your home Very Happy grats Wink
thnx for your help i am searching and i understand your join but the missing step is to understand or find the way to know what is doing a unix pid (what sid is as for example)
thnx again

Report message to a moderator

Re: Pid= oracle [message #264040 is a reply to message #264022] Fri, 31 August 2007 09:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend but only when you actually USE it.
Results 1 - 10 of about 70,300 for unix pid oracle sid. (0.13 seconds)

Please show SOME initiative & stop depending upon being spoonfed.

[Updated on: Fri, 31 August 2007 09:52] by Moderator

Report message to a moderator

Re: Pid= oracle [message #264059 is a reply to message #264036] Fri, 31 August 2007 10:30 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
SQL> desc v$session
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SADDR                                     RAW(4)
 SID                                       NUMBER
 SERIAL#                                   NUMBER
 AUDSID                                    NUMBER
 PADDR                                     RAW(4)
 USER#                                     NUMBER
 USERNAME                                  VARCHAR2(30)
 COMMAND                                   NUMBER
 OWNERID                                   NUMBER
 TADDR                                     VARCHAR2(8 CHAR)
 LOCKWAIT                                  VARCHAR2(8 CHAR)
 STATUS                                    VARCHAR2(8 CHAR)
 SERVER                                    VARCHAR2(9 CHAR)
 SCHEMA#                                   NUMBER
 SCHEMANAME                                VARCHAR2(30)
 OSUSER                                    VARCHAR2(30)
 PROCESS                                   VARCHAR2(12)
 ...
SQL> desc v$process
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 ADDR                                      RAW(4)
 PID                                       NUMBER
 SPID                                      VARCHAR2(12)
 USERNAME                                  VARCHAR2(15)
 SERIAL#                                   NUMBER
 TERMINAL                                  VARCHAR2(16)
 PROGRAM                                   VARCHAR2(64)
...

v$session.process client process
v$process.spid server process (the one in your post)
v$process.addr = v$session.paddr

Regards
Michel

Report message to a moderator

Previous Topic: Flashback one user...
Next Topic: Space Management
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 07:52:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.