1. 首页
  2. IT资讯

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

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
  • Total DB Time (s): 5,870
  • Captured SQL account for 16.7% of Total

Elapsed Time (s)

CPU Time (s)

Executions

Elap per Exec (s)

% Total DB Time

SQL Id

SQL Module

SQL Text

66

61

10

6.61

1.13

5pa6u5dtnucaq

 

SELECT * FROM ( Select RowNum …

66

59

10

6.56

1.12

7jnkm6r7t5ams

 

SELECT COUNT(*) FROM TEST1…

58

54

1

57.80

0.98

7a9cd2xa25yab

 

SELECT * FROM ( Select RowNum …

46

43

7

6.56

0.78

6kwkbk30jkha1

 

SELECT COUNT(*) FROM TEST1 …

45

44

7

6.45

0.77

3ywk3pt184rtb

 

SELECT * FROM ( Select RowNum …

37

25

3

12.24

0.63

9xwa8z12j7t70

 

select ti.serialno itemNo, ti….

33

33

5

6.56

0.56

0h7fsx5a8r3sn

 

SELECT * FROM ( Select RowNum …

33

31

5

6.52

0.56

5qhnyr92d96sm

 

SELECT COUNT(*) FROM TEST1 …

32

29

58

0.55

0.54

2z3p2wf0daumf

 

SELECT DISTINCT Wflog.* FROM W…

32

29

5

6.31

0.54

bq5ur4q4r6m6b

 

SELECT COUNT(*) FROM TEST1 …

结果可以看到基本没有特别耗时的SQL,所以想通过优化单个SQL来大幅度提高性能的想法是不能实现的,然后进入查看最多逻辑读取的SQL

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

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

联系我们

13687733322

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

邮件:1877088071@qq.com

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

QR code