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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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
robocatCommented:

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Components

From novice to tech pro — start learning today.