scheduler DB session(connection pool) for publisher
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
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
0