Thursday, August 28, 2014

Monday, August 25, 2014

Friday, August 22, 2014

the errors sign in eclipse confuse developers

some time,we saw the class and method we reference in eclipse,but the eclipse still shows a error sign in that class or method.
the problem is the order of class path.
try to move the java generated code up to top,make sure it is before the class that reference them.
error sign should go away.

Tuesday, August 19, 2014

database lock check

when doing a database lock check of oracle database, we need check following sys tables.

v$active_session_history as a
v$sql as s

join by sql_id
a.user_id <> 0 will exclude SYS user.
a.sample_time to check the data and time.
a.blocking_session is not null