Assessing suitability of Oracle (SUN) T3 servers for database

Hi,

We have currently a multi-tiered application based on java (Weblogic) and Oracle database running on HPUX and PA RISC processors.
As per a note from Oracle which says "certain Oracle Database operations that are single threaded do not currently perform well on T-series servers as the current generation of T-series servers are designed for throughput rather than being focused on the performance of a single thread", I want to  assess if my current database server and workload on it is suitable to run on T series servers.

Are there any specific commands or tools that I can use to assess my database (Oracle) server to evaluate if I'm getting a few heavy serialized queries/load (which M series is more suited for) or plenty of tiny little transactions on the DB (which T series is more suited for) ?   DB servers are on HP-UX PA-RISC

Or what approach would you suggest?

Thanks,
NDD
nd2011Asked:
Who is Participating?
 
robocatConnect With a Mentor Commented:

From a global perspective, java (server) apps are multithreaded as they execute many threads for many users.

But as I said before, from a single user perspective, the java app is most likely single threaded. That's the nature of most applications, most single user tasks can't be split into threads.

The only exceptions I've ever seen are datawarehousing type apps, scientific apps and apps that run large batch jobs.

0
 
nd2011Author Commented:
Increasing the points to 500, expecting an answer from an expert.
0
 
robocatCommented:

Most user-interactive applications are unsuitable for the T3. Seriously, there are not many apps that perform well on the T3. Too often i've heard the story of somebody replacing a very old server by this type of machine and experience a massive drop in performance.

Only datawarehouse type applications and scientific apps run relatively well, because these often process massive parallel queries that run for hours or days.

Even then, the T3 is blown away by any average two CPU 6core Intel machine that you can buy at the fraction of the cost.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
nd2011Author Commented:
Hi Robocat,

Thanks for your reply.
When you say not many apps perform that well on T3 - are you talking only about the database layer/tier for those applications or even say the web and app layers/tiers for that application do not perform well on T series?

Thanks.
0
 
robocatCommented:

Both.

In the database and the application tier, parallelism is often only archieved because many users access the application simultaneously.

From the perspective of a single user, the application is (most likely) single threaded for each individual action from that user. Software developers rarely bother making the app parallel for individual users.

Although the T3 can achieve massive throughput with many users combined, the individual user could experience very slow response times.

Of course this depends on how CPU intensive the app is: going from a 0.05 second to a 0.3 second response time will not be noticed, but going from 0.5 s to 3 s will generate lots of complaints.

The same goes for the database tier, only long and massive queries will be split into parallel threads.
0
 
nd2011Author Commented:
Hi,

Thanks again and sorry for being more inquisitive.
I understand what you are pointing at.
But, generally java based applications (or rather application servers) are multi threaded. Would these applications be affected as well. The developers may not have taken any additional steps to make it multi-threaded - but the inherent parallelism in the java server - would that help, or still would you say that even in this case there could be impact to application?

Thanks very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.