Oracle How to determine existing objects in db oracle

How to determine existing objects in db oracle

select * FROM DBA_OBJECTS where OBJECT_NAME LIKE '%MYTABLE%'

in riferimento a: ORA-00955: name is already being used by existing object tips (visualizza su Google Sidewiki)

Oracle JDBC parameter

Is possible passing other parameter to JDBC url.
Instead of "@host:port:sid" should be used complete tnsname such as :

"jdbc:oracle:thin:@(DESCRIPTION=" +
"(ADDRESS_LIST=" +
"(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=host)" + =
"(PORT=port)" +
")" +
")" +
"(CONNECT_DATA=" +
"(SERVICE_NAME=sid)" +
"(SERVER=DEDICATED)" +
")" +
")"

in riferimento a:

""jdbc:oracle:thin:@(DESCRIPTION=" + "(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)" + "(HOST=host)" + = "(PORT=port)" + ")" + ")" + "(CONNECT_DATA=" + "(SERVICE_NAME=sid)" + "(SERVER=DEDICATED)" + ")" + ")""
- Oracle JDBC database connection problem (visualizza su Google Sidewiki)

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.

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)

Android - Mobile Phone Software SDK Tools

Java Open Source SDK Tools provided for Android Mobile OS.

in riferimento a: Android Developers (visualizza su Google Sidewiki)

Play Framework - Build java web application faster

New java framework available for web development

in riferimento a: Play framework ★ Home (visualizza su Google Sidewiki)