1. 首页
  2. IT资讯

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

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/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183236.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code