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
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 #385846 is a reply to message #385844] Wed, 11 February 2009 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because this is what there is.
What is your problem?
Why there are sessions or why they have these status?
Do you know what ACTIVE and INACTIVE mean?

Regards
Michel
Re: NEED SUGGESTION [message #385848 is a reply to message #385846] Wed, 11 February 2009 07:16 Go to previous messageGo to next message
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.
Re: NEED SUGGESTION [message #385861 is a reply to message #385848] Wed, 11 February 2009 08:41 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So what don't you understand to the output?

Regards
Michel
Previous Topic: Ora- 12535: operation timed out error.
Next Topic: sga_max_size
Goto Forum:
  


Current Time: Fri Dec 09 17:50:28 CST 2016

Total time taken to generate the page: 0.24936 seconds