clog oracle,Hard Parse Time - too long...

最新推荐文章于 2023-11-16 17:23:12 发布
最新推荐文章于 2023-11-16 17:23:12 发布
阅读量122 收藏
点赞数
文章标签： clog oracle

Yes, this is for one query. On a flushed DB (buffer pool/shared pool), a single query was executed in a SQLPlus window. Keeping the window open (to be able to track its SID), SYSTEM account was used to execute:

select * from V$SESS_TIME_MODEL where SID=NN;Among other values, here are the ones reported:

STAT_NAMEVALUE

DB time48533918

DB CPU42158590

parse time elapsed45739291

hard parse elapsed time45734101

PL/SQL execution elapsed time247

inbound PL/SQL rpc elapsed time0

PL/SQL compilation elapsed time7151

Java execution elapsed time0

repeated bind elapsed time1500

RMAN cpu time (backup/restore)0

Statistics are up to date (100% sampling).

Query is long:

SELECT

COUNT (DISTINCT ent_000000.pk)

FROM entity ent_000000

INNER JOIN recordtextvalue val_000002

ON val_000002.sourceentityfk = ent_000000.pk

AND val_000002.fieldfk = HEXTORAW ('80B58FEACC79E011AD2400155D018001')

AND ( LOWER (val_000002.VALUE) LIKE LOWER ('%1%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%2%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%3%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%4%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%5%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%6%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%7%') ESCAPE '~'

OR LOWER (val_000002.VALUE) LIKE LOWER ('%8%') ESCAPE '~'

)

INNER JOIN recordsinglechoicevalue val_000012

ON val_000012.sourceentityfk = ent_000000.pk

AND val_000012.fieldfk = HEXTORAW ('8DB58FEACC79E011AD2400155D018001')

INNER JOIN record_ rec_000014

ON rec_000014.pk = val_000012.recordfk

AND rec_000014.entityfk = val_000012.sourceentityfk

AND rec_000014.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

INNER JOIN

(SELECT

MAX (rec_000016.TIMESTAMP) AS TIMESTAMP,

rec_000016.entityfk AS groupkey

FROM record_ rec_000016

INNER JOIN recordsinglechoicevalue val_000018

ON val_000018.recordfk = rec_000016.pk

AND val_000018.sourceentityfk = rec_000016.entityfk

AND val_000018.fieldfk = HEXTORAW ('8DB58FEACC79E011AD2400155D018001')

WHERE 1 = 1

AND rec_000016.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

GROUP BY rec_000016.entityfk

) tbl_000020

ON tbl_000020.TIMESTAMP = rec_000014.TIMESTAMP

AND tbl_000020.groupkey = rec_000014.entityfk

INNER JOIN recordsinglechoicevalue val_000021

ON val_000021.sourceentityfk = ent_000000.pk

AND val_000021.fieldfk = HEXTORAW ('AF5F45338C58DE4CB3833AD9D54351A7')

INNER JOIN record_ rec_000023

ON rec_000023.pk = val_000021.recordfk

AND rec_000023.entityfk = val_000021.sourceentityfk

AND rec_000023.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

JOIN

(SELECT MIN (rec_000025.TIMESTAMP) AS TIMESTAMP, rec_000025.entityfk AS groupkey

FROM record_ rec_000025 INNER JOIN recordsinglechoicevalue val_000027

ON val_000027.recordfk = rec_000025.pk

AND val_000027.sourceentityfk = rec_000025.entityfk

AND val_000027.fieldfk = HEXTORAW ('AF5F45338C58DE4CB3833AD9D54351A7')

WHERE 1 = 1 AND rec_000025.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

GROUP BY rec_000025.entityfk) tbl_000029

ON tbl_000029.TIMESTAMP = rec_000023.TIMESTAMP

AND tbl_000029.groupkey = rec_000023.entityfk

AND val_000021.choicefk IN

(HEXTORAW ('A038588B67E6C6418360E92AB231EA30'),

HEXTORAW ('DA6E7059FB243F40B97CF91BA75EE532'),

HEXTORAW ('DA6BE7C37D157A4BBD34032F76983916')

)

INNER JOIN record_ val_000033

ON val_000033.pk = rec_000023.pk

AND val_000033.entityfk = rec_000023.entityfk

AND val_000033.TIMESTAMP IS NOT NULL

AND val_000033.recordtypefk IN (SELECT rt.pk

FROM recordtype rt JOIN recordtypemember rtm ON rtm.recordtypefk = rt.pk

WHERE rtm.fieldfk = HEXTORAW ('83B58FEACC79E011AD2400155D018001'))

AND val_000033.TIMESTAMP >= TO_DATE ('1/1/1925 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')

INNER JOIN recordsinglechoicevalue val_000036

ON val_000036.sourceentityfk = ent_000000.pk

AND val_000036.fieldfk = HEXTORAW ('125A01C9DAF726448D8DB1F7B27091DE')

INNER JOIN record_ rec_000038

ON rec_000038.pk = val_000036.recordfk

AND rec_000038.entityfk = val_000036.sourceentityfk

AND rec_000038.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

JOIN

(SELECT MIN (rec_000040.TIMESTAMP) AS TIMESTAMP, rec_000040.entityfk AS groupkey

FROM record_ rec_000040 INNER JOIN recordsinglechoicevalue val_000042

ON val_000042.recordfk = rec_000040.pk

AND val_000042.sourceentityfk = rec_000040.entityfk

AND val_000042.fieldfk = HEXTORAW ('125A01C9DAF726448D8DB1F7B27091DE')

WHERE 1 = 1 AND rec_000040.recordtypefk = HEXTORAW ('7EB58FEACC79E011AD2400155D018001')

GROUP BY rec_000040.entityfk) tbl_000044

ON tbl_000044.TIMESTAMP = rec_000038.TIMESTAMP

AND tbl_000044.groupkey = rec_000038.entityfk

AND val_000036.choicefk IN

(HEXTORAW ('9DDEB479A5F44C4AB9C03B0FBE2CCD89'),

HEXTORAW ('723CBD322AB52B439E9160F29BB27E17'),

HEXTORAW ('492F484AD5FED04893F82F4824F1B5E2'),

HEXTORAW ('C3F9C1F514AFB146A0F4BABAA2577B84')

)

INNER JOIN record_ val_000049

ON val_000049.entityfk = ent_000000.pk

AND 'Diagnosis' IS NOT NULL

AND val_000049.recordtypefk IN (SELECT rt.pk

FROM recordtype rt JOIN recordtypemember rtm ON rtm.recordtypefk = rt.pk

WHERE rtm.fieldfk = HEXTORAW ('F85D675BF5D04448A608F9479A653BD3'))

WHERE 1 = 1

AND ent_000000.entitytypefk = HEXTORAW ('66B9B948F000DB1192370014A5726350')

;... and here is the explain plan for it:

Execution Plan

----------------------------------------------------------

Plan hash value: 1632407278

-----------------------------------------------------------------------------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |

-----------------------------------------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | 1 | 10 | 1331 (6)| 00:00:01 | | |

| 1 | SORT AGGREGATE | | 1 | 10 | | | | |

| 2 | VIEW | VM_NWVW_1 | 1 | 10 | 1331 (6)| 00:00:01 | | |

| 3 | HASH GROUP BY | | 1 | 581 | 1331 (6)| 00:00:01 | | |

| 4 | NESTED LOOPS | | 1 | 581 | 1330 (6)| 00:00:01 | | |

| 5 | NESTED LOOPS | | 1 | 568 | 1326 (6)| 00:00:01 | | |

| 6 | NESTED LOOPS | | 1 | 515 | 1324 (6)| 00:00:01 | | |

| 7 | NESTED LOOPS | | 1 | 502 | 1319 (6)| 00:00:01 | | |

| 8 | NESTED LOOPS SEMI | | 1 | 449 | 1317 (6)| 00:00:01 | | |

| 9 | NESTED LOOPS | | 1 | 415 | 1316 (6)| 00:00:01 | | |

| 10 | NESTED LOOPS | | 1 | 402 | 1311 (6)| 00:00:01 | | |

| 11 | NESTED LOOPS | | 4 | 1396 | 1303 (6)| 00:00:01 | | |

| 12 | NESTED LOOPS | | 4 | 1156 | 1295 (6)| 00:00:01 | | |

|* 13 | HASH JOIN | | 4 | 952 | 1291 (6)| 00:00:01 | | |

|* 14 | HASH JOIN | | 21 | 3570 | 1284 (6)| 00:00:01 | | |

| 15 | PARTITION HASH SINGLE | | 293 | 19924 | 4 (0)| 00:00:01 | 98 | 98 |

| 16 | INLIST ITERATOR | | | | | | | |

|* 17 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_CFER_IDX | 293 | 19924 | 4 (0)| 00:00:01 | 98 | 98 |

|* 18 | HASH JOIN | | 1186 | 118K| 1280 (6)| 00:00:01 | | |

|* 19 | INDEX RANGE SCAN | ENTITY_TYPE_PK_IDX | 16538 | 549K| 19 (6)| 00:00:01 | | |

| 20 | NESTED LOOPS | | 146K| 9749K| 1257 (6)| 00:00:01 | | |

| 21 | SORT UNIQUE | | 1 | 34 | 2 (0)| 00:00:01 | | |

|* 22 | INDEX RANGE SCAN | RDTYPEMEMBER_FIELD_RDTYPE_IDX | 1 | 34 | 2 (0)| 00:00:01 | | |

|* 23 | INDEX RANGE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 141K| 4693K| 1254 (6)| 00:00:01 | | |

| 24 | PARTITION HASH SINGLE | | 3300 | 219K| 6 (0)| 00:00:01 | 30 | 30 |

| 25 | INLIST ITERATOR | | | | | | | |

|* 26 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_CFER_IDX | 3300 | 219K| 6 (0)| 00:00:01 | 30 | 30 |

| 27 | PARTITION HASH SINGLE | | 1 | 51 | 1 (0)| 00:00:01 | 9 | 9 |

|* 28 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_EFR_IDX | 1 | 51 | 1 (0)| 00:00:01 | 9 | 9 |

| 29 | PARTITION HASH SINGLE | | 1 | 60 | 2 (0)| 00:00:01 | 5 | 5 |

|* 30 | TABLE ACCESS BY LOCAL INDEX ROWID| RECORDTEXTVALUE | 1 | 60 | 2 (0)| 00:00:01 | 5 | 5 |

|* 31 | INDEX RANGE SCAN | RDTEXTVALUE_EFR_IDX | 1 | | 1 (0)| 00:00:01 | 5 | 5 |

|* 32 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

|* 33 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

|* 34 | VIEW PUSHED PREDICATE | | 1 | 13 | 5 (20)| 00:00:01 | | |

|* 35 | FILTER | | | | | | | |

| 36 | SORT AGGREGATE | | 1 | 73 | | | | |

| 37 | NESTED LOOPS | | | | | | | |

| 38 | NESTED LOOPS | | 1 | 73 | 5 (20)| 00:00:01 | | |

| 39 | VIEW | VW_GBF_11 | 1 | 20 | 3 (34)| 00:00:01 | | |

| 40 | SORT GROUP BY | | 1 | 51 | 3 (34)| 00:00:01 | | |

| 41 | PARTITION HASH SINGLE | | 1 | 51 | 2 (0)| 00:00:01 | 98 | 98 |

|* 42 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_EFR_IDX | 1 | 51 | 2 (0)| 00:00:01 | 98 | 98 |

|* 43 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

| 44 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

|* 45 | INDEX RANGE SCAN | RDTYPEMEMBER_FIELD_RDTYPE_IDX | 1 | 34 | 1 (0)| 00:00:01 | | |

|* 46 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

|* 47 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

|* 48 | VIEW PUSHED PREDICATE | | 1 | 13 | 5 (20)| 00:00:01 | | |

|* 49 | FILTER | | | | | | | |

| 50 | SORT AGGREGATE | | 1 | 73 | | | | |

| 51 | NESTED LOOPS | | | | | | | |

| 52 | NESTED LOOPS | | 1 | 73 | 5 (20)| 00:00:01 | | |

| 53 | VIEW | VW_GBF_17 | 1 | 20 | 3 (34)| 00:00:01 | | |

| 54 | SORT GROUP BY | | 1 | 51 | 3 (34)| 00:00:01 | | |

| 55 | PARTITION HASH SINGLE | | 1 | 51 | 2 (0)| 00:00:01 | 30 | 30 |

|* 56 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_EFR_IDX | 1 | 51 | 2 (0)| 00:00:01 | 30 | 30 |

|* 57 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

| 58 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

|* 59 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

|* 60 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

|* 61 | VIEW PUSHED PREDICATE | | 1 | 13 | 4 (0)| 00:00:01 | | |

|* 62 | FILTER | | | | | | | |

| 63 | SORT AGGREGATE | | 1 | 104 | | | | |

| 64 | NESTED LOOPS | | | | | | | |

| 65 | NESTED LOOPS | | 1 | 104 | 4 (0)| 00:00:01 | | |

| 66 | PARTITION HASH SINGLE | | 1 | 51 | 2 (0)| 00:00:01 | 9 | 9 |

|* 67 | INDEX RANGE SCAN | RDSINGLECHOICEVALUE_EFR_IDX | 1 | 51 | 2 (0)| 00:00:01 | 9 | 9 |

|* 68 | INDEX UNIQUE SCAN | RECORD_TYPE_ENTITY_PK_IDX | 1 | | 1 (0)| 00:00:01 | | |

| 69 | TABLE ACCESS BY INDEX ROWID | RECORD_ | 1 | 53 | 2 (0)| 00:00:01 | | |

-----------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

13 - access("VAL_000036"."SOURCEENTITYFK"="ENT_000000"."PK")

14 - access("VAL_000021"."SOURCEENTITYFK"="ENT_000000"."PK")

17 - access(("VAL_000021"."CHOICEFK"=HEXTORAW('A038588B67E6C6418360E92AB231EA30') OR

"VAL_000021"."CHOICEFK"=HEXTORAW('DA6BE7C37D157A4BBD34032F76983916') OR

"VAL_000021"."CHOICEFK"=HEXTORAW('DA6E7059FB243F40B97CF91BA75EE532') ) AND

"VAL_000021"."FIELDFK"=HEXTORAW('AF5F45338C58DE4CB3833AD9D54351A7') )

18 - access("VAL_000049"."ENTITYFK"="ENT_000000"."PK")

19 - access("ENT_000000"."ENTITYTYPEFK"=HEXTORAW('66B9B948F000DB1192370014A5726350') )

22 - access("RTM"."FIELDFK"=HEXTORAW('F85D675BF5D04448A608F9479A653BD3') )

23 - access("VAL_000049"."RECORDTYPEFK"="RTM"."RECORDTYPEFK")

26 - access(("VAL_000036"."CHOICEFK"=HEXTORAW('492F484AD5FED04893F82F4824F1B5E2') OR

"VAL_000036"."CHOICEFK"=HEXTORAW('723CBD322AB52B439E9160F29BB27E17') OR

"VAL_000036"."CHOICEFK"=HEXTORAW('9DDEB479A5F44C4AB9C03B0FBE2CCD89') OR

"VAL_000036"."CHOICEFK"=HEXTORAW('C3F9C1F514AFB146A0F4BABAA2577B84') ) AND

"VAL_000036"."FIELDFK"=HEXTORAW('125A01C9DAF726448D8DB1F7B27091DE') )

28 - access("VAL_000012"."SOURCEENTITYFK"="ENT_000000"."PK" AND "VAL_000012"."FIELDFK"=HEXTORAW('8DB58FEACC79E011AD2400155D018001') )

30 - filter(LOWER("VAL_000002"."VALUE") LIKE U'%1%' ESCAPE U'~' OR LOWER("VAL_000002"."VALUE") LIKE U'%2%' ESCAPE U'~' OR

LOWER("VAL_000002"."VALUE") LIKE U'%3%' ESCAPE U'~' OR LOWER("VAL_000002"."VALUE") LIKE U'%4%' ESCAPE U'~' OR

LOWER("VAL_000002"."VALUE") LIKE U'%5%' ESCAPE U'~' OR LOWER("VAL_000002"."VALUE") LIKE U'%6%' ESCAPE U'~' OR

LOWER("VAL_000002"."VALUE") LIKE U'%7%' ESCAPE U'~' OR LOWER("VAL_000002"."VALUE") LIKE U'%8%' ESCAPE U'~')

31 - access("VAL_000002"."SOURCEENTITYFK"="ENT_000000"."PK" AND "VAL_000002"."FIELDFK"=HEXTORAW('80B58FEACC79E011AD2400155D018001') )

32 - filter("VAL_000033"."TIMESTAMP">=TIMESTAMP' 1925-01-01 00:00:00')

33 - access("RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND "ENTITYFK"="VAL_000021"."SOURCEENTITYFK" AND

"VAL_000021"."RECORDFK"="VAL_000033"."PK")

34 - filter("TBL_000029"."TIMESTAMP"="TIMESTAMP")

35 - filter(COUNT(*)>0 AND MIN("REC_000025"."TIMESTAMP")>=TIMESTAMP' 1925-01-01 00:00:00')

42 - access("VAL_000027"."SOURCEENTITYFK"="ENTITYFK" AND "VAL_000027"."FIELDFK"=HEXTORAW('AF5F45338C58DE4CB3833AD9D54351A7') )

43 - access("REC_000025"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND "REC_000025"."ENTITYFK"="ENTITYFK" AND

"ITEM_2"="REC_000025"."PK")

filter("ITEM_1"="REC_000025"."ENTITYFK")

45 - access("RTM"."FIELDFK"=HEXTORAW('83B58FEACC79E011AD2400155D018001') AND

"RTM"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') )

filter("VAL_000033"."RECORDTYPEFK"="RTM"."RECORDTYPEFK")

46 - filter("REC_000038"."TIMESTAMP" IS NOT NULL)

47 - access("REC_000038"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND

"REC_000038"."ENTITYFK"="VAL_000036"."SOURCEENTITYFK" AND "REC_000038"."PK"="VAL_000036"."RECORDFK")

48 - filter("TBL_000044"."TIMESTAMP"="REC_000038"."TIMESTAMP")

49 - filter(COUNT(*)>0)

56 - access("VAL_000042"."SOURCEENTITYFK"="REC_000038"."ENTITYFK" AND

"VAL_000042"."FIELDFK"=HEXTORAW('125A01C9DAF726448D8DB1F7B27091DE') )

57 - access("REC_000040"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND

"REC_000040"."ENTITYFK"="REC_000038"."ENTITYFK" AND "ITEM_2"="REC_000040"."PK")

filter("ITEM_1"="REC_000040"."ENTITYFK")

59 - filter("REC_000014"."TIMESTAMP" IS NOT NULL)

60 - access("REC_000014"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND

"REC_000014"."ENTITYFK"="VAL_000012"."SOURCEENTITYFK" AND "REC_000014"."PK"="VAL_000012"."RECORDFK")

61 - filter("TBL_000020"."TIMESTAMP"="REC_000014"."TIMESTAMP")

62 - filter(COUNT(*)>0)

67 - access("VAL_000018"."SOURCEENTITYFK"="REC_000014"."ENTITYFK" AND

"VAL_000018"."FIELDFK"=HEXTORAW('8DB58FEACC79E011AD2400155D018001') )

68 - access("REC_000016"."RECORDTYPEFK"=HEXTORAW('7EB58FEACC79E011AD2400155D018001') AND

"REC_000016"."ENTITYFK"="REC_000014"."ENTITYFK" AND "VAL_000018"."RECORDFK"="REC_000016"."PK")

filter("VAL_000018"."SOURCEENTITYFK"="REC_000016"."ENTITYFK")

Note

-----

- dynamic sampling used for this statement (level=4)

- automatic DOP: Computed Degree of Parallelism is 1 because of parallel threshold

Statistics

----------------------------------------------------------

0 recursive calls

0 db block gets

30331 consistent gets

0 physical reads

0 redo size

367 bytes sent via SQL*Net to client

364 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

5179 sorts (memory)

0 sorts (disk)

1 rows processed

SQL>Record***Value tables are all partitioned by FieldFk (64 partitions by hash).

Thank you!

--Alex

Edited by: al**** on Oct 12, 2012 6:15 PM

Edited by: al**** on Oct 12, 2012 6:16 PM

Edited by: al**** on Oct 12, 2012 6:17 PM

Edited by: al**** on Oct 12, 2012 6:17 PM

Rhfj
关注
Oracle 分区执行计划详解
Richie's 残酷舞台
09-17 3042
Part1. 分区执行计划的区别 在F5中查看执行计划的时候总是看到很多信息: range分区 执行计划中出现的： 分区表，按 n1 ,n2 分区 partition range single:访问单个分区 partition range iterator:访问多个分区 ---执行计划中的 PSTART/PSTOP 值代表什么 KEY...
ACM模式输入输出攻略 - C++篇.pdf
最新发布
02-22
除了`cout`之外，C++还提供了其他输出方式，如`printf()`、`clog`和`cerr`等，但在大多数笔试和面试场景中，掌握`cout`就已经足够了。 #### 三、案例介绍 在笔试面试中，常常会遇到需要自己编写输入输出的情况。...
Oracle Metric hard parse (sharing criteria) elapsed time
Vincent的专栏
12-18 1615
hard parse (sharing criteria) elapsed time解析  hard parse (sharing criteria) elapsed time 是ORACLE的度量标准，由于SQL不能共享已经在SQL cache中存在的游标导致重新硬解析所消耗的时间   当sql必须重新载入共享池的时候产生硬解析。硬解析是万恶之源因为耗费共享池RAM分配和内存管理。一旦
一个长时间parse的bug解决过程
wanqisheng的专栏
10-17 1491
开发同事说一个sql运行2个多小时没有返回,问是否存在异常. 简单检查后(我的工作记录中忘记记录当时session的等待事件), 1. 发现这个sql消耗1个cpu的100%时间. 2. 检查v$sql发现PLAN_HASH_VALUE为0,在v$sql_plan中也不存在对应sql_id的执行计划信息. 3. 使用pl/sql developer查看这个sql的执行计划时,一直没有显示,
一次hard parse处理过程
weixin_43230594的博客
08-23 372
记录一次hard parse引起enq: TX - row lock contention的处理过程
oracle分区表的分区执行计划的几种扫描类型
viviliving的专栏
11-16 474
partition range inlist: 分区键中用了in 例如： where n1 in(X1,X2) and n2=X3。比range少了partition range or和partition range multi-column。partition range or: 分区键中用了or 例如 where n1=X1 or n2=X2。---1、partition list inlist 不连续分区扫描。---2、partition list inlist 不连续分区扫描。
cppreference-zh-20190405.rar
09-18
- iostream库，包括cin、cout、cerr、clog等用于文本输入输出。 - 文件输入/输出流（fstream）：读写磁盘文件。 8. **C++11及以后的更新**： - Lambda表达式：用于创建匿名函数，简化回调和并行编程。 -右值...
C++模拟试题_1-2.docx
02-27
1. **预定义流对象**：C++标准库中预定义了四个对象，用于标准数据流操作，它们是`cin`（输入流）、`cout`（输出流）、`cerr`（错误输出流）和`clog`（日志错误输出流）。题目中提到的`cset`不属于预定义的流对象。 ...
C++模拟试题_1-2.pdf
02-27
1. **标准数据流对象**：C++预定义了四个标准数据流对象，分别是`cin`（输入流）、`cout`（输出流）、`cerr`（未缓冲的标准错误流）和`clog`（缓冲的标准错误流）。题目中提到的`cset`不是标准数据流对象，因此正确...
[南开大学]21春学期(1709-2103)《程序设计基础(下)》在线作业-答案2.pdf
12-06
`cin`是输入流对象，`cerr`和`clog`是错误输出流对象，而`cout`是标准输出流对象，用于输出到控制台。选项A的`cin`不属于`ostream`类，因此是正确答案。 4. **面向对象特性**：面向对象编程的三大核心特性是封装、...
Oracle 执行计划优化
hellojoy的博客
06-13 2081
Oracle分区执行计划   range分区可用的操作：  分区表，按 n1 ,n2 分区 partition range single:访问单个分区 partition range iterator:访问多个分区 partition range inlist: 分区键中用了in   例如： where n1 in(X1,X2) and n2=X3 partition ran
多列分区
minwang593的专栏
10-17 1058
范围分区 range(A,B)的分区法则，范围分区都是 values less than(A,B)的，通常情况下以A为准，如果小于A的不用考虑B，直接插进去，如果等于A那么考虑B，要是满足B的话也插进去。
Oracle分区执行计划
塔山上的山
04-27 1721
range分区可用的操作： 分区表，按 n1 ,n2 分区   partition range single:访问单个分区 partition range iterator:访问多个分区  partition range inlist: 分区键中用了in   例如： where n1 in(X1,X2) and n2=X3 partition range all:  所有的分区  p
oracle 里分区执行,Oracle分区执行计划
weixin_35814757的博客
04-14 425
Oracle分区执行计划range分区可用的操作： www.2cto.com分区表，按 n1 ,n2 分区partition range single:访问单个分区partition range iterator:访问多个分区partition range inlist: 分区键中用了in 例如： where n1 in(X1,X2) and n2=X3partition range all...
分区字段对分区键字段转换是不会走partition range single
minwang593的专栏
10-28 3207
1  创建分区表             create table PP_SENDLIST (   FCCODE   VARCHAR2(4) not null,   PLCODE   VARCHAR2(10) not null,   MONUM    VARCHAR2(12) not null,   CPCODE   VARCHAR2(18) not null,   CPQTY  
深入解析partition-hash分区
crbzijz188696507的博客
03-12 665
依据惯例，先看官网对hash partition的解释 Hash partitioning enables easy partitioning of data that does not lend itself...
数据库压测指标的一点理解
Lixora's DB Home
07-31 2347
Read iops: 应用运行过程中物理读请求次数，单位是数据库一个block ，主要是server 进程读到buffer cache 或者pga 中数据块数 ； Write iops: 应用运行过程中物理写请求次数，单位是数据库一个block；包含备份恢复及数据库其他组件操作过程中导致的物理写次数； 物理写： 数据库应用的写吞吐，是通过写次数乘以block size 换算出来的； 物...
通过案例学调优之--Oracle Time Model（时间模型）
weixin_34187822的博客
12-25 308
通过案例学调优之--Oracle Time Model（时间模型）数据库时间 优化不仅仅是缩短等待时间。优化旨在缩短最终用户响应时间和（或）尽可能减少每个请求占用的平均资源。有时这些目标可同时实现，而有时则需要进行折衷（如在并行查询时）。通常可以认为，优化就是避免以浪费的方式占用或保留资源。 对数据库发出的任何请求都由两个不同的段组成：等待时间（数据...
C++标准流对象详解：cin, cout, cerr, clog
这些对象包括cin、cout、cerr和clog。 在C++中，流是一种处理数据的方式，可以想象成一个无限长的二进制序列，通过读写指针进行操作。输入流允许从流中读取数据，而输出流则用于向流中写入数据。cin是标准输入流...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值