Technology Stack - EBS (MOSC)

MOSC Banner

How to clean the Inactive session beteen Apps and DB Tier?

edited Dec 30, 2018 4:03AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Dear all,

I am not sure it is the right place.If not,please let me know the right one.

There are too many rows in following tables. They will slow down the DB performance.

v$process table has over 2400 rows

v$session table has over 2600 rows.

There are two front applications which are based on same DB,one is EBS and another is customized front application(DB connections are fixed about 600, reference:FRISAP01,FRISAP02,FRISAP03).

So about 2000 rows are EBS connections.

About 1/3 EBS connections are OIE module.

MACHINE USERNAME MODULE HOW_MANY


---------------


--------

FRISAP01 XXXERPSCAN JDBC Thin Client 175 --> customized front application

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center