Bonjour,
Des ralentissements sont survenus sur un serveur de bases de données.

Après analyse du rapport AWR (fréquence entre deux snapshots 1/4 d'heure), je constate que l'ordre sql le plus couteux (en elapsed time) est l'appel de ctx_ddl.sync_index (Synchronisation automatique d'indexes Oracle Text).
Est ce que j'ai vu juste ?
Dans tous les cas voyez vous d'autres sources de ralentissement?

Merci d'avance.

Frédéric.

rapport AWR (tronqué à "Instance activity stats")


WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
AIRS 1797501676 airs 1 10.2.0.4.0 NO W2K-APPLI12

Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 8515 15-Janv.-10 11:30:2 15 8.4
End Snap: 8516 15-Janv.-10 11:45:5 16 9.1
Elapsed: 15.51 (mins)
DB Time: 7.82 (mins)

Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 96M 96M Std Block Size: 8K
Shared Pool Size: 148M 148M Log Buffer: 2,828K

Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 6,028.79 7,222.06
Logical reads: 315.05 377.41
Block changes: 37.40 44.80
Physical reads: 3.32 3.98
Physical writes: 3.08 3.69
User calls: 2.88 3.45
Parses: 3.28 3.93
Hard parses: 0.43 0.51
Sorts: 2.38 2.85
Logons: 0.02 0.03
Executes: 8.64 10.36
Transactions: 0.83

% Blocks changed per Read: 11.87 Recursive Call %: 90.62
Rollback per transaction %: 0.00 Rows per Sort: 30.71

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.95 In-memory Sort %: 100.00
Library Hit %: 93.28 Soft Parse %: 86.98
Execute to Parse %: 62.09 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 102.67 % Non-Parse CPU: 86.79

Shared Pool Statistics Begin End
------ ------
Memory Usage %: 83.15 89.08
% SQL with executions>1: 88.26 86.35
% Memory for SQL w/exec>1: 86.88 84.33

Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
db file sequential read 3,064 403 132 85.9 User I/O
db file parallel write 1,675 370 221 78.8 System I/O
log file parallel write 783 155 198 33.0 System I/O
control file parallel write 359 79 221 16.9 System I/O
log file sync 179 63 350 13.4 Commit
-------------------------------------------------------------
Time Model Statistics DB/Inst: AIRS/airs Snaps: 8515-8516
-> Total time in database user-calls (DB Time): 469,2s
-> Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name

Statistic Name Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time 404.8 86.3
DB CPU 5.8 1.2
PL/SQL execution elapsed time 4.7 1.0
connection management call elapsed time 1.6 .3
parse time elapsed 1.0 .2
hard parse elapsed time 0.8 .2
PL/SQL compilation elapsed time 0.1 .0
sequence load elapsed time 0.0 .0
repeated bind elapsed time 0.0 .0
DB time 469.2 N/A
background elapsed time 697.4 N/A
background cpu time 1.7 N/A
-------------------------------------------------------------

Wait Class DB/Inst: AIRS/airs Snaps: 8515-8516
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc

Avg
%Time Total Wait wait Waits
Wait Class Waits -outs Time (s) (ms) /txn
-------------------- ---------------- ------ ---------------- ------- ---------
System I/O 3,977 .0 657 165 5.1
User I/O 3,066 .0 403 132 3.9
Commit 179 8.9 63 350 0.2
Concurrency 5 .0 0 6 0.0
Network 2,062 .0 0 0 2.7
Other 1 .0 0 6 0.0
-------------------------------------------------------------

Wait Events DB/Inst: AIRS/airs Snaps: 8515-8516
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
db file sequential read 3,064 .0 403 132 3.9
db file parallel write 1,675 .0 370 221 2.2
log file parallel write 783 .0 155 198 1.0
control file parallel write 359 .0 79 221 0.5
log file sync 179 8.9 63 350 0.2
control file sequential read 1,160 .0 53 45 1.5
os thread startup 5 .0 0 6 0.0
db file scattered read 2 .0 0 12 0.0
SQL*Net message to client 2,057 .0 0 0 2.6
latch free 1 .0 0 6 0.0
SQL*Net more data to client 4 .0 0 0 0.0
SQL*Net more data from clien 1 .0 0 0 0.0
SQL*Net message from client 2,056 .0 1,057 514 2.6
virtual circuit status 31 100.0 930 30002 0.0
jobq slave wait 312 95.8 930 2980 0.4
-------------------------------------------------------------

Background Wait Events DB/Inst: AIRS/airs Snaps: 8515-8516
-> ordered by wait time desc, waits desc (idle events last)

Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
db file parallel write 1,675 .0 370 221 2.2
log file parallel write 782 .0 156 199 1.0
control file parallel write 360 .0 80 223 0.5
control file sequential read 507 .0 52 103 0.7
db file sequential read 27 .0 6 228 0.0
os thread startup 5 .0 0 6 0.0
rdbms ipc message 3,490 79.1 8,352 2393 4.5
pmon timer 318 100.0 934 2936 0.4
smon timer 119 .0 685 5755 0.2
-------------------------------------------------------------

Operating System Statistics DB/Inst: AIRS/airs Snaps: 8515-8516

Statistic Total
-------------------------------- --------------------
AVG_BUSY_TIME 5,519
AVG_IDLE_TIME 88,878
AVG_SYS_TIME 4,739
AVG_USER_TIME 780
BUSY_TIME 5,519
IDLE_TIME 88,878
SYS_TIME 4,739
USER_TIME 780
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 59,674,624
VM_OUT_BYTES 1,314,816
PHYSICAL_MEMORY_BYTES 2,146,906,112
NUM_CPU_CORES 1
NUM_CPUS 1
-------------------------------------------------------------

Service Statistics DB/Inst: AIRS/airs Snaps: 8515-8516
-> ordered by DB Time

Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
AIRS 461.6 5.7 3,021 281,689
SYS$USERS 6.5 0.2 6 5,690
AIRSXDB 0.0 0.0 0 0
SYS$BACKGROUND 0.0 0.0 36 5,404
-------------------------------------------------------------

Service Wait Class Stats DB/Inst: AIRS/airs Snaps: 8515-8516
-> Wait Class info for services in the Service Statistics section.
-> Total Waits and Time Waited displayed for the following wait
classes: User I/O, Concurrency, Administrative, Network
-> Time Waited (Wt Time) in centisecond (100th of a second)

Service Name
----------------------------------------------------------------
User I/O User I/O Concurcy Concurcy Admin Admin Network Network
Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
AIRS
3013 39694 0 0 0 0 2060 2
SYS$USERS
6 8 0 0 0 0 0 0
SYS$BACKGROUND
45 608 5 3 0 0 0 0
-------------------------------------------------------------

SQL ordered by Elapsed Time DB/Inst: AIRS/airs Snaps: 8515-8516
-> 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

Elapsed CPU Elap per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ---------- ------- -------------
349 1 2 174.6 74.4 01vu1y640n4f8
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_fic_primaire')

346 1 513 0.7 73.7 6v88sm53phx5g
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_FIC_PRIMAIRE$I" values (:token, :ttype, :fir
st, :last, :count, :data)

23 0 60 0.4 4.9 416s5s7yxj4bb
Module: corbairs_server.exe
call UPDATE_LEXIQUE_ALPHANUM (:f1 ,:f2 ,:f3 ,:f4
,:f5 ,:f6 ,:f7 ,:f8 )

19 0 60 0.3 4.1 113a4tum6c79j
Module: corbairs_server.exe
INSERT INTO VOCA_ALPHANUM (DOC_ID, LEX_ID, VOCA_FLD_ID) VALUES (:B3 , :B2 , :B1
)

7 0 3 2.2 1.4 g6xwn6rjdfdyp
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_plein_texte_context')

6 0 1 6.1 1.3 2498cgpp95c18
Module: corbairs_server.exe
CALL PROC_MAJ_PLEIN_TEXTE_HIT ('Resume',3,10792,'', :f1 )

5 0 11 0.5 1.1 8yr7su0ff5353
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_PLEIN_TEXTE_CONTEXT$I" values (:token, :ttyp
e, :first, :last, :count, :data)

3 0 73 0.0 0.6 gav0uy57wmpxd
Module: corbairs_server.exe
SELECT MOT_ID FROM MOTS_PLEIN_TEXTE WHERE VALUE = LOWER(:B1 )

2 0 5 0.4 0.5 894xnm54fv1cy
Module: corbairs_server.exe
INSERT INTO LEXIQUE_ALPHANUM (LEX_ID, VALUE, VALUE_MAJUSC, WORDPOS, ISPERMUTED,
WORDPERM, ISREDUCED, REF_LEX_ID_PERE) VALUES (:B3 , :B2 , :B1 , 0, 0, NULL, 0, 0
)

2 2 112 0.0 0.5 2a888dwvx21v4
Module: corbairs_server.exe
select count(*) from HIT_ALPHA_NUM where hit_nom_lex = 'Descripteurs' and dty_id
in (3,4,5,7,8)

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

SQL ordered by CPU Time DB/Inst: AIRS/airs Snaps: 8515-8516
-> 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

CPU Elapsed CPU per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ----------- ------- -------------
2 2 112 0.02 0.5 2a888dwvx21v4
Module: corbairs_server.exe
select count(*) from HIT_ALPHA_NUM where hit_nom_lex = 'Descripteurs' and dty_id
in (3,4,5,7,8)

1 349 2 0.66 74.4 01vu1y640n4f8
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_fic_primaire')

1 346 513 0.00 73.7 6v88sm53phx5g
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_FIC_PRIMAIRE$I" values (:token, :ttype, :fir
st, :last, :count, :data)

0 0 537 0.00 0.1 9cgyp6cvk2bt8
Module: corbairs_server.exe
begin ctxsys.drvdml.lock_opt_rebuild(:idxid, :idxpid,
ctxsys.drvdml.s_mode, null); end;

0 0 1 0.27 0.1 bunssq950snhf
insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi
d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS from v$sga_target_advice

0 0 1 0.19 0.0 dwwc6ux84ppys
Module: corbairs_server.exe
Call GETLEX ('DEREPAS LUC', 20, 0, 'Auteurs', '3,4,5,7,8',5,1)

0 0 1 0.17 0.0 80zfjwkvg9sns
Module: corbairs_server.exe
Call GETLEX ('BOULOUIS NICOLAS', 20, 0, 'Auteurs', '3,4,5,7,8',5,1)

0 23 60 0.00 4.9 416s5s7yxj4bb
Module: corbairs_server.exe
call UPDATE_LEXIQUE_ALPHANUM (:f1 ,:f2 ,:f3 ,:f4
,:f5 ,:f6 ,:f7 ,:f8 )

0 0 16 0.01 0.1 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

0 0 1 0.10 0.0 3fup80h8g2wrp
Module: corbairs_server.exe
insert into VueLexiqueAN select (rownum -1) num , X.* from ( select sum(hit_
nb), value from ( select * from ( select /*+ USE_NL(LEX HIT) */ value, hit_n
b from LEXIQUE_ALPHANUM lex, HIT_ALPHA_NUM hit where NLSSORT(VALUE_MAJUSC, 'NL
S_SORT = French') >= NLSSORT('DEREPAS LUC', 'NLS_SORT = French') and lex.Lex_Id

0 19 60 0.00 4.1 113a4tum6c79j
Module: corbairs_server.exe
INSERT INTO VOCA_ALPHANUM (DOC_ID, LEX_ID, VOCA_FLD_ID) VALUES (:B3 , :B2 , :B1
)

0 7 3 0.01 1.4 g6xwn6rjdfdyp
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_plein_texte_context')

0 6 1 0.02 1.3 2498cgpp95c18
SQL ordered by CPU Time DB/Inst: AIRS/airs Snaps: 8515-8516
-> 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

CPU Elapsed CPU per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ----------- ------- -------------
Module: corbairs_server.exe
CALL PROC_MAJ_PLEIN_TEXTE_HIT ('Resume',3,10792,'', :f1 )

0 5 11 0.00 1.1 8yr7su0ff5353
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_PLEIN_TEXTE_CONTEXT$I" values (:token, :ttyp
e, :first, :last, :count, :data)

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

SQL ordered by Gets DB/Inst: AIRS/airs Snaps: 8515-8516
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 293,249
-> Captured SQL account for 123.8% of Total

Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
56,672 112 506.0 19.3 1.83 2.18 2a888dwvx21v4
Module: corbairs_server.exe
select count(*) from HIT_ALPHA_NUM where hit_nom_lex = 'Descripteurs' and dty_id
in (3,4,5,7,8)

56,080 1 56,080.0 19.1 0.19 0.19 dwwc6ux84ppys
Module: corbairs_server.exe
Call GETLEX ('DEREPAS LUC', 20, 0, 'Auteurs', '3,4,5,7,8',5,1)

37,562 1 37,562.0 12.8 0.17 0.18 80zfjwkvg9sns
Module: corbairs_server.exe
Call GETLEX ('BOULOUIS NICOLAS', 20, 0, 'Auteurs', '3,4,5,7,8',5,1)

27,928 1 27,928.0 9.5 0.10 0.10 3fup80h8g2wrp
Module: corbairs_server.exe
insert into VueLexiqueAN select (rownum -1) num , X.* from ( select sum(hit_
nb), value from ( select * from ( select /*+ USE_NL(LEX HIT) */ value, hit_n
b from LEXIQUE_ALPHANUM lex, HIT_ALPHA_NUM hit where NLSSORT(VALUE_MAJUSC, 'NL
S_SORT = French') >= NLSSORT('DEREPAS LUC', 'NLS_SORT = French') and lex.Lex_Id

27,926 1 27,926.0 9.5 0.09 0.10 3khm9046c111s
Module: corbairs_server.exe
insert into VueLexiqueAN select (rownum -1) num , X.* from ( select sum(hit_
nb), value from ( select * from ( select /*+ USE_NL(LEX HIT) */ value, hit_n
b from LEXIQUE_ALPHANUM lex, HIT_ALPHA_NUM hit where NLSSORT(VALUE_MAJUSC, 'NL
S_SORT = French') >= NLSSORT('BOULOUIS NICOLAS', 'NLS_SORT = French') and lex.L

27,921 1 27,921.0 9.5 0.08 0.09 2cu7jbmrv7hq9
Module: corbairs_server.exe
insert into VueLexiqueAN select - rownum num , X.* from ( select sum(hit_nb)
, value from ( select * from (select /*+ USE_NL(LEX HIT) */ value, hit_nb
from LEXIQUE_ALPHANUM lex, HIT_ALPHA_NUM hit where NLSSORT(VALUE_MAJUSC, 'NLS_S
ORT = French') < NLSSORT('DEREPAS LUC', 'NLS_SORT = French') and lex.Lex_Id= hi

22,219 2 11,109.5 7.6 1.31 349.21 01vu1y640n4f8
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_fic_primaire')

18,253 513 35.6 6.2 0.58 346.03 6v88sm53phx5g
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_FIC_PRIMAIRE$I" values (:token, :ttype, :fir
st, :last, :count, :data)

13,619 2 6,809.5 4.6 0.07 0.07 4x2ukx8dxk9ab
Module: corbairs_server.exe
Call GETLEX ('P', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

9,405 1 9,405.0 3.2 0.08 0.08 4cvwphk74w15d
Module: corbairs_server.exe
insert into VueLexiqueAN select - rownum num , X.* from ( select sum(hit_nb)
, value from ( select * from (select /*+ USE_NL(LEX HIT) */ value, hit_nb
from LEXIQUE_ALPHANUM lex, HIT_ALPHA_NUM hit where NLSSORT(VALUE_MAJUSC, 'NLS_S
ORT = French') < NLSSORT('BOULOUIS NICOLAS', 'NLS_SORT = French') and lex.Lex_I

7,572 3 2,524.0 2.6 0.08 0.08 041tdxhgvjtsh
Module: corbairs_server.exe
Call GETLEX ('C', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

4,600 4 1,150.0 1.6 0.09 0.10 97wkm78xh73ax
Module: corbairs_server.exe
SQL ordered by Gets DB/Inst: AIRS/airs Snaps: 8515-8516
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 293,249
-> Captured SQL account for 123.8% of Total

Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
Call GETLEX ('BANQUE', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

3,834 3 1,278.0 1.3 0.08 0.09 25ttgz9tt0shd
Module: corbairs_server.exe
Call GETLEX ('NOMENCLATURE BUDGETAIRE', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

3,759 537 7.0 1.3 0.34 0.34 9cgyp6cvk2bt8
Module: corbairs_server.exe
begin ctxsys.drvdml.lock_opt_rebuild(:idxid, :idxpid,
ctxsys.drvdml.s_mode, null); end;

3,731 3 1,243.7 1.3 0.07 0.07 5ccunprvddqvb
Module: corbairs_server.exe
Call GETLEX ('M', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

3,538 3 1,179.3 1.2 0.06 0.08 ct61tmad10h4g
Module: corbairs_server.exe
Call GETLEX ('CONTENTIEUX ADMINISTRATIF', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1
)

3,449 3 1,149.7 1.2 0.06 0.08 7gt67000yx1fv
Module: corbairs_server.exe
Call GETLEX ('MOTI', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

3,444 3 1,148.0 1.2 0.08 0.08 d5ckkux7b7s6p
Module: corbairs_server.exe
Call GETLEX ('MOTIVATION DES ACTES ADMINISTRATIFS', 20, 0, 'Descripteurs', '3,4,
5,7,8',5,1)

3,429 60 57.2 1.2 0.11 23.18 416s5s7yxj4bb
Module: corbairs_server.exe
call UPDATE_LEXIQUE_ALPHANUM (:f1 ,:f2 ,:f3 ,:f4
,:f5 ,:f6 ,:f7 ,:f8 )

3,321 3 1,107.0 1.1 0.07 0.08 4ab4cux817dv0
Module: corbairs_server.exe
Call GETLEX ('PERMIS DE CONSTRUIRE', 20, 0, 'Descripteurs', '3,4,5,7,8',5,1)

3,230 16 201.9 1.1 0.11 0.24 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

SQL ordered by Reads DB/Inst: AIRS/airs Snaps: 8515-8516
-> Total Disk Reads: 3,093
-> Captured SQL account for 190.9% of Total

Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
2,726 2 1,363.0 88.1 1.31 349.21 01vu1y640n4f8
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_fic_primaire')

2,710 513 5.3 87.6 0.58 346.03 6v88sm53phx5g
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_FIC_PRIMAIRE$I" values (:token, :ttype, :fir
st, :last, :count, :data)

144 60 2.4 4.7 0.11 23.18 416s5s7yxj4bb
Module: corbairs_server.exe
call UPDATE_LEXIQUE_ALPHANUM (:f1 ,:f2 ,:f3 ,:f4
,:f5 ,:f6 ,:f7 ,:f8 )

129 60 2.2 4.2 0.03 19.30 113a4tum6c79j
Module: corbairs_server.exe
INSERT INTO VOCA_ALPHANUM (DOC_ID, LEX_ID, VOCA_FLD_ID) VALUES (:B3 , :B2 , :B1
)

40 3 13.3 1.3 0.02 6.73 g6xwn6rjdfdyp
Module: corbairs_server.exe
call ctxsys.ctx_ddl.sync_index('idx_plein_texte_context')

37 11 3.4 1.2 0.02 4.98 8yr7su0ff5353
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_PLEIN_TEXTE_CONTEXT$I" values (:token, :ttyp
e, :first, :last, :count, :data)

17 1 17.0 0.5 0.02 6.07 2498cgpp95c18
Module: corbairs_server.exe
CALL PROC_MAJ_PLEIN_TEXTE_HIT ('Resume',3,10792,'', :f1 )

10 4 2.5 0.3 0.00 2.13 6rph36s3u3gy7
Module: corbairs_server.exe
INSERT INTO MOTS_PLEIN_TEXTE (MOT_ID,VALUE ) VALUES (:B2 , LOWER(:B1 ))

10 5 2.0 0.3 0.02 2.23 894xnm54fv1cy
Module: corbairs_server.exe
INSERT INTO LEXIQUE_ALPHANUM (LEX_ID, VALUE, VALUE_MAJUSC, WORDPOS, ISPERMUTED,
WORDPERM, ISREDUCED, REF_LEX_ID_PERE) VALUES (:B3 , :B2 , :B1 , 0, 0, NULL, 0, 0
)

8 1 8.0 0.3 0.00 0.83 g6wf9na8zs5hb
insert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, beg
in_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minv
al, average, standard_deviation) select :snap_id, :dbid, :instance_number,
begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min,

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

SQL ordered by Executions DB/Inst: AIRS/airs Snaps: 8515-8516
-> Total Executions: 8,046
-> Captured SQL account for 52.2% of Total

CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
545 545 1.0 0.00 0.00 19x1189chq3xd
Module: corbairs_server.exe
SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE

537 537 1.0 0.00 0.00 72rgmg9bqpsjb
Module: corbairs_server.exe
begin ctxsys.drvdml.unlock_opt_rebuild; end;

537 537 1.0 0.00 0.00 9cgyp6cvk2bt8
Module: corbairs_server.exe
begin ctxsys.drvdml.lock_opt_rebuild(:idxid, :idxpid,
ctxsys.drvdml.s_mode, null); end;

513 4,095 8.0 0.00 0.67 6v88sm53phx5g
Module: corbairs_server.exe
insert into "AIRS_GESTDOC"."DR$IDX_FIC_PRIMAIRE$I" values (:token, :ttype, :fir
st, :last, :count, :data)

466 576 1.2 0.00 0.00 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

144 144 1.0 0.00 0.00 47r1y8yn34jmj
select default$ from col$ where rowid=:1

119 2,368 19.9 0.00 0.00 f5bw248wfugf5
Module: corbairs_server.exe
Select VALUE, hit from VueLexiqueAN order by VALUE

112 112 1.0 0.02 0.02 2a888dwvx21v4
Module: corbairs_server.exe
select count(*) from HIT_ALPHA_NUM where hit_nom_lex = 'Descripteurs' and dty_id
in (3,4,5,7,8)

103 99 1.0 0.00 0.00 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
+ :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn

103 0 0.0 0.00 0.00 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

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

SQL ordered by Parse Calls DB/Inst: AIRS/airs Snaps: 8515-8516
-> Total Parse Calls: 3,050
-> Captured SQL account for 55.0% of Total

% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
466 466 15.28 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

144 144 4.72 47r1y8yn34jmj
select default$ from col$ where rowid=:1

119 119 3.90 f5bw248wfugf5
Module: corbairs_server.exe
Select VALUE, hit from VueLexiqueAN order by VALUE

112 112 3.67 2a888dwvx21v4
Module: corbairs_server.exe
select count(*) from HIT_ALPHA_NUM where hit_nom_lex = 'Descripteurs' and dty_id
in (3,4,5,7,8)

103 103 3.38 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
+ :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn

103 103 3.38 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

60 60 1.97 416s5s7yxj4bb
Module: corbairs_server.exe
call UPDATE_LEXIQUE_ALPHANUM (:f1 ,:f2 ,:f3 ,:f4
,:f5 ,:f6 ,:f7 ,:f8 )

48 48 1.57 dbrkq0h5qz4g1
Module: corbairs_server.exe
select relation.rel_id from relation where upper(relation.rel_valeur)=upper('SPE
CIFIQUE')

30 30 0.98 49s332uhbnsma
declare vsn varchar2(20); begin vsn :=
dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn;
if vsn is not null then :pkg_vsnub4 :=
to_number(substr(vsn,1,2) || substr(vsn,4,2) || s

26 26 0.85 4m7m0t6fjcs5x
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1

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

SQL ordered by Sharable Memory DB/Inst: AIRS/airs Snaps: 8515-8516

No data exists for this section of the report.
-------------------------------------------------------------

SQL ordered by Version Count DB/Inst: AIRS/airs Snaps: 8515-8516