Home » RDBMS Server » Server Administration » NEED SUGGESTION (32-bit Windows: Version 10.2.0.1.0 - Production)
( ) 1 Vote
NEED SUGGESTION [message #385844] |
Wed, 11 February 2009 06:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
panduoracledba
Messages: 14 Registered: September 2008
|
Junior Member |
|
|
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
In our testing DB
SELECT
DBA_USERS.USERNAME||'-->'||
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED')||'-->'||
NVL(OSUSER, '-')||'-->'||
NVL(TERMINAL,'-')||'-->'||
SUM(DECODE(V$SESSION.USERNAME, NULL, 0,1))||'-->'||v$session.status
FROM
DBA_USERS, V$SESSION
WHERE DBA_USERS.USERNAME = V$SESSION.USERNAME (+)
AND DBA_USERS.USERNAME = 'APPOWNER'
GROUP BY
DBA_USERS.USERNAME,
DECODE(V$SESSION.USERNAME, NULL, 'NOT CONNECTED', 'CONNECTED'),
OSUSER,
TERMINAL,v$session.status
ORDER BY 1
;
DBA_USERS.USERNAME||'-->'||DECODE(V$SESSION.USERNAME,NULL,'NOT
--------------------------------------------------------------
APPOWNER-->CONNECTED-->--->--->25-->INACTIVE
APPOWNER-->CONNECTED-->Administrator-->SRIRAM7-->1-->ACTIVE
APPOWNER-->CONNECTED-->Administrator-->SRIRAM7-->2-->INACTIVE
SRIRAM7 is my terminal.All my sessions are working properly then why it is shoing 2 are in INACTIVE mode? WHAT ABT 25 inACTIVE?
if am connecting ORACLE REPORTS using same username/password also it is showing as inactive mode!?
select
substr(a.spid,1,9) pid,
substr(b.sid,1,5) sid,
substr(b.serial#,1,5) ser#,
substr(b.machine,1,20) box,
substr(b.username,1,18) username,
-- b.server,
substr(b.osuser,1,8) os_user,
substr(b.program,1,30) program,b.status
from v$session b, v$process a
where
b.paddr = a.addr and b.osuser is not null and substr(b.osuser,1,8)='Administ'
and type='USER'
order by box
PID SID SER# BOX USERNAME OS_USER PROGRAM STATUS
--------- ----- ----- -------------------- ------------------ -------- ------------------------------ --------
1448 558 1990 PANDU\SRIRAM7 APPOWNER Administ INACTIVE
856 600 2648 PANDU\SRIRAM7 APPOWNER Administ INACTIVE
748 609 9368 PANDU\SRIRAM7 APPOWNER Administ sqlplusw.exe INACTIVE
324 564 3601 PANDU\SRIRAM7 APPOWNER Administ sqlplusw.exe INACTIVE
5648 584 5562 PANDU\SRIRAM7 APPOWNER Administ sqlplusw.exe ACTIVE
5 rows selected.
there it is showing like SID 558,600 are inactive which are oracle report sessions and 609,564 are sqlplus sessions.why?
|
|
|
|
Re: NEED SUGGESTION [message #385848 is a reply to message #385846] |
Wed, 11 February 2009 07:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
panduoracledba
Messages: 14 Registered: September 2008
|
Junior Member |
|
|
I know Michel.
A session is ACTIVE when it is making a SQL call to Oracle Database. A session is INACTIVE if it is not making a SQL call to the database.
any way thanks for your reply.
|
|
|
|
Goto Forum:
Current Time: Sun Aug 25 12:41:32 CDT 2024
|