OraFAQ Forum: Server Administration » Identify user/machine..session id

Home » RDBMS Server » Server Administration » Identify user/machine..session id

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

Identify user/machine..session id [message #53634]

Wed, 02 October 2002 11:51

sheela
Messages: 66
Registered: March 2002

Member

Is there any way to identify which user or machine has submitted the job (by using the session id or something? Because when we try to shutdown the databsae for cold backup , it looks like its waiting for something to complete:
Dump file /orcle/archbop/bop_ora_11307.trc
Oracle7 Server Release 7.3.4.4.0 - Production
With the distributed option
PL/SQL Release 2.3.4.4.0 - Production
ORACLE_HOME = /opt/Oracle_7.3.4
System name: SunOS
Node name: dbssrv00
Release: 5.8
Version: Generic_108528-15
Machine: sun4u
Instance name: bop
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 11307, image: oraclebop

*** SESSION ID:(46.303) 2002.09.28.03.07.11.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.12.16.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.17.21.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.22.26.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.27.31.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.32.36.000
SHUTDOWN: waiting for active calls to complete.
:

Report message to a moderator

Re: Identify user/machine..session id [message #53636 is a reply to message #53634]

Wed, 02 October 2002 12:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can use something like this
from v$transaction u can identify the transactions too.
if u want to force the shutdown,
use shutdown abort, instead of shutdown immediate

 SQL> select  username,
  2     osuser,
  3          command,
  4          machine,
  5          terminal,
  6     process,
  7     status,
  8          substr(program,1,50) OS_ProgramName
  9  from v$session
 10  where type = 'USER'
 11  order by username;

USERNAME                       OSUSER                            COMMAND
------------------------------ ------------------------------ ----------
MACHINE                                                          TERMINAL         PROCESS   STATUS
---------------------------------------------------------------- ---------------- --------- --------
OS_PROGRAMNAME
--------------------------------------------------
MAG                            ITLOANER1magvivek                      3
WORKGROUPITLOANER1                                              ITLOANER1        1384:1288 ACTIVE
SQLPLUSW.EXE

Report message to a moderator

Re: Identify user/machine..session id [message #53657 is a reply to message #53634]

Thu, 03 October 2002 09:38

sheela
Messages: 66
Registered: March 2002

Member

Actually, sometimes the database seems so busy and uses 25% of all 4 cpus) and nobody can log on to it. And there are only 4 or 5 jobs running on it. When I tried giving your select query to identify the users , it hangs. As a matter of fact attempting to logon using Sqlplus hangs, any sql query through server manager hangs. I enabled trace for the database and it shows no errors in it. The only way is to shutdown and restart the database. There is enough space available. And I don't see any errors in trace whatsoever. What might be wrong here?

Thanks

Report message to a moderator

Previous Topic:	sqlldr issues libclntsh.so.8.0
Next Topic:	Help!Oracle shutdown script /etc/rc0.d errors out!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:54:06 CDT 2024