Guest

Preview Tool

Cisco Bug: CSCur52510 - ORACLE Open Cursors growing rapidly

Last Modified

Jan 25, 2017

Products (1)

  • Cisco Tidal Enterprise Transporter

Known Affected Releases

6.2.1

Description (partial)

Symptom:
Open cursor count in oracle database is keep on increasing and it seems there is leakage in releasing the used memory.

open cursor count can be monitored by using the below query.

select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,
s.username
from v$sesstat a, v$statname b, v$session s 
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current' and s.username in ('TES', 'TIDAL')
group by s.username

Conditions:
transporting the large number of JDE jobs
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.