I had a recent go live of one of the instances i delivered.
my manager was curious to know the session information on the instance.
following query helped me a lot in determining them.
set linesize 2000
column logon_time format a17
column username format a16
column unix_pid format a8
column machine format a20
column client_Program format a20
set pagesize 200
select
s.username,
s.sid,
s.serial#,
to_char(p.spid) unix_pid,s.status,to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time,
-- idle time
-- days added to hours
--( trunc(LAST_CALL_ET/86400) * 24 ) ':'
-- days separately
substr('0'trunc(LAST_CALL_ET/86400),-2,2) ':'
-- hours
substr('0'trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) ':'
-- minutes
substr('0'trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) ':'
--seconds
substr('0'mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2) idle_time,
substr(s.program,1,20) client_program,
s.machine,
s.process client_process,
s.osuser,
substr(p.program,1,20) server_program
from v$session s, v$process p
where s.username is not null
and p.addr = s.paddr
order by username, 2
/
Welcome to my blog
· I have extensively worked on the following technologies/Implementation projects
| · Oracle EBS R12, 11.5.10.2, 11.5.9 o Oracle Applications DBA (AD) o Oracle Financials o Order Management
| · Oracle Retail Suite V12, V13 o Retail Merchandizing system RMS o Invoice matching ReIM o Retail Integration Bus RIB o Retail price manager RPM o Store Inventory Manager SIM o Retail Demand Forecasting RDF o Retail data warehousing RDW o Oracle Internet Directory OID |
| · Oracle SOA Suite o BPEL process manager o Enterprise Service Bus | · Oracle Hyperion Suite o Shared services OSS o Workspace o Planning o Essbase o Enterprise performance management EPM o Financial reporting, Web analysis |
| · Enterprise Batch Scheduler Uc4 Appworx | · Oracle Business intelligence Suite o Answers o Interactive dashboards o BI publisher |
· I am responsible for several Implementations that use the following Oracle middleware products
| · Oracle Weblogic Fusion Middleware web application | · Oracle Weblogic Forms and Reports Server |
| · Oracle Weblogic SOA Suite o BPEL process manager o Oracle Service Bus o Oracle B2B server | · Oracle Business intelligence Suite o BI publisher o Oracle Discoverer 10g |
| · Enterprise Batch Scheduler Active Batch | · Oracle Internet Directory OID |
| · Oracle Connection Manager | · Several Custom applications deployed in Oracle 10g Application servers |
My interest is to make this an arena to share my experiences.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment