ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RAC中一次混乱的性能诊断过程3

RAC中一次混乱的性能诊断过程3

原创 Linux操作系统 作者:gaopengtttt 时间:2011-07-13 16:55:41 0 删除 编辑

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • Total Buffer Gets: 584,021,980
  • Captured SQL account for 32.1% of Total

Buffer Gets

Executions

Gets per Exec

%Total

CPU Time (s)

Elapsed Time (s)

SQL Id

SQL Module

SQL Text

17,941,301

10

1,794,130.10

3.07

60.59

66.10

5pa6u5dtnucaq

 

SELECT * FROM ( Select RowNum ...

17,941,301

10

1,794,130.10

3.07

58.65

65.59

7jnkm6r7t5ams

 

SELECT COUNT(*) FROM TEST1...

12,532,568

7

1,790,366.86

2.15

43.76

45.18

3ywk3pt184rtb

 

SELECT * FROM ( Select RowNum ...

12,532,548

7

1,790,364.00

2.15

43.05

45.91

6kwkbk30jkha1

 

SELECT COUNT(*) FROM TEST1...

8,932,380

5

1,786,476.00

1.53

29.04

31.14

222xvfg4415z0

 

SELECT COUNT(*) FROM TEST1...

8,932,379

5

1,786,475.80

1.53

29.90

30.93

1z29z7p07uf7p

 

SELECT * FROM ( Select RowNum ...

8,915,316

5

1,783,063.20

1.53

30.75

32.61

5qhnyr92d96sm

 

SELECT COUNT(*) FROM TEST1...

8,915,315

5

1,783,063.00

1.53

33.06

32.80

0h7fsx5a8r3sn

 

SELECT * FROM ( Select RowNum ...

8,900,709

5

1,780,141.80

1.52

29.95

31.08

cmn1tb40sud9b

 

SELECT * FROM ( Select RowNum ...

8,900,701

5

1,780,140.20

1.52

29.24

31.55

bq5ur4q4r6m6b

 

SELECT COUNT(*) FROM  TEST1...

6,705,179

1

6,705,179.00

1.15

53.53

57.80

7a9cd2xa25yab

 

SELECT * FROM ( Select RowNum ...

 

通过分析这里可能出现问题,因为SQL都是差不多或者说引用的对象都差不多,我最开始想如果能够找到方法减少这里的逻辑读,那问题一定能够改善,接着直接查看逻辑读最多的SEGMENT

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-702110/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
wxh gp_22389860 <<深入理解MySQL主从原理专栏>> 发布 可加WX了解

注册时间:2008-10-13

  • 博文量
    739
  • 访问量
    3140879