在Solaris上跑Oracle已经10多年了。OS从2.6熬到10，DB从8.1熬到10.2。别说，这种组合还真给力。这么多年，就是没出过啥问题。 3年前的2010年，硬件更新换代。行政上仗着预算富裕，硬是否定了技术人员的升级方案，购买了当时比较高档的T5220。 T5220服务器使
在Solaris上跑Oracle已经10多年了。OS从2.6熬到10，DB从8.1熬到10.2。别说，这种组合还真给力。这么多年，就是没出过啥问题。
3年前的2010年，硬件更新换代。行政上仗着预算富裕，硬是否定了技术人员的升级方案，购买了当时比较高档的T5220。
T5220服务器使用UltraSPARC T2 CPU。该CPU的时钟速度并不高，只有1.2GHz，但是有4个核，而且每个核上可以挂接8个线程，从而构成了32个虚拟CPU。
但是，在此服务器上跑Oracle 10g Standard Edition （10g SE）时，Oracle的每个过程最多只能占有1个（虚拟）CPU的处理能力，也就是最大能使用整个CPU的1/32的能力。
而以前的V240服务器，虽然只有2个物理CPU，但每个过程可独享1个CPU，这就是说最大能使用整个CPU的1/2的能力。
在月末处理时，V240的CPU使用率在1号前后的大约1周时间经常达到80%以上，有时候甚至达到100%。
但是，自从移到T5220后，CPU的最大使用率从来都在18%左右。用户也抱怨这款贵且慢的服务器。
对于多线程，并发处理等，T5220可能比较好，对于处理相对集中的公司业务，T5220不是个好的选择。
为了给行政方面证明以上结论，借用VM服务器的一角，对T5220和X86，就现行的Oracle系统做了一番性能比较。
1. 调查对象服务器的构成
| T5220 |
X86 |
|
| CPU |
UltraSPARC T2 |
Virtual X86 |
|
速度 |
1.2G |
2.5G |
|
个数 |
4芯/32线程 |
2 |
|
Memory |
16G |
16G |
|
OS |
Solaris 10 |
Solaris 11 |
|
DB |
Oracle 10g |
Oracle 11g |
2. Oracle性能比较
2.1 Batch处理
x86比T5220要快7.5-9.7倍。
|
T5220 （分） |
X86 (分） |
Ratio （T5220/X86) |
|
|
Apex 4.1.1安装时间 |
83 |
11 |
7.5 |
|
主要记账系统処理時間 |
61 |
6.3 |
9.7 |
|
主要业务数据的Upload |
25 |
3 |
8.3 |
2.2 APEX的Web页面
Application A 的重负荷页面的显示时间X86要快1.7倍到9.3倍。
Application B也有显著改善，从5.4到43倍不等。
|
|
|
|
|
T5220 |
|
X86 |
|
||
|
ID |
Name |
Page Name |
|
Freq. |
Time(s) |
|
Freq. |
Time(s) |
Ratio |
|
107 |
Appli.A |
INFO_LIST |
|
315 |
1.03 |
|
3 |
0.62 |
1.7 |
|
107 |
Appli.A |
Contract Management |
|
576 |
1.7 |
|
3 |
0.51 |
3.3 |
|
107 |
Appli.A |
SALES |
|
776 |
2.85 |
|
4 |
0.56 |
5.1 |
|
107 |
Appli.A |
APPROVE |
|
5 |
1.3 |
|
2 |
0.22 |
5.9 |
|
107 |
Appli.A |
Seminar Enrolments |
|
48 |
1.46 |
|
3 |
0.24 |
6.1 |
|
107 |
Appli.A |
I-company Order |
|
7 |
2.18 |
|
3 |
0.32 |
6.8 |
|
107 |
Appli.A |
BizCase-Real Time |
|
605 |
1.43 |
|
5 |
0.2 |
7.2 |
|
107 |
Appli.A |
BizCase Summary |
|
24 |
3.25 |
|
2 |
0.35 |
9.3 |
|
|
|
|
|
|
|
|
|
|
|
|
104 |
Appli.B |
Application Form I |
|
2 |
7.23 |
|
6 |
0.68 |
10.6 |
|
104 |
Appli.B |
Detail Information II |
|
4 |
4.74 |
|
6 |
0.11 |
43.1 |
|
104 |
Appli.B |
Detail Information I |
|
4 |
3.68 |
|
6 |
0.68 |
5.4 |
|
104 |
Appli.B |
Application Form II |
|
4 |
1.37 |
|
6 |
0.19 |
7.2 |
2.3 C Compiler
SAPRC系统上的C程序在X86上编译/执行未发现问题。
3. HDD的写入速度*
因为使用VM的缘故，X86的写入速度要比T5220慢。
（VM Host服务器使用转速10k的SAS型HDD。）
|
|
from |
to |
Size (MB) |
time (s) |
Speed (MB/s) |
|
X86 |
Scsi Disk 1 |
Scsi Disk 2 |
1236 |
63 |
19.6 |
|
T5220 |
Scsi Disk 1 |
Scsi Disk 2 |
1109 |
8 |
138.6 |
4. 结论
T5220的处理速度是整个系统的瓶颈。
在X86 CPU上运行在Sparc CPU上的系统未出现功能问题。
本测试中使用的X86服务器比T5220服务器要快得多。
5. 参考资料（服务器选型辅助信息）
Solaris 11 Hardware Compatibility List: （按厂家排序）
http://www.oracle.com/webfolder/technetwork/hcl/data/s11ga/systems/views/nonoracle_systems_servers.mfg.page1.html
MySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AMMySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.
MySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AMMySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.
MySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AMMySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.
The Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AMSQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.
MySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AMThe basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA
MySQL's Role: Databases in Web ApplicationsApr 17, 2025 am 12:23 AMThe main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
MySQL: Building Your First DatabaseApr 17, 2025 am 12:22 AMThe steps to build a MySQL database include: 1. Create a database and table, 2. Insert data, and 3. Conduct queries. First, use the CREATEDATABASE and CREATETABLE statements to create the database and table, then use the INSERTINTO statement to insert the data, and finally use the SELECT statement to query the data.
MySQL: A Beginner-Friendly Approach to Data StorageApr 17, 2025 am 12:21 AMMySQL is suitable for beginners because it is easy to use and powerful. 1.MySQL is a relational database, and uses SQL for CRUD operations. 2. It is simple to install and requires the root user password to be configured. 3. Use INSERT, UPDATE, DELETE, and SELECT to perform data operations. 4. ORDERBY, WHERE and JOIN can be used for complex queries. 5. Debugging requires checking the syntax and use EXPLAIN to analyze the query. 6. Optimization suggestions include using indexes, choosing the right data type and good programming habits.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
SublimeText3 English version
Recommended: Win version, supports code prompts!
SublimeText3 Chinese version
Chinese version, very easy to use
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
