Geek asks and answers

Using Oracle CPUs for a Database

I am using oracle 11g and I have an application that is encoded in a Spring framework. As soon as I set up the database on the Sun fire 4170 installed on Linux, the processor load of the processor is about 80-100%, and however, when I change the same database to the Sun M3000 server installed with Unix (presumably more powerful machine), application performance goes down and processor load remains at 90-100%. I can’t understand if his application that makes such use, or his database design. It is added that the database is not relational; The application is being processed.

+3
source share
3 answers

Well, you will surely find some interesting opinions about the tubes.

Oracle does not have a genuine architecture server (others have).

Instead of performing a classic server tasks such as multithreading, caching data pages, parallel processing (splitting a request into many devices), etc. internally, he uses o / s to do all this. This means that for each user process (PL / SQL connection), there is one unix process; 1000 users means 1000 unix processes, all competing for the same resources.

You may notice that Oracle has

  • Pooling architecture (multithreaded server) since version 7 (1992).
  • cache for data pages (known as buffer cache) since forever
  • parallel query (splitting a query into many processes) since version 7.1 (1993)
  • OPS ( 6) ( 5)

, , , .

, ( ), "" , ( . , Oracle .

Oracle, , , , , - , PerformanceDBA, - , , Oracle / ASM, , .

Oracle ( dtrace, solaris) , , , , .. CPU, , , , ( , ), . " " http://www.method-r.com/downloads/cat_view/38-papers-and-articles Oracle Performance . Oracle Diagnostics, ADDM, -, AWR .

+6

.

, , " " PerformanceDBA. spring, - , . , , ​​, , , . :

1) ( dbms_monitor). 2) (-) , gather_plan_statistics. 3) (tkprof, orasrp, method-r)

.

, ADDM / AWR, , , statspack, . ADDM, , , , statspack, .

+4

M3000 - , , , . X4170 .

. - ?

The M3000 has one SPARC64 VII processor with four cores ( specifications ), while the X4170 has 1 or 2 Intel 5500 "Nehalem-EP" processors with four cores ( specifications ). I know that I would expect even more from a single Nehalem-EP processor than the M3000. Obviously, the data will be slightly different from the workload, but I know where I would put my money.

+3
source

More articles:


All Articles