Configuring and Tuning Databases on the Solaris™ Platform

Performance Considerations

In Database Engineering we have been able to sustain more than 30,000 TPC-C transactions (of all types) per minute (corresponding to around 24,000 users executing very lightweight transactions) on a single 100BaseT Ethernet subnet. Even though most of these transactions use stored procedures, which greatly reduce network traffic, our experience suggests that most end users will be able to comfortably deploy substantial client/server solutions based on a single Fast Ethernet LAN.

TPC-C network traffic tends to be relatively stable, however, whereas most real-world workloads are more likely to be bursty. Research with an Oracle Financials workload showed that, although one 10BaseT subnet should have been able to support ...