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?