Crystal Reports Page Server - Oracle Session Not Closing - reg
I am encountering issue with Crystal Reports Page Server when it tries to retrieve the data from Oracle Database while refreshing the existing report. I can see multiple Oracle sessions hanging when multiple people open the report (particularly 1 report) that may have many records (more than 20000 that is currently set limit in the page server configuration). So, Unless I kill those sessions using kill command under Oracle Database server, not going at all.
Its currently causing the Database Server load increase and slows other processes.
Is it worth to make the # of records to be retrieved as "Unlimited" instead of 20K to avoid this issue ?
The Oracle Database connection also doesn't get closed
even after the User log out successfully.
Ian Scott replied
Can give that a go, but wouldn't really be a viable solution on my production system. Plus what would happen to existing sessions that were open that weren't orphaned? We notice that these rouge sessions basically end up throttling the oracle db.
Could in reality be an oracle issue as there are scripts in theory to clean these items up. Problem is the scripts work for other processes, just not ones originally owned by BOE.