For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
i downloaded and installed java7u25,after that in my pc i didnt found javadb,but java7 documents shows it includes in jdk.any help
That's fixed in v4.0.2
Just installed 4.0.2.15 and the same thing happens.
I put a select sysdate from dual into the child report and I get a new cursor for every refresh when the parent refreshes.
Maybe this will help. This does not appear to happen when the child is set to refresh. Only when the parent is.
I'm not seeing that behavior. I'm counting open cursors by going against v$statname where name = 'opened cursors current'
I am not sure what is different about what I am doing but here is a child report showing the value of opened cursors current and it count goes up with refreshes.
This also only happens when the type is set to table. It does not happen if the type is set to script.
I can gather anything else you think would be useful but I am not sure what else to add.
Parent query
select \* from v$session where username = 'DBA\_MONITOR'
Child query - Hardcoded SID to make sure it was showing right one.
select sysdate, stat.sid,
stat.value, statname.name
from v$sesstat stat,
v$session sess, v$statname statname
where stat.sid = 617
and stat.sid = sess.sid
and statname.statistic# = stat.statistic#
and statname.name = 'opened cursors current'
It took a few minutes to find the exact reproducible scenario - a bit different than the one originally reported that we did FIX.
But, two things: