Bonjour,
J'ai lu la doc ci-dessous chez Oracle :Je ne saisi pas bien ce qu'ils veulent dirent par : Compare A & B to spot over parsing. In this case we have 7 parses for 54 statements which is ok.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS | call | count | cpu | elapsed | disk | query | current | rows | |---------|-------|------|---------|---------|--------|---------|--------| | Parse | A 7 | 1.87 | 4.53 | 385 | G 553 | 22 | 0 | | Execute | E 7 | 0.03 | 0.11 | P 0 | C 0 | D 0 | F 0 | | Fetch | E 6 | 1.39 | 4.21 | P 128 | C 820 | D 3 | F 20 | -------------------------------------------------------------------------- Misses in library cache during parse: 5 Misses in library cache during execute: 1 8 user SQL statements in session. 12 internal SQL statements in session. B 54 SQL statements in session. 3 statements EXPLAINed in this session. Compare A & B to spot over parsing. In this case we have 7 parses for 54 statements which is ok.
Quel est le rapport entre les 7 parses et les 54 SQL statements IN session ?
Merci pour votre aide.
Partager