tag:blogger.com,1999:blog-89215711924569977192023-06-20T21:52:02.067-07:00Blog Oracle de Zakaria EL HAMDAOUIA travers ce blog, j’aimerai bien partager mes expériences avec les interlocuteurs francophone sur : Administration BD Oracle, Amélioration des performances Oracle.Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8921571192456997719.post-35906879649985084002015-07-10T19:35:00.001-07:002015-07-10T19:35:17.872-07:00Utilitaire : TKPROF pour tracer une sessions Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
TKPROF : cet utilitaire du
système d'exploitation convertit la sortie d'une session SQL TRACE dans un
format lisible.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Utiliser SQL Trace et TKPROF</b><o:p></o:p></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
Une procédure spécifique doit être
suivie pour évaluer correctement les performances des instructions SQL à l'aide
de SQL Trace et de TKPROF :<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->La première étape consiste à définir les
paramètres d'initialisation de façon appropriée. Cette définition peut
s'effectuer au niveau de l'instance, mais il est possible également de définir
certains paramètres au niveau de la session.<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->Vous devez appeler SQL Trace soit au niveau de
l'instance, soit au niveau de la session. En règle générale, il est conseillé
de l'appeler au niveau de la session.<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->Exécutez l'application ou l'instruction SQL à
diagnostiquer.<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->Arrêtez SQL Trace pour pouvoir fermer
correctement le fichier trace au niveau du système d'exploitation.<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->Utilisez TKPROF pour rendre lisible le fichier
trace généré au cours de la session de trace. Si le fichier de sortie n'est pas
lisible, il est très difficile d'interpréter les résultats.<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->Pour diagnostiquer les performances de
l'instruction SQL, utilisez les résultats de TKPROF. <o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l0 level3 lfo1; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Paramètres d'initialisation</b><o:p></o:p></div>
<div class="MsoNormal">
Deux paramètres du fichier init.ora
gèrent la taille et la destination du fichier de sortie généré par l'utilitaire
SQL Trace :<o:p></o:p></div>
<div class="MsoNormal">
max_dump_file_size
= <i>n</i> <o:p></o:p></div>
<div class="MsoNormal">
<i><br /></i></div>
<div class="MsoNormal">
Ce paramètre est exprimé en octets
s'il porte la mention Ko ou Mo, ou, à défaut, en nombre de blocs du système
d'exploitation. La valeur par défaut est de 10000 blocs de système
d'exploitation.<o:p></o:p></div>
<div class="MsoNormal">
Lorsqu'un fichier trace dépasse la
taille définie par la valeur de ce paramètre, le message suivant s'affiche à la
fin du fichier : *** Trace file full ***<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Le paramètre suivant détermine la
destination du fichier trace :<o:p></o:p></div>
<div class="MsoNormal">
user_dump_dest
= <i>directory</i><o:p></o:p></div>
<div class="MsoNormal">
<i><br /></i></div>
<div class="MsoNormal">
Vous devez définir un troisième
paramètre pour obtenir les statistiques temporelles :<o:p></o:p></div>
<div class="MsoNormal">
timed_statistics
= TRUE<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
La résolution des statistiques
temporelles s'effectue au centième de seconde.<o:p></o:p></div>
<div class="MsoNormal">
Le paramètre TIMED_STATISTICS peut
également être défini de manière dynamique au niveau de la session, à l'aide de
la commande ALTER SESSION. <o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><u>Activer et désactiver SQL Trace</u></b><o:p></o:p></div>
<div class="MsoNormal">
SQL Trace peut être activé ou
désactivé à l'aide de différentes méthodes, au niveau de l'instance ou de la
session.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal">
<b><u>Au niveau de l'instance :</u></b></div>
<div class="MsoNormal">
La définition du paramètre SQL_TRACE
au niveau de l'instance constitue l'une des méthodes d'activation de la
fonction de trace. Toutefois, l'instance doit être arrêtée, puis redémarrée une
fois que la fonction de trace n'est plus utilisée. En outre, le taux de
performance doit être élevé, car toutes les sessions de l'instance font l'objet
d'un suivi d'exécution.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><u>Au niveau de la session :</u></b><o:p></o:p></div>
<div class="MsoNormal">
L'utilisation de la fonction de
trace au niveau de la session requiert un taux de performance moindre, car le
suivi peut porter sur des sessions spécifiques. Vous pouvez activer ou
désactiver SQL Trace :<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l1 level3 lfo2; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->à l'aide de la commande ALTER SESSION, qui
permet d'exécuter la fonction de trace pendant toute la durée de la session ou
jusqu'à ce que la valeur FALSE soit définie,<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l1 level3 lfo2; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->en utilisant la procédure DBMS_SESSION.SET_SQL_TRACE
pour la session,<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: 108.0pt; mso-list: l1 level3 lfo2; tab-stops: 36.0pt list 108.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; mso-fareast-font-family: "Times New Roman";">•<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]-->en utilisant la procédure DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION
pour activer la fonction de trace dans une session différente de la session
actuelle. <o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Rendre le fichier trace lisible
à l'aide de TKPROF <o:p></o:p></b></div>
<div class="MsoNormal">
<b><i><span lang="EN-US">$ tkprof tracefile.trc output.txt </span></i></b><i><span lang="EN-US"><o:p></o:p></span></i></div>
<div class="MsoNormal">
<b><i><span lang="EN-US"><br /></span></i></b></div>
<div class="MsoNormal">
<b><i><span lang="EN-US"><br /></span></i></b></div>
<div class="MsoNormal">
<b><i><span lang="EN-US">NB : Prochain article : Interpréter un fichier trace générer par TKPROF</span></i></b></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-64891103347728358382015-06-14T05:41:00.002-07:002015-06-14T05:41:57.181-07:00Chaînage et Migration des données ORACLE<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<br /></div>
<div class="MsoToc1">
<!--[if supportFields]><span
style='mso-element:field-begin'></span><span
style='mso-spacerun:yes'> </span>TOC \o "1-3" \h \z \u <span
style='mso-element:field-separator'></span><![endif]--><span style="color: blue;">1. Introduction<span style="display: none; text-decoration: none;">. </span><!--[if supportFields]><span
style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
text-decoration:none;text-underline:none'><span style='mso-element:field-begin'></span>
PAGEREF _Toc420667871 \h <span style='mso-element:field-separator'></span></span><![endif]--><span style="display: none; text-decoration: none;">3<!--[if gte mso 9]><xml>
<w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400320030003600360037003800370031000000</w:data>
</xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
display:none;mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:
none'><span style='mso-element:field-end'></span></span><![endif]--><o:p></o:p></span></div>
<div class="MsoToc3">
<span style="color: blue;"> 1.1- Migrations des lignes<span style="display: none; text-decoration: none;">. </span><!--[if supportFields]><span
style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
text-decoration:none;text-underline:none'><span style='mso-element:field-begin'></span>
PAGEREF _Toc420667872 \h <span style='mso-element:field-separator'></span></span><![endif]--><span style="display: none; text-decoration: none;">3<!--[if gte mso 9]><xml>
<w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400320030003600360037003800370032000000</w:data>
</xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
display:none;mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:
none'><span style='mso-element:field-end'></span></span><![endif]--><o:p></o:p></span></div>
<div class="MsoToc3">
<span style="color: blue;"> 1.2- Lignes chaînées</span></div>
<div class="MsoToc2">
<span style="color: blue;">2. Détecter les tables avec des lignes migrées ou
chaînées<span style="display: none; text-decoration: none;">. </span><!--[if supportFields]><span
style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
text-decoration:none;text-underline:none'><span style='mso-element:field-begin'></span>
PAGEREF _Toc420667874 \h <span style='mso-element:field-separator'></span></span><![endif]--><span style="display: none; text-decoration: none;">4<!--[if gte mso 9]><xml>
<w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400320030003600360037003800370034000000</w:data>
</xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
display:none;mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:
none'><span style='mso-element:field-end'></span></span><![endif]--><o:p></o:p></span></div>
<div class="MsoToc3">
<span style="color: blue;"> 2-1- Nombre total d’événements <span style="background: yellow; mso-highlight: yellow;">'table fetch continued row'</span> depuis le
démarrage de l'instance<span style="display: none; text-decoration: none;">. </span><!--[if supportFields]><span
style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
text-decoration:none;text-underline:none'><span style='mso-element:field-begin'></span>
PAGEREF _Toc420667875 \h <span style='mso-element:field-separator'></span></span><![endif]--><span style="display: none; text-decoration: none;">4<!--[if gte mso 9]><xml>
<w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400320030003600360037003800370035000000</w:data>
</xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
display:none;mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:
none'><span style='mso-element:field-end'></span></span><![endif]--><o:p></o:p></span></div>
<div class="MsoToc3">
<span style="color: blue;"> 2.2 - Détecter toutes les tables ayant des lignes
chaînées ou migrées</span></div>
<div class="MsoToc2">
<span style="color: blue;">3- Comment éviter les lignes migrées et chaînées</span></div>
<!--[if supportFields]><span style='font-size:11.0pt;line-height:115%;
font-family:"Calibri","sans-serif";mso-ascii-theme-font:minor-latin;mso-fareast-font-family:
Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;
mso-ansi-language:FR;mso-fareast-language:EN-US;mso-bidi-language:AR-SA'><span
style='mso-element:field-end'></span></span><![endif]--><br />
<div class="MsoToc2" style="tab-stops: right dotted 453.1pt;">
<span style="mso-no-proof: yes;"><span style="color: blue;">4- Conclusion</span></span><a href="file:///C:/Users/zakaria/Dropbox/A%20Rapports%20FONDEP/Rapport%20Codir/Rows_chaine_migre.docx#_Toc420667878"><span style="color: windowtext; display: none; mso-hide: screen; mso-no-proof: yes; text-decoration: none; text-underline: none;"><span style="mso-tab-count: 1 dotted;">. </span></span><!--[if supportFields]><span
style='color:windowtext;display:none;mso-hide:screen;mso-no-proof:yes;
text-decoration:none;text-underline:none'><span style='mso-element:field-begin'></span>
PAGEREF _Toc420667878 \h <span style='mso-element:field-separator'></span></span><![endif]--><span style="color: windowtext; display: none; mso-hide: screen; mso-no-proof: yes; text-decoration: none; text-underline: none;">7<!--[if gte mso 9]><xml>
<w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400320030003600360037003800370038000000</w:data>
</xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
display:none;mso-hide:screen;mso-no-proof:yes;text-decoration:none;text-underline:
none'><span style='mso-element:field-end'></span></span><![endif]--></a><span style="mso-fareast-font-family: "Times New Roman"; mso-fareast-language: FR; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes;"><o:p></o:p></span></div>
<div class="MsoToc2" style="tab-stops: right dotted 453.1pt;">
<br /></div>
<div class="MsoToc2" style="tab-stops: right dotted 453.1pt;">
<br /></div>
<h2 style="text-align: left;">
<a href="https://www.blogger.com/null" name="_Toc420667871"><span style="color: #0b5394;">1.
Introduction</span></a></h2>
<h1>
<o:p></o:p></h1>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Times New Roman, serif;"><span style="font-size: 12pt;">Dans le cadre de l’optimisation
préventive et curative des traitements et accès aux données, et </span>après<span style="font-size: 12pt;"> avoir remarqué quelques dégradations de performances sur notre base production, le
chaînage et les migrations de ligne peuvent en être responsables en partie. Il
est possible toutefois de détecter et de diagnostiquer ces phénomènes, et dans
une plus grande mesure de reparamétrer la base de données pour empêcher le
chaînage et la migration de lignes, ce qui est le notre cas </span>aujourd’hui<span style="font-size: 12pt;">.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">L'article se propose :<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">de présenter le
chaînage et la migration de lignes<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">d’identifier le
chaînage et la migration de lignes au niveau de notre base PRODDB.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">de montrer
comment éviter le chaînage et la migration de lignes.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Les lignes migrées affectent les
systèmes OLTP qui utilisent des indexes pour lire quelques lignes.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Les lignes chaînées affectent les
lectures d'indexes et les scans de tables (full table scan).<o:p></o:p></span></div>
<div class="MsoToc2">
</div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Dans le pire des cas, des I/O
supplémentaires pour toutes les lectures peuvent apparaître à cause du chaînage
et des migrations de lignes, I/O supplémentaires dégradant les performances.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<h3 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667872"><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">1.1-
Migrations des lignes</span></a><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h3>
<div style="text-align: justify;">
Une ligne sera
migrée lorsqu'une commande <b>update</b>
sur la ligne en question ne permettra pas à cette dernière de demeurer sur le
bloc (faute d'espace disponible au niveau du bloc). <span style="background: lightgrey; mso-highlight: lightgrey;">Une migration d'une ligne implique que
l'intégralité de la ligne sera déplacée vers un autre bloc</span>, ne laissant
sur le bloc d'origine qu'une adresse de redirection (forward address). Le bloc
original ne dispose plus que du RowID et la ligne entière est déplacée vers un
autre bloc.<o:p></o:p></div>
<div style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
</div>
<ul>
<li><u><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Impacts des migrations de ligne sur les
"Full Scan Tables"</span></u></li>
</ul>
<br />
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Lors des scans de tables, les adresses
de redirection sont ignorées. Lors d'un full scan, le moteur traitera quoiqu'il
arrive la ligne, aussi l'adresse de redirection peut être ignorée.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
</div>
<ul>
<li><u><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Impacts des migrations de ligne sur les
lectures d'indexes</span></u></li>
</ul>
<br />
<div class="MsoNormal" style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">En revanche, lors d'une lecture d'une
table à travers un index, des I/Os supplémentaires sont générés. En effet
l'index indiquera au moteur de se rendre à l'adresse file_id X, block Y, slot Z
pour trouver la ligne, mais à cette adresse, le moteur est renvoyé vers une
autre adresse file_id A, block B, slot C : aussi une E/S (logique ou physique)
supplémentaire est générée pour effectivement trouver cette ligne.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<h3 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667873"><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">1.2-
Lignes chaînées</span></a><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h3>
<div style="text-align: justify;">
Dans le cas du
chaînage de lignes, une ligne ne peut être contenue dans un seul bloc.
Certaines conditions engendrent le chaînage de lignes :<o:p></o:p></div>
<div style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les tables pour
lesquelles la taille de la ligne excède la taille du bloc<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les tables ayant
des colonnes de type long et long raw<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les tables ayant
plus de 255 colonnes.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
</div>
<div style="text-align: justify;">
Les données pour
une ligne sont réparties sur plusieurs blocs.<o:p></o:p></div>
<div style="text-align: justify;">
<br /></div>
<h2 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667874"><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">2. Détecter
les tables avec des lignes migrées ou chaînées</span></a><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h2>
<h3 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667875"><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">2-1-
Nombre total d'évènements <span style="background: yellow; mso-highlight: yellow;">'table
fetch continued row'</span> depuis le démarrage de l'instance</span></a><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h3>
<div style="text-align: justify;">
La vue V$SYSSTAT
indique combien de fois depuis le démarrage de l'instance la
statistique table fetch continued row a été incrémentée, ce qui
revient à rechercher le nombre de fois où l'instance a rencontré des lignes
chaînées ou migrées :<o:p></o:p></div>
<div style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white; font-family: Courier; font-size: 10pt;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">SELECT</span><span style="background: white; font-family: Courier; font-size: 10pt;"> </span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">'Lignes migrées ou chainée = '</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">||VALUE</span><span style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> v$sysstat <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">lower</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">(NAME)</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'table
fetch continued row'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">;</span><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;"><br /></span></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<span style="background: lightgrey; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-highlight: lightgrey;">Lignes migrées ou chainée = 54 101 159</span><o:p></o:p></div>
<div style="text-align: justify;">
<span style="background: lightgrey; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-highlight: lightgrey;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">L'interprétation de la requête peut
signifier plusieurs choses :<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">on peut avoir
une table avec une ligne chaînée ou migrée qui a été extraite </span><b><span style="background: white; font-family: Courier;">54101159</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> fois.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">on peut avoir </span><b><span style="background: white; font-family: Courier;">54101159</span></b><span style="font-family: Courier; font-size: 10pt;"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">tables
avec une ligne chaînée ou migrée, ligne qui a été extraite.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div style="text-align: justify;">
<span style="background: lightgrey; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-highlight: lightgrey;">
</span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Aussi : </span><b><span style="background: white; font-family: Courier;">54101159</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">, ceci peut être
dramatique ou pas ! Tout ceci est fonction :<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">depuis combien
de temps l'instance est démarrée (notre
cas : </span><span style="background: white; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">2015-03-04 18:03:22</span><span style="font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier;">)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">combien de
lignes cela représente en pourcentage par rapport au nombre total de lignes
extraites.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><br clear="all" style="mso-special-character: line-break; page-break-before: always;" />
</span>
</div>
<div class="MsoNormal">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"> </span><span style="font-family: 'Times New Roman', serif; font-size: 12pt; text-align: justify;">Pour cela on doit comparer les
statistiques</span><span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"> </span><span style="color: #575757; font-family: 'Courier New'; font-size: 10pt; text-align: justify;">table fetch continued row</span><span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"> </span><span style="font-family: 'Times New Roman', serif; font-size: 12pt; text-align: justify;"> en</span><span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"> </span><span style="font-family: 'Times New Roman', serif; font-size: 12pt; text-align: justify;">pourcentage avec
les statistiques</span><span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"> </span><span style="color: #575757; font-family: 'Courier New'; font-size: 10pt; text-align: justify;">table fetch by rowid</span><span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"> :</span></div>
<div class="MsoNormal">
<span style="color: #575757; font-family: Verdana, sans-serif; font-size: 13pt; text-align: justify;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">NAME,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">VALUE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> v$sysstat <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">lower(name)</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">like</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'table fetch%'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">;</span><span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;">NAME
VALUE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;">----------------------------------------------------------------
----------<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;">table fetch by rowid
3,3659E+10<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier;">table fetch
continued row
54101159<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">On remarque que <b><span style="background: yellow; mso-highlight: yellow;">16.5%</span></b> des lignes sont chainées ou migrées, chiffre qu’il
faut essayer de réduire.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<h3 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667876"><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">2.2 -
Détecter toutes les tables ayant des lignes chaînées ou migrées</span></a><span style="color: #365f91; font-size: 13.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h3>
<div style="text-align: justify;">
Le diagnostique a
été effectué sur les schémas ci-dessous, et sera généraliser sur tous les
schémas de la BD : <span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">'TBAADM'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">'CUSTOM'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">'CRMUSER'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;">'TBAGEN'</span><span style="color: blue; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier;"><o:p></o:p></span></div>
<div style="text-align: justify;">
<span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-bidi-font-family: Courier; mso-highlight: white;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> owner_name</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> table_name</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">count(</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;">head_rowid</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> row_count<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> chained_rows<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> owner_name </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">in</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'TBAADM'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'CUSTOM'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'CRMUSER'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'TBAGEN'</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">GROUP</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> owner_name</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;">table_name<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">ORDER</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">3</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">DESC<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Résultats :</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">
</span></div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 2.75pt; mso-padding-alt: 0cm 3.5pt 0cm 3.5pt; mso-yfti-tbllook: 1184; width: 426px;">
<tbody>
<tr style="height: 12.75pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="" style="background: silver; height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">OWNER_NAME<o:p></o:p></span></div>
</td>
<td nowrap="" style="background: silver; height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TABLE_NAME<o:p></o:p></span></div>
</td>
<td nowrap="" style="background: silver; height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">ROW_COUNT<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 1;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">INT_ADJUSTMENT_RGTR_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">37717<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 2;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">SALEBACKEND<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">6995<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 3;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">ACCOUNTS<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">5055<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 4;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">BATCH_JOB_MONITOR_TBL<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">861<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 5;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">AGENT_ENTITY_DETAILS<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">168<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 6;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">AUDITTRAIL<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">142<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 7;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">AUDIT_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">72<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 8;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">HOLIDAY_MAST_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">62<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 9;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">IN_TRAN_DETAILS_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">44<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 10;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CREDITBUREAU<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">20<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 11;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">SALE_DOCUMENT<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">10<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 12;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">SUSPECTS<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">6<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 13;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">GENERAL_ACCT_MAST_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">3<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 14;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">TBAADM<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">GEN_SCHM_PARM_TABLE<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">2<o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.75pt; mso-yfti-irow: 15; mso-yfti-lastrow: yes;">
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 79.8pt;" valign="bottom" width="106">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">CRMUSER<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 167.05pt;" valign="bottom" width="223">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">DEMOGRAPHIC<o:p></o:p></span></div>
</td>
<td nowrap="" style="height: 12.75pt; padding: 0cm 3.5pt 0cm 3.5pt; width: 72.6pt;" valign="bottom" width="97">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<span style="font-family: Arial, sans-serif; font-size: 10pt;">1<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<br /><div>
<h2 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667877"><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">3-
Comment éviter les lignes migrées et chaînées</span></a><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h2>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">En augmentant la valeur du
paramètre PCTFREE, cela peut empêcher les migrations de lignes dans le
sens ou plus d'espace est réservé dans un bloc. Il est également possible de
réorganiser les tables et indexes ayant un fort taux de suppressions.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">La commande ALTER TABLE ...
MOVE permet de relocaliser les données d'une table non partitionnée ou
d'une partition d'une table dans un nouveau segment, et optionnellement dans un
nouveau tablespace. Cette commande permet également de modifier les attributs de
stockage comme le paramètre PCTFREE.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><u><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Première étape</span></u></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> :
lancement de la commande ALTER TABLE ... </span><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: EN-US;">MOVE<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US">Exemple :<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">ALTER</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">TABLE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: olive; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">AUDITTRAIL</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">MOVE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">PCTFREE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">20</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">PCTUSED</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">40</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;">
</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">STORAGE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">(INITIAL</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">20</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">K</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">NEXT</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">40</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">K</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">MINEXTENTS</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">2</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">MAXEXTENTS</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">20</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">PCTINCREASE</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">0</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">);</span><span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
</div>
<div class="MsoNormal">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Dans la commande ci-dessous, le
paramètre PCTFREE est modifié pour passer de 10 à 20.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><u><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Seconde
étape :</span></u></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">
reconstruction des indexes de la table ou de la partition en question<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Déplacer une table sur un nouveau
segment modifie les rowids de la table. Les indexes de la table sont alors
marqués avec le statut UNUSABLE et les commandes DML accédant à la
table en utilisant ces indexes rencontrent l'erreur <span style="background: lightgrey; mso-highlight: lightgrey;">ORA-01502</span>. Aussi après une
commande ALTER TABLE <table_name> MOVE, les indexes doivent être
recréées ou reconstruits :<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">select</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> index_name</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> index_type</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> owner</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt;"> status<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">from</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> dba_indexes <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">where</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> table_name</span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: red; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">'AUDITTRAIL'</span><span lang="EN-US" style="color: red; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Récupérer
les index dont le statu est : UNUSABLE, puis exécuter la commande
ci-dessous :<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">alter</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">index</span><span lang="EN-US" style="background: white; font-family: Courier; font-size: 10pt; line-height: 115%;"> index_name </span><span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">rebuild;</span><span lang="EN-US" style="color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;"><br /></span></div>
<h2 style="margin-bottom: 12.0pt; margin-left: 0cm; margin-right: 0cm; margin-top: 24.0pt; text-align: justify;">
<a href="https://www.blogger.com/null" name="_Toc420667878"><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;">4-
Conclusion</span></a><span style="color: #365f91; font-size: 14.0pt; line-height: 115%; mso-themecolor: accent1; mso-themeshade: 191;"><o:p></o:p></span></h2>
<div style="text-align: justify;">
Les lignes
migrées affectent les systèmes OLTP qui utilisent des indexes pour lire des
lignes singulières. Les lignes réellement chaînées affectent les lectures
d'indexes et les full scans de tables.<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les migrations
de lignes sont typiquement causées par des opérations UPDATE<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les chaînage de
lignes sont typiquement causées par des opérations INSERT<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">les commandes
SQL qui crééent ou interrogent ces lignes migrées ou chaînées dégradent les
performances à cause d'I/Os supplémentaires.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-family: Courier; mso-highlight: white;">
</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt 22.5pt; text-align: justify; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Pour supprimer
les lignes chaînées ou migrées, utiliser une valeur plus élevée du
paramètre PCTFREE en utilisant la commande ALTER TABLE MOVE.<o:p></o:p></span></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-32212785074752432902013-10-06T11:32:00.001-07:002013-10-06T11:32:58.818-07:00Techniques de FLASHBACK d'ORACLE<div dir="ltr" style="text-align: left;" trbidi="on">
<b>1- Vue d’ensemble</b><br />
Les techniques de flashback sont un ensemble de fonctionnalités proposées par Oracle qui permettent de voir l’état passé de données, ou de ramener une table ou la totalité de la base de données dans le passé.<br />
Les fonctionnalités proposées sont les suivantes :<br />
<br />
<i> - Flashback Query :</i> permet de lire les données telles qu’elles étaient à un instant dans le passé (appary en version 9i).<br />
<br />
<i>- Flashback Version Query :</i> permet de voir toutes les versions d’une ligne sur un certain intervelle de temps (apparu en version 10).<br />
<br />
<i>- Flashback Transaction Query) :</i> permet de voir les modifications réalisées par une ou plusieurs transactions sur un certain intervalle de temps (apparue en version 10).<br />
<br />
<i>- Flashback Transaction :</i> permet d’annuler les modifications d’une transaction, et de ses transactions dépendantes( apparue en version 11).<br />
<br />
<i>- Flashback Data Archive (Oracle Total Recall) :</i> permet de conserver sur le long terme, toutes les modifications apportées à une table (apparue en version 11).<br />
<br />
<i>- Flashback Table :</i> permet de ramener une table dans l état où elle était, juste avant sa suppression (apparue en version 10).<br />
<br />
<i>- Flashback Database :</i> permet de ramener la totalité de la base de données dans l’état où elle était à un certain moment dans le passé (apparue en version 11).<br />
<br />
Seule la fonctionnalité Flashback Query est disponible dans toutes les éditions de la base de données (et donc notamment en Standart Edition).<br />
La fonctionnalité Flashback Data Archive, est une option de l’Entreprise Edition et nécessite donc, une licence supplémentaire.<br />
<br />
Les autres fonctionnalités de Flashback nécessitent l’Entreprise Edition, mais sans option supplémentaire.<br />
Les fonctionnalités de Flashback de requête (Flashback Query, Flashback Version Query et Flashback Transaction Query), et la fonctionnalité de Flashback Table, utilisent les informations d’annulation pour revenir en arrière. Le paramètre <i>UNDO_RETENTION </i>et le tablespace d’annulation doivent donc être correctement dimensionnés, si vous souhaitez pouvoir retourner loin dans le passé.<br />
<br />
<b>2- Niveau ligne</b><br />
<i><b>Flashback Query</b></i><br />
<br />
Pour lire les données telles qu’elles étaient à un instant donné du passé, vous pouvez utiliser l’option <i>AS OF</i> sur une table présente dans la clause <i>FROM</i> d’une requête <i>SELECT</i>.<br />
<br />
<b>Syntaxe :</b><br />
<i>Nom_table AS OF { TIMESTAMP | SCN } expression</i><br />
<br />
L’option <i>TIMESTAMP</i> permet de retourner à un instant donné du passé en indiquant une date et une heure ; dans ce cas, l’expression doit être de type <i>TIMESTAMP</i>. L’option <i>SCN </i>permet de retourner à un instant donné du passé en indiquant un numéro <i>SCN</i> ; dans ce cas, l’expression doit être un nombre.<br />
<br />
<br />
<span style="background-color: #eeeeee;">SQL> select * from emp where empno = 7369;</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;"> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO</span><br />
<span style="background-color: #eeeeee;">---------- ---------- --------- ---------- -------- ---------- ---------- --------------------------------</span><br />
<span style="background-color: #eeeeee;"> 7369 SMITH CLERK 7902 17/12/80 800 20</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;">SQL> select to_char(sysdate, 'DD/MM/YYY HH24:MI:SS') "SYSDATE",</span><br />
<span style="background-color: #eeeeee;"> 2 dbms_flashback.get_system_change_number "SCN"</span><br />
<span style="background-color: #eeeeee;"> 3 FROM dual;</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;">SYSDATE SCN</span><br />
<span style="background-color: #eeeeee;">------------------ ----------</span><br />
<span style="background-color: #eeeeee;">06/10/013 15:31:48 3446120</span><br />
<br />
<br />
<br />
La fonction <span style="background-color: #eeeeee;">GET_SYSTEM_Change_NUMBER</span> du package <span style="background-color: #eeeeee;">DBMS_FLASHBACK</span> retourne le numéro <i>SCN</i> courant. Il faut le privilège <i>EXECUTE</i> sur le package pour l’utiliser.<br />
<br />
<b>Un peu plus tard :</b><br />
<br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;">SQL> update emp set ename = 'ZAKARIA' where empno = '7369';</span><br />
<span style="background-color: #eeeeee;">1 ligne mise à jour.</span><br />
<span style="background-color: #eeeeee;">SQL> commit;</span><br />
<span style="background-color: #eeeeee;">Validation effectuée.</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;">SQL> select to_char(sysdate, 'DD/MM/YYY HH24:MI:SS') "SYSDATE",</span><br />
<span style="background-color: #eeeeee;"> 2 dbms_flashback.get_system_change_number "SCN"</span><br />
<span style="background-color: #eeeeee;"> 3 FROM dual;</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;">SYSDATE SCN</span><br />
<span style="background-color: #eeeeee;">------------------ ----------</span><br />
<span style="background-color: #eeeeee;">06/10/013 15:38:41 3446364</span><br />
<br />
<br />
<br />
<b><i>Maintenant je vais retourner vers le passé avec la notion du temps :</i></b><br />
<br />
<span style="background-color: #eeeeee;">SQL> SELECT * FROM EMP </span><br />
<span style="background-color: #eeeeee;"> 2 AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '10' minute</span><br />
<span style="background-color: #eeeeee;"> 3 where empno = 7369;</span><br />
<span style="background-color: #eeeeee;"> </span><br />
<span style="background-color: #eeeeee;"> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO</span><br />
<span style="background-color: #eeeeee;">--------- ---------- --------- ---------- -------- ---------- ---------- ----------</span><br />
<span style="background-color: #eeeeee;"> 7369 SMITH CLERK 7902 17/12/80 800 20</span><br />
<br />
<br />
<br />
<b><i>Ou bien avec la notion du SCN :</i></b><br />
<br />
<br />
<span style="background-color: #eeeeee;">SQL> SELECT * FROM EMP </span><br />
<span style="background-color: #eeeeee;"> 2 AS OF SCN 3446120</span><br />
<span style="background-color: #eeeeee;"> 3 where empno = 7369;</span><br />
<span style="background-color: #eeeeee;"><br /></span>
<span style="background-color: #eeeeee;"> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO</span><br />
<span style="background-color: #eeeeee;">---------- ---------- --------- ---------- -------- ---------- ---------- ----------</span><br />
<span style="background-color: #eeeeee;"> 7369 SMITH CLERK 7902 17/12/80 800 20</span><br />
<br />
<br />
<br />
<br />
NB : c'est un résumé de la partie FLASHBACK du livre "Administration ORACLE 11g" de OLIVIER HEURTEL.</div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-11433122075761433012013-06-23T05:38:00.002-07:002014-09-25T14:53:32.945-07:00Statistiques ORACLE, Package DBMS_STAT<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
La semaine dernière, et lors d’une mission de consulting
chez un opérateur télécoms, on a confronté un problème de performance qui
concerne les statistiques.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Bref, le problème est le suivant :</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
L’équipe de développement a
développé une application qui utilise une base de données Oracle 10g. Au
niveau du serveur de recette l’application marche très bien, avec un temps de
réponse raisonnable pour la plus part
des requêtes, mais une fois l’application est en production, oooops le temps de
réponse est vraiment anormale (Exemple : une requête en recette :
15s, en prod : 3 minutes !!!!!!!!!!!!!).</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
NB : Avant mon intervention, ils ont bien vérifié que la
configuration des 2 serveurs (Recette et Prod) ont les mêmes caractéristiques .
Les 2 BD ont aussi la même volumétrie.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Avant de commencer d’inspecter les plans d’exécutions, il
fallait voir les statistiques utilisées par Oracle. On sait parfaitement
qu’Oracle se base sur les statistiques collectées pour déterminer le meilleur
plan d’exécution. Si on arrive à avoir les mêmes statistiques que le serveur de
recette, il nous suffit de rejouer son scénario et si le problème vient
réellement d'un plan d'exécution différent, alors on va pouvoir identifier la ou les requêtes en
question.</div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
Pour cela, on va sauvegarder les statistiques du serveur de <b>recette</b> :</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="margin-left: 54.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->1-<span style="font-size: 7pt;"> </span><!--[endif]-->Créer une table pour sauvegarder les
statistique : (<b>USER</b> <span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> le schéma qui utilise l ’application, <b>NOM_TABLE_STATS</b> <span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Nom de la table des statistiques)<i><span style="background: white; color: #c0504d; font-family: "Georgia","serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-themecolor: accent2;"><o:p></o:p></span></i></div>
<div class="MsoListParagraph">
<br /></div>
<div class="MsoNormal" style="margin-left: 70.8pt;">
<strong><i><span style="background: white; color: #c0504d; font-family: "Georgia","serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-themecolor: accent2;"> </span><span style="background-color: #cccccc; background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt; line-height: 115%;"> </span></i></strong><strong><i><span lang="EN-US" style="background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt; line-height: 115%;"><span style="background-color: #cccccc;">exec
DBMS_STATS.CREATE_STAT_TABLE (ownname=>'USER',
stattab=>'NOM_TABLE_STATS');</span><span style="background-color: white;"><o:p></o:p></span></span></i></strong></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="margin-left: 54.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->2-<span style="font-size: 7pt;"> </span><!--[endif]-->Alimenter
la table <b>NOM_TABLE_STATS </b>par les
statistiques du serveur de recette (A travers un Export du package<b>
DBMS_STATS</b>)<b> </b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: 70.8pt;">
<strong><i><span style="background: white; color: #c0504d; font-family: "Georgia","serif"; font-size: 10.0pt; line-height: 115%; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-themecolor: accent2;"> </span><span style="background-color: #cccccc; background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt; line-height: 115%;"> </span></i></strong><strong><i><span lang="EN-US" style="background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt; line-height: 115%;"><span style="background-color: #cccccc;">exec
DBMS_STATS.EXPORT_SCHEMA('USER','NOM_TABLE_STATS');</span><span style="background-color: white;"><o:p></o:p></span></span></i></strong></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="margin-left: 54.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->3-<span style="font-size: 7pt;"> </span><!--[endif]-->Au
niveau du serveur PROD, importer les statistique déjà collectées :</div>
<div class="MsoListParagraph" style="margin-left: 76.5pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt;">
</span><!--[endif]-->Pour cela, il faut déjà supprimé les
statistiques du PROD par la commande suivante :</div>
<div class="MsoListParagraph" style="margin-left: 76.5pt;">
<strong><i><span lang="EN-US" style="background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt;"><span style="background-color: #cccccc;">exec
DBMS_STATS.DELETE_SCHEMA_STATS('USER',FORCE=>TRUE);</span><span style="background-color: white;"><o:p></o:p></span></span></i></strong></div>
<div class="MsoListParagraph" style="margin-left: 76.5pt;">
<br /></div>
<div class="MsoListParagraph" style="margin-left: 76.5pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt;">
</span><!--[endif]-->Importer
les statistiques :</div>
<div class="MsoListParagraph" style="margin-left: 76.5pt;">
<strong><i><span lang="EN-US" style="background: white; color: #c0504d; font-family: "Georgia","serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-themecolor: accent2;"> </span><span lang="EN-US" style="background-position: initial initial; background-repeat: initial initial; color: #c0504d; font-family: Georgia, serif; font-size: 10pt;"><span style="background-color: #cccccc;">exec
DBMS_STATS.IMPORT_SCHEMA_STATS('USER','NOM_TABLE_STATS');</span><span style="background-color: white;"><o:p></o:p></span></span></i></strong></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Et voilà, maintenant
on a les même statistiques au niveau des 2 serveurs, après les tests au niveau
de la PROD, on a constaté que le temps de réponse est très raisonnable.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>NB :</b>
Normalement c’est la première étape qu’on doit faire, il y a des cas où le
problème persiste toujours, dans ce cas il faut revoir et analyser les plans
d’exécutions pour voire s’il y a des full scan ou des mauvaises utilisation
d’index ou bien autre chose.<o:p></o:p></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<o:p><b><i><span style="color: #999999;">Zakaria EL HAMDAOUI</span></i></b></o:p></div>
<div class="MsoNormal">
<o:p><b><i><span style="color: #999999;">Consultant Oracle</span></i></b></o:p></div>
</div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-89409453677377168322013-02-10T10:26:00.001-08:002013-02-10T10:26:30.304-08:00Blog Oracle de Zakaria EL HAMDAOUI: TUNING : REGLAGE DE LA SHARED POOL<a href="http://zelhamdaoui.blogspot.com/2013/02/tuning-reglage-de-la-shared-pool.html?spref=bl">Blog Oracle de Zakaria EL HAMDAOUI: TUNING : REGLAGE DE LA SHARED POOL</a>: 1. REGLAGE DE LA SHARED POOL V$LIBRARYCACHE : contient des statistiques relatives à un type d’élément conservé dans le cache « library ». •...Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-42937932650247771242013-02-10T08:11:00.000-08:002016-10-11T08:49:13.017-07:00Utiliser le mot de passe d’un utilisateur Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
Il arrive parfois que l’administrateur veut se connecter
avec le compte d’un autre utilisateur sans que ce dernière soit au courant. Dans
cet exemple, on va monter comment se connecter avec le mot de passe d’un autre
utilisateur Oracle.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Tout d’abord, il faut avoir le privilège SYSDBA :<br />
<pre><span style="background-color: #eeeeee;">SQL*Plus: Release 10.2.0.1.0 -Production on Dim. Févr. 10 15:35:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connecté à une instance inactive.
SQL>
ZIKO>startup
Instance ORACLE lancée.
Total System Global Area 163577856 bytes
Fixed Size 1247852 bytes
Variable Size 83887508 bytes
Database Buffers 71303168 bytes
Redo Buffers 7139328 bytes
Base de données montée.
Base de données ouverte.
ZIKO>show user
USER est "SYS"
ZIKO>SELECT username,password from DBA_USERS WHERE username='SCOTT';</span></pre>
<pre><span style="background-color: #eeeeee;">
</span></pre>
<pre><span style="background-color: #eeeeee;">
USERNAME PASSWORD
------------------------------ ------------------------------
SCOTT 80337D4D053124C7
</span></pre>
<pre><span style="background-color: #eeeeee;">OU BIEN : </span></pre>
<pre><span style="background-color: #eeeeee;">
ZIKO>SELECT SPARE4||';'||PASSWORD FROM SYS.USER$ WHERE USERNAME='SCOTT'</span></pre>
<pre><span style="background-color: #eeeeee;">
</span></pre>
<pre><span style="background-color: #eeeeee;">S:1ECBECB96D020B2E74FF9BB02FD1EBED108361E19E4DBB246A81A110A185;39A689CAF7B52A8D</span>
</pre>
<br />
<div class="MsoNormal">
On voit que les mots de passe au niveau de DBA_USERS sont
cryptés, alors je note le mot de passe crypté de l’utilisateur SCOTT «<b> 80337D4D053124C7</b>
» .<o:p></o:p></div>
<div class="MsoNormal">
Après je vais modifier le mot de passe de SCOTT pour que je
peux utiliser sont compte :<o:p></o:p></div>
<div class="MsoNormal">
<pre><span style="background-color: #eeeeee;">ZIKO>ALTER USER SCOTT IDENTIFIED BY aaa;
Utilisateur modifié.
ZIKO>conn scott/aaa;
Connecté.
ZIKO>show user
USER est "SCOTT"
ZIKO></span>
</pre>
Maintenant je suis connecter avec l'utilisateur SCOTT, une fois terminé, je dois lui rendre son ancien mot de passe pour qu'il ne soit pas au courant, pour cela je vais utilisé la chaîne crypté de son origine mot de passe «<b> 80337D4D053124C7</b>» :<br />
<br />
<pre><span style="background-color: #eeeeee;">ZIKO>ALTER USER SCOTT IDENTIFIED BY VALUES '80337D4D053124C7';
Utilisateur modifié.
ZIKO>show user
USER est "SYS"
ZIKO>conn scott/ziko
Connecté.
ZIKO>show user
USER est "SCOTT"
ZIKO>
</span></pre>
<br />
Je voulais noter qu'il y a pas une possibilités pour voir les mots de passe en réel.<br />
<br />
@+</div>
</div>
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0tag:blogger.com,1999:blog-8921571192456997719.post-10000078776338787512013-02-09T04:16:00.004-08:002013-02-09T04:16:52.315-08:00TUNING : REGLAGE DE LA SHARED POOL<div dir="ltr" style="text-align: left;" trbidi="on">
1. REGLAGE DE LA SHARED POOL <br /><br />V$LIBRARYCACHE : contient des statistiques relatives à un type d’élément conservé dans le cache « library ». <br /><br />• NAMESPACE : Les éléments qui reflètent l’activité du cache « library » relative aux instructions SQL et aux blocs PL/SQL : SQL AREA, TABLE/PROCEDURE, BODY et TRIGGER<br />• GETS : affiche le nombre total de demandes d’informations sur l’élément correspondant.<br />• PINS : pour chaque zone, PINS affiche le nombre d’exécutions d’instructions ou de procédures SQL.<br />• RELOADS : si l’application appelle l’exécution d’une instruction SQL et que, dans le cache « library », la zone SQL partagée contenant la représentation analysée de cette instruction a été libérée afin de faire de la place à une autre instruction ou en raison de l’invalidation des objets indiqués par l’instruction, le serveur Oracle recharge implicitement cette instruction et, par conséquent, la réanalyse. Le nombre de rechargements est calculé pour chaque espace de nom.<br />• INVALIDATIONS : lorsqu’un objet est modifié, il est possible qu’il existe un meilleur chemin d’exécution pour toutes les instructions utilisant cet objet. C’est la raison pour laquelle le serveur Oracle marque toutes les exécutions utilisant un objet modifié comme non valides<br /><br /> LIBRARY CACHE HIT RATIO >90%:<br />
<br />
<strong><em>SELECT SUM(PINS-ROLOADS)/SUM(PINS)*100 ‘’Library cahce HIT-Ratio’’ <br /> FROM V$LIBRARYCACHE;</em></strong><br />
<strong><em><br /></em></strong>
RELOADS TO PINS <1%<strong><em><br /></em></strong><br />
<br />
<strong><em>SELECT SUM(ROLOADS)/SUM(PINS)*100 ‘’Reload-Ratio’’ <br /> FROM V$LIBRARYCACHE;</em></strong><br />
<strong><em><br /></em></strong>
PINS TO RELOADS <strong><em><br /></em></strong><br />
<br />
<strong><em>SELECT sum(pins), sum(reloads), sum(pins) * 100 / sum(pins+reloads) “Pin Hit%” FROM v$librarycache;</em></strong><br />
<strong><em><br /></em></strong>
V$SQLAREA: statistiques détaillées sur tous les curseurs partagés et 1000 premiers caractères de l’instruction SQL.<br /><br />V$SQL : cette vue répertorie les statistiques sur la zone SQL partagée et contient une ligne pour chaque enfant du texte SQL entré à l’origine. V$SQL est une vue similaire à V$SQLAREA, excepté le fait qu’elle ne comporte pas de clause GROUP BY qui peut rendre l’interrogation de la vue V$SQLAREA plus coûteuse.<br /><br />V$SQLTEXT : texte SQL complet sans troncature, affiché sur plusieurs lignes.<br /><br />V$DB_OBJECT_CACHE : objets de la base de données mis en mémoire cache, y compris les packages ; comprend également les tables et les synonymes lorsque ces objets sont référencés dans des instructions SQL.<br /><br />V$SHARED_POOL_RESERVED :Cette vue facilite le réglage du pool et de l’espace réservés au sein de la zone de mémoire partagée.<br /><br />• FREE_SPACE : est la quantité totale d’espace libre dans la liste d’espaces réservés.<br />• AVG_FREE_SIZE : est la taille moyenne de la mémoire libre dans la liste d’espaces réservés.<br />• MAX_FREE_SIZE : est la taille de la plus grande zone de mémoire libre dans la liste d’espaces réservés<br />• REQUEST_MISSES : est le nombre de fois où la liste d’espaces réservés ne possédait pas de mémoire libre pour satisfaire la demande et a commencé à retirer des objets de la iste LRU.<br />• REQUEST_FAILURES : est le nombre de fois où une demande n’a pas été satisfaite en raison de l’insuffisance de mémoire.<br />• LAST_FAILURE_SIZE : est la taille de la dernière demande non satisfaite<br /><br /><br /> objectif :<br /><br /> REQUEST_FAILURES ou REQUEST_MISSES proche de 0 ou/et n’augmentent pas.<br /> SHARED_POOL_RESERVED_SIZE~=10% de SHARED_POOL_SIZE<br /><strong> DBMS_SHARED_POOL .ABORTED_REQUEST_THRESHOLD</strong>: permet de restreindre la quantité de mémoire partagée à vider avant de signaler une erreur ORA-4031, afin de limiter l’étendue d’un vidage éventuellement provoqué par la présence d’un objet volumineux.<br />
<br /><strong>V$ROWCACHE :</strong> information sur dictionary cache :<br />
<br /><em>• PARAMETER :</em> donne le nom (de categorie) du cache du dictionnaire de données faisant l’objet de l’état.<br /><em>• GETS : </em>affiche le nombre total de demandes d’informations sur l’élément correspondant (par exemple, pour la ligne contenant des statistiques sur les descriptions de fichier, cette colonne indique le nombre total de demandes de données de description de fichier).<br /><em>• GETMISSES : </em>affiche le nombre de demandes de données ayant échoué en mémoire cache.<strong><em><br /></em></strong></div>
Anonymoushttp://www.blogger.com/profile/03320673928169469201noreply@blogger.com0