mercoledì 20 gennaio 2010

Oracle counting opened cursor

This oracle sql statement count cursor opened by session

select sid, count(*) from V$OPEN_CURSOR group by sid having count(*) > 40 ORDER BY count(*) desc;

The result :



Is used to monitoring  ORA-01000  Maximum cursor exceeded.


domenica 3 gennaio 2010

Java Opensource job scheduler by TERRACOTTA

Good java scheduler includes many enterprise-class features, such as JTA transactions and clustering.

in riferimento a:

"The Quartz Scheduler includes many enterprise-class features, such as JTA transactions and clustering."
- Quartz Scheduler - Home (visualizza su Google Sidewiki)

EHCACHE for JAVA

is a good Java Cashing solution.

in riferimento a: Ehcache - Performance At Any Scale (visualizza su Google Sidewiki)