This discussion is archived
2 Replies Latest reply: Sep 17, 2013 2:03 PM by kirkladb RSS

E-Business R12 Inactive User Issues

kirkladb Newbie
Currently Being Moderated

All:

I just went live in production with EBS 12.1.3 and we are havinga major issue. I was hoping that someone might have seen this. I log into Apps (32-Bit for both apps and dbtier) and the number of inactive users for Apps steadily increases to reach the max processes for the database). Once this happens no one can get in...:

 

SQL> l
  1  select s.status, count(1), s.username from v$process p,v$session s where
  2  paddr(+) = addr
  3* group by s.status, s.username order by 1
SQL> /

STATUS     COUNT(1) USERNAME
-------- ---------- ------------------------------
ACTIVE           28 APPS
ACTIVE            1 SYS
ACTIVE           28
INACTIVE        190 APPS
INACTIVE          1 DBSNMP
                  1

There are really no users in now yet the counts are hight. Most of the connections that are inactive are for JDBC Thin Client. Any suggestions?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points