Oracle JDeveloper and SOA Suite

ONLY JDeveloper does have SOA Suite extension , 

JDeveloper does not have the extension


Installing Oracle XE on Ubuntu in VirtualBox running in Mac OS X

As this works for development purposes only not for production:

Software requirement

  • VirtualBox 4.2.6 – VirtualBox-4.2.6-82870-OSX.dmg
  • Ubuntu 64bit Desktop 12.10- ubuntu-12.10-desktop-amd64.iso as this Oracle XE only work on 64bit Linux
  • Oracle XE 11.2.0 for Linux –
  • As at now im using Mac OS X 10.7.5

Continue reading


Explaining EXPLAIN

explain this select of course will get me the possible keys to use index and rows return is 1, using where. seems ok that can minimize the CPU usage.

i did accidentally change mysql select to SELECT * FROM SMSPROXY WHERE STATUS =10 AND MOD(ID,10)=1 , and doing that EXPLAIN , i still get the same possible keys and the xtra shows using where

again i changed my select to SELECT * FROM SMSPROXY WHERE STATUS =10 AND MOD(ID,10)=1 ORDER BY RAND()
now i get “Using where; Using temporary; Using filesort”. This means MySQL will create a temporary table (hopefully in memory) to hold the results. based on , A filesort is not desirable either because it means “MySQL will need to do an extra pass to find out how to retrieve the rows in sorted order.”. Therefore i remove the RAND() functions . Seems everything went back to normal and the CPU move down to 24% from 98%

Setup Hibernate 3 with Maven in Eclipse (Juno)

Hibernate is an ORM (Object Relational Mapping) tool. Probably you have setup Maven in your Eclipse, as for this I’m using Eclipse Juno. Due to some issues on Maven repositories, it is not that easy to include Hibernate 3 libraries using Maven dependencies in your Eclipse. It is easy if you just add the library using the Java Build Path, but now Im totally using Maven for my new Java Projects.

Continue reading

Oracle check whats locking

select a.session_id,a.oracle_username, a.os_user_name, b.owner “OBJECT OWNER”, b.object_name,b.object_type,a.locked_mode from
(select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from v$locked_object) a,
(select object_id, owner, object_name,object_type from dba_objects) b
where a.object_id=b.object_id