Skip to Main Content
Forums

Integration

Announcement

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle SOA Suite 11g - Supported Databases??

737545Dec 19 2009 — edited Apr 25 2010
Hi All

I am trying my hands with Oracle SOA suite 11g on my laptop having 2GB of RAM...

List of soft wares installed for this are Oracle 11g database, JDeveloper, SOA Suite. On real time when developing some application system becomes too slow due to memory issue.

The Oracle DB eats up max memory...

So looking for a alternative light weight database alternative for Oracle SOA 11g suite like SQL server 2005.

The Repository Configuration Utility version RCU11.1.1.2 supports SQL Server 2005 database and create the schemas like Dev_SOAINFRA, DEVV_ORASDPM etc correctly...

But while configuring the new admin and SOA server via the wizards (start menu -> Oracle SOA 11g - Home1 -> Configure Application Server) the only database vendor drop down option available is Oracle , list does not contain other players IBM DB2, MS SQL Server , MySQL.....

So can somebody tell me for Oracle SOA Suite 11g, what is the light weight Database option is available so that I may go for SOA applications development on machine like my configuration....

Comments

843829
nry2006 wrote:
On an application running in Windows server 2008 environment with two quad core processors and 16GB of RAM

I ran a multi-threaded process with maximum heap size set to --xMx12000M which was returning a CPU utilization of 12% which was too low although the process was running ok. When increased this setting by 1000M , the CPU utilization went up to 100% which would be the intended figure for this application.
Don't attempt to measure your applications performance by CPU utilization.

Measure how much work (whatever it is doing) it does at different heap settings.
843829
In this case the performance (in terms of time to process) is directly related to CPU utilization. I expect CPU utilization to be maximized as the threads are mainly computationally bound.otherwise the process time to run dramatically increases.
843829
nry2006 wrote:
In this case the performance (in terms of time to process) is directly related to CPU utilization. I expect CPU utilization to be maximized as the threads are mainly computationally bound.otherwise the process time to run dramatically increases.
From CPU utilization at 100% all you know is a lot of CPU is being consumed by something (some thread or several threads).
How would you know it is not the JVM doing background stuff (like GC).
843829
In this case the performance (in terms of time to process) is directly related to CPU utilization. I expect CPU utilization to be maximized as the threads are mainly computationally bound.otherwise the process time to run dramatically increases.
843829
From CPU utilization at 100% all you know is a lot of CPU is being consumed by something (some thread or several threads).
How would you know it is not the JVM doing background stuff (like GC).
843829
I know as each thread has a numerical task to perform which does not require it creating or destroying any object instances - so I don't believe gc is an issue, although I expect memory management is an issue depending on whether you provide sufficient heap space - hence my original query.
843829
try to verify garbage collector log, because the only diffrence between having the problem and not is the increase of the heap. So garbage collector has to work harder.

give us the content of GC log when the problem occur.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 23 2010
Added on Dec 19 2009
#11g, #database, #oracle, #soa, #soa-process-management, #soa-suite-discusssions, #suite
15 comments
7,655 views