BI Publisher (MOSC)

MOSC Banner

scheduler DB session(connection pool) for publisher

edited Oct 2, 2013 4:13AM in BI Publisher (MOSC) 9 commentsAnswered
Hi,
I would like to confirm about the scheduler DB session(connection pool) for publisher.
And how to handle the number of this session.

OAS 10.1.3.5 + Publisher 10.1.3.4.2

Issue
-----
Checked the two sessions right after start the OAS(Publisher).

SQL> select sid,serial#,status,logon_time
  2  from v$session where username='AERO_XMLP_SCHED';

  SID    SERIAL# STATUS     LOGON_TIME
----- ---------- ---------- --------------------
  148         16 INACTIVE   2013-09-18 18:20:48
  151         15 INACTIVE   2013-09-18 18:20:48

Log into publisher and do some actions for scheduler(ex. Access to the schedule tab etc..)
Then I confirmed another 20 sessions were created(22 sessions totally).

SQL> select sid,serial#,status,logon_time

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