PHP Code:Event
--------------------------------------------------
0 - 1 ms 1 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms
------------ ------------ ------------ ------------ ------------ ------------
22 12 1 0 0 0
log file parallel write
21,611 636 11,463 9,485 23 7
log file sync
399 329 7,015 15,460 682 19
process startup
0 0 0 0 0 8
rdbms ipc reply
121 0 0 0 0 0
read by other session
9 13 22 5 3 0
Queue Monitor Wait
0 0 0 0 0 18
SQL*Net message from client
1,643,818 501,854 16,306 17,491 7,499 866
SQL*Net message to client
2,185,854 4 0 0 0 0
SQL*Net more data from client
4 0 0 0 0 1
dispatcher timer
0 0 0 0 0 9
jobq slave wait
0 0 0 0 0 173
pmon timer
2 0 0 0 0 182
queue messages
0 0 0 0 0 109
rdbms ipc message
5,809 1,895 2,026 3,018 3,202 7,436
smon timer
0 0 0 2 1 51
virtual circuit status
0 0 0 0 0 18
wakeup time manager
0 0 0 0 0 2
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: ORAPERF/oraperf Snaps: 720-721
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 15,614,958
-> Captured SQL accounts for 101.5% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
1,716,548 168,609 10.2 11.0 371.10 1192.95 2573386356
Module: pipe04ac
INSERT INTO SEP_CONFLICT_REL(CONFLICT_ID, MATCH_ID, PARENT_ENTIT
Y_ID, CHILD_ENTITY_ID, DEGREE_OF_SEP, LIKE_CONF, REL_CONF) VALUE
S(:1,:2,:3,:4,:5,:6,:7)
1,234,473 128,800 9.6 7.9 338.01 826.63 3352792302
Module: pipe04ac
INSERT INTO ER_DETAIL ( ER_ID, MATCHED_ENTITY_ID, MATCHED_TYPE,
MATCHED_ACCT_ID, MATCHED_KEY_ID, INBOUND_KEY_ID, SCORE_ADJUS
TMENT, MATCH_PRECISION, PRECISION_DESC ) VALUES ( :1, :2, :3, :
4, :5, :6, :7, :8, :9 )
836,101 84,352 9.9 5.4 92.10 233.17 4101062403
Module: pipe02ac
INSERT INTO SEP_CONFLICT(CONFLICT_ID, SEP_TEST_ID, INBOUND_ENTIT
Y_ID, CONFLICT_RULE_ID, CONF_ENTITY1, CONF_ENTITY2, DEGREE_OF_SE
P, CONFLICT_STAT, WEAK_LIKE_SCORE, WEAK_REL_SCORE, CONFLICT_DT)
VALUES(:1, :2,:3,:4,:5,:6,:7,:"SYS_B_0",:8,:9,:10)
687,347 112,027 6.1 4.4 162.46 447.97 1712256954
Module: pipe04ac
SELECT MAX(ROLE_ID) FROM SEP_ROLES WHERE DSRC_ACCT_ID = :1
664,889 112,006 5.9 4.3 28.36 29.64 659324044
Module: pipe04ac
INSERT INTO ER_ENTITY_STATE(ER_ID, ENTITY_ID, DSRC_ACCT_ID, MAX_
ADDR_ID, MAX_ATTR_ID, MAX_EMAIL_ID, MAX_NAME_ID, MAX_NUM_ID, MAX
_ROLE_ID) VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9)
618,954 112,046 5.5 4.0 238.26 681.01 2878966175
Module: pipe04ac
SELECT MAX(ADDR_ID) FROM ADDRESS WHERE DSRC_ACCT_ID = :1
606,310 112,028 5.4 3.9 227.12 712.55 1507829111
Module: pipe04ac
SELECT MAX(NAME_ID) FROM NAME WHERE DSRC_ACCT_ID = :1
601,716 33,515 18.0 3.9 92.53 274.08 444121366
Module: pipe03ac
INSERT INTO NUMS(NUM_ID, DSRC_ACCT_ID, ENTITY_ID, HIST_STAT, NUM
_HASH, NUM_LOCATION, NUM_STAT, NUM_STAT_DT, NUM_TYPE_ID, NUM_VAL
UE, QC_STAT, SYS_CREATE_DT, SYS_DELETE_DT, SYS_LSTUPD_DT, VALID_
FROM_DT, VALID_THRU_DT) VALUES(:1, :2, :3, :4, :5, NULL, NULL, N
ULL, :6, :7, :8, :9, NULL, :10, NULL, NULL)
598,296 112,014 5.3 3.8 275.85 815.74 728889134
Module: pipe04ac
SELECT MAX(NUM_ID) FROM NUMS WHERE DSRC_ACCT_ID = :1
SQL ordered by Gets DB/Inst: ORAPERF/oraperf Snaps: 720-721
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 15,614,958
-> Captured SQL accounts for 101.5% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
584,401 112,036 5.2 3.7 158.69 450.57 3193297599
Module: pipe04ac
SELECT MAX(ATTR_ID) FROM ATTRIBUTE WHERE DSRC_ACCT_ID = :1
547,839 42,847 12.8 3.5 94.48 1023.18 1739503172
Module: pipe01ac
INSERT INTO SEP_RELATIONS(RELATION_ID, ENTITY_ID, RELTO_ID, LIKE
_CONF, REL_CONF, DISCLOSED, MATCH_ID) VALUES(:1, :2,:3,:4,:5,:"S
YS_B_0",:6)
419,157 23,625 17.7 2.7 60.98 372.92 3253887853
Module: pipe03ac
INSERT INTO ADDRESS(ADDR_ID, ADDR1, ADDR2, ADDR3, ADDR_HASH, ADD
R_LEFTOVRS, ADDR_STAT, ADDR_STAT_DT, ADDR_TYPE, CARRIER_ROUTE, C
ITY, COMPANY_NAME, COUNTRY, COUNTRY_CODE, DLV_PROB, DPBC, DSRC_A
CCT_ID, ENTITY_ID, HIST_STAT, HOUSEHOLD_ID, JOB_TITLE, LATITUDE,
LONGITUDE, LOT_CODE, POSTAL_CODE, QC_STAT, STATE, STATE_CODE, S
394,454 12,768 30.9 2.5 53.51 180.44 3965780448
Module: pipe03ac
UPDATE DSRC_ACCT SET ENTITY_ID = :1 ,ACCT_LOADED = :"SYS_B
_0" WHERE DSRC_ACCT_ID = :2
359,915 17,501 20.6 2.3 20.47 385.33 2711563501
Module: pipe04ac
INSERT INTO NAME(NAME_ID, CULTURE, DSRC_ACCT_ID, ENTITY_ID, FIRS
T_NAME, HIST_STAT, LAST_NAME, LFN_HASH, LMN_HASH, MID_NAME, NAME
_GEN, NAME_PFX, NAME_SFX, NAME_TYPE, QC_STAT, SYS_CREATE_DT, SYS
_DELETE_DT, SYS_LSTUPD_DT, VALID_FROM_DT, VALID_THRU_DT) VALUES(
:1, NULL, :2, :3, :4, :5, :6, :7, :8, :9, NULL, NULL, NULL, :10,
337,392 48,569 6.9 2.2 15.29 15.32 3286148528
select c.name, u.name from con$ c, cdef$ cd, user$ u where c.co
n# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
337,112 21,341 15.8 2.2 83.19 344.04 3078809437
Module: pipe02ab
INSERT INTO SEP_ROLES(ROLE_ID, DISCLOSED, DSRC_ACCT_ID, ENTITY_I
D, ROLE_CODE_ID, ROLE_STAT, SYS_DELETE_DT) VALUES(:1, :2, :3, :4
, :5, :6, NULL)
325,591 17,920 18.2 2.1 48.99 168.17 1848403279
Module: pipe03ac
INSERT INTO ATTRIBUTE(ATTR_ID, ATTR_DT, ATTR_TYPE_ID, ATTR_VALUE
, DSRC_ACCT_ID, ENTITY_ID, HIST_STAT, QC_STAT, SYS_CREATE_DT, SY
S_DELETE_DT, SYS_LSTUPD_DT, VALID_FROM_DT, VALID_THRU_DT) VALUES
(:1, NULL, :2, :3, :4, :5, :6, :7, :8, NULL, :9, NULL, NULL)
302,332 17,116 17.7 1.9 32.17 417.41 2888989485
Reply With Quote