tag:blogger.com,1999:blog-10384843968492184592024-02-09T00:17:24.276+11:00Oracle DBA notesAlexhttp://www.blogger.com/profile/11792418117922681882noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1038484396849218459.post-55140591140867927812012-05-24T09:48:00.000+10:002012-05-24T09:48:00.439+10:00Oracle Clound Countrol 12c and runaway agent<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;">It would be good idea to limit number of session for DBSNMP user on all monitored hosts. Agent opened 1600+ sessions this morning and as a result `ORA-00020: maximum number of processes XXXX exceeded`.</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">CREATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PROFILE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> DBSNMP_PROFILE </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">LIMIT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">SESSIONS_PER_USER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">50</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">CPU_PER_SESSION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">CPU_PER_CALL</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">100000</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">CONNECT_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">IDLE_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">LOGICAL_READS_PER_SESSION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">LOGICAL_READS_PER_CALL</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">COMPOSITE_LIMIT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PRIVATE_SGA</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">FAILED_LOGIN_ATTEMPTS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_LIFE_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_REUSE_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_REUSE_MAX</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_LOCK_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_GRACE_TIME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">UNLIMITED</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PASSWORD_VERIFY_FUNCTION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">NULL;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">ALTER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">USER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> DBSNMP </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">PROFILE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> DBSNMP_PROFILE</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="mso-ansi-language: EN-US;"></span></div>
</div>Alexhttp://www.blogger.com/profile/11792418117922681882noreply@blogger.com2tag:blogger.com,1999:blog-1038484396849218459.post-91161914702927597542012-05-03T10:13:00.002+10:002012-05-03T10:13:44.112+10:00symstat output to oracle table<div dir="ltr" style="text-align: left;" trbidi="on">
This post is for my own records. A couple of scripts I developed to load
<span style="font-family: "Courier New", "Courier", monospace;">symstat</span>
output to oracle table for analyzis. Tested on DMX4 with the latest symcli.<br />
<br />
<br />
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">symstat</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">-i</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">60</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">-type</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">-sid</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">0990</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">></span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">symdisks_stat.log</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">egrep</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">-</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">v</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">"DISK|READ|Total"</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">symdisks_stat.log</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">></span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">src_symdisks_stat<span style="color: blue;">.</span><span style="color: black;">lst</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CREATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TABLE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DS</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">VARCHAR2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">20</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BYTE),</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">KR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">KW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TIMESTRING</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">VARCHAR2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">25</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BYTE)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<h1>
<span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">fsymdisks_stat</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">ctl</span></h1>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">LOAD</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DATA</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">INFILE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">'src_symdisks_stat.lst'</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">INTO</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TABLE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ds</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TIMESTRING</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">9</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CHAR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">10</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">16</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CHAR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">32</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">37</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">char</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">39</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">44</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CHAR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">KR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">46</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">52</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CHAR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">KW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">POSITION</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">54</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">60</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CHAR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">--update timestamp</span></i>
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DECLARE</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">t</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;">
</span></span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">VARCHAR2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">15</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FOR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ROWID</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">timestring</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ds</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">LOOP</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IF</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">timestring</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">NULL</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">THEN</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">UPDATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ds</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SET</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">timestring</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">t</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ROWID</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ROWID</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ELSE</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">t</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">:=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">timestring</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">END</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IF;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">END</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">LOOP;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">WITH</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">Q</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TRUNC(AVG(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">))</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AVG_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TRUNC(AVG(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">))</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AVG_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">GROUP</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ORDER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DESC)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> * </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">Q</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AVG_IW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">100</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">--50000 IS ENOUGH FOR ~7H WORKLOAD</span></i></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">WITH</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">Q</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">(SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TRUNC(AVG(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">))</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AVG_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TRUNC(AVG(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">))</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AVG_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">GROUP</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DISK</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">ORDER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">BY</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">DESC)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">+</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">||</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">' '</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">||</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">'TOTAL'</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IOS</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">COUNT(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">*</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">CNT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">Q</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-layout-grid-align: none; text-autospace: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-highlight: white;">UNION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span></div>
<div class="MsoNormal">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">SUM(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">+</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IR</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">||</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">' '</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">||</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">'BUSIEST'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">COUNT(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">*</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">Q</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IW</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">+</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">TOTAL_IR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">50000</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">;</span></div>
<br />
<br /></div>Alexhttp://www.blogger.com/profile/11792418117922681882noreply@blogger.com0tag:blogger.com,1999:blog-1038484396849218459.post-41238341050812462072011-11-04T18:06:00.001+11:002011-11-07T09:38:02.814+11:00SSD (EFD) devices for Oracle Redo<div dir="ltr" style="text-align: left;" trbidi="on"><span lang="EN-US" style="mso-ansi-language: EN-US;"></span> <br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-size: 12pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><span style="font-family: Calibri;">I performed one more testing of this subject and found that results are quite interesting. RAID5 7+1 on High-End disk system was used as dedicated device for redo log files (RH Linux 5.5, redo filesystem formatted to ext2, Oracle 11.2.0.3)</span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-size: 12pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><span style="font-family: Calibri;">Load generator script is simple and does commit after each (!) insert.</span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">create</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">table</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">&1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">(id</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">number</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">v</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">varchar2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">2000</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">))</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">tablespace</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-highlight: white;">users;</span><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FOR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">IN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">..</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">100000000</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">LOOP</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">IF</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">MOD</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">10000</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">0</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">THEN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">EXECUTE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">IMMEDIATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'truncate table &1 drop storage'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">IF;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">INSERT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">INTO</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> &</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VALUES</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">i</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">COMMIT;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">LOOP;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END</span><span lang="RU" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: RU; mso-highlight: white;">;</span><span lang="RU" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: RU; mso-highlight: white;"></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span lang="RU" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: RU; mso-highlight: white;">/</span><span lang="RU" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: RU; mso-highlight: white;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-size: 12pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><span style="font-family: Calibri;">I got roughly 43MBS of redo with 2 concurrent processes running. <span style="mso-spacerun: yes;"> </span>await is amazing ~0.55msec! All writes are served by the cache of the storage array. All redo related wait events are negligible. </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Device:<span style="mso-spacerun: yes;"> </span>rrqm/s<span style="mso-spacerun: yes;"> </span>wrqm/s<span style="mso-spacerun: yes;"> </span>r/s<span style="mso-spacerun: yes;"> </span>w/s<span style="mso-spacerun: yes;"> </span>rMB/s<span style="mso-spacerun: yes;"> </span>wMB/s avgrq-sz avgqu-sz<span style="mso-spacerun: yes;"> </span>await<span style="mso-spacerun: yes;"> </span>svctm<span style="mso-spacerun: yes;"> </span>%util</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 1675.80<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>52.79<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">64.52</span><span style="mso-spacerun: yes;"> </span>0.90<span style="mso-spacerun: yes;"> </span>0.54<span style="mso-spacerun: yes;"> </span>0.53<span style="mso-spacerun: yes;"> </span>89.19</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 1835.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>54.10<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">60.38</span><span style="mso-spacerun: yes;"> </span>0.94<span style="mso-spacerun: yes;"> </span>0.51<span style="mso-spacerun: yes;"> </span>0.51<span style="mso-spacerun: yes;"> </span>92.69</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 1619.60<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>52.02<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">65.78</span><span style="mso-spacerun: yes;"> </span>0.93<span style="mso-spacerun: yes;"> </span>0.57<span style="mso-spacerun: yes;"> </span>0.57<span style="mso-spacerun: yes;"> </span>92.02</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 1645.40<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>50.96<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">63.43</span><span style="mso-spacerun: yes;"> </span>0.94<span style="mso-spacerun: yes;"> </span>0.57<span style="mso-spacerun: yes;"> </span>0.56<span style="mso-spacerun: yes;"> </span>92.72</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 1408.79<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>49.82<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">72.42</span><span style="mso-spacerun: yes;"> </span>0.93<span style="mso-spacerun: yes;"> </span>0.66<span style="mso-spacerun: yes;"> </span>0.64<span style="mso-spacerun: yes;"> </span>90.36</span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">...</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Load Profile<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>Per Second<span style="mso-spacerun: yes;"> </span>Per Transaction<span style="mso-spacerun: yes;"> </span>Per Exec<span style="mso-spacerun: yes;"> </span>Per Call</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">~~~~~~~~~~~~<span style="mso-spacerun: yes;"> </span>---------------<span style="mso-spacerun: yes;"> </span>--------------- ---------- ----------</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Redo size:<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">43,526,576.9</span><span style="mso-spacerun: yes;"> </span>2,291.7</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Logical reads:<span style="mso-spacerun: yes;"> </span>117,138.2<span style="mso-spacerun: yes;"> </span>6.2</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Block changes:<span style="mso-spacerun: yes;"> </span>124,364.1<span style="mso-spacerun: yes;"> </span>6.6</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Physical reads:<span style="mso-spacerun: yes;"> </span>2.1<span style="mso-spacerun: yes;"> </span>0.0</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Physical writes:<span style="mso-spacerun: yes;"> </span>9,053.5<span style="mso-spacerun: yes;"> </span>0.5</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Executes:<span style="mso-spacerun: yes;"> </span>19,003.3<span style="mso-spacerun: yes;"> </span>1.0</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Transactions:<span style="mso-spacerun: yes;"> </span>18,993.4</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">...</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Top 5 Timed Foreground Events</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Avg<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>wait<span style="mso-spacerun: yes;"> </span>% DB<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Event<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>Waits<span style="mso-spacerun: yes;"> </span>Time(s)<span style="mso-spacerun: yes;"> </span>(ms)<span style="mso-spacerun: yes;"> </span>time Wait Class</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">------------------------------ ------------ ----------- ------ ------ ----------</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">DB CPU<span style="mso-spacerun: yes;"> </span>188<span style="mso-spacerun: yes;"> </span>99.4<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">log buffer space<span style="mso-spacerun: yes;"> </span>22<span style="mso-spacerun: yes;"> </span>1<span style="mso-spacerun: yes;"> </span>34<span style="mso-spacerun: yes;"> </span>.4 Configurat</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Data file init write<span style="mso-spacerun: yes;"> </span>516<span style="mso-spacerun: yes;"> </span>0<span style="mso-spacerun: yes;"> </span>0<span style="mso-spacerun: yes;"> </span>.1 User I/O<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">log file switch completion<span style="mso-spacerun: yes;"> </span>20<span style="mso-spacerun: yes;"> </span>0<span style="mso-spacerun: yes;"> </span>4<span style="mso-spacerun: yes;"> </span>.0 Configurat</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">log file sync<span style="mso-spacerun: yes;"> </span>2<span style="mso-spacerun: yes;"> </span>0<span style="mso-spacerun: yes;"> </span>39<span style="mso-spacerun: yes;"> </span>.0 Commit<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-size: 12pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><span style="font-family: Calibri;">7 parallel processes produce 86MB of redo per second. avgrq-sz rose by 10 times, hense await<span style="mso-spacerun: yes;"> </span>rose to 5msec as well. I have no idea why :(<br />
Redo waits now ~35% of total waits.</span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Device:<span style="mso-spacerun: yes;"> </span>rrqm/s<span style="mso-spacerun: yes;"> </span>wrqm/s<span style="mso-spacerun: yes;"> </span>r/s<span style="mso-spacerun: yes;"> </span>w/s<span style="mso-spacerun: yes;"> </span>rMB/s<span style="mso-spacerun: yes;"> </span>wMB/s avgrq-sz avgqu-sz<span style="mso-spacerun: yes;"> </span>await<span style="mso-spacerun: yes;"> </span>svctm<span style="mso-spacerun: yes;"> </span>%util</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 325.90<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>103.96<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">653.29</span><span style="mso-spacerun: yes;"> </span>1.77<span style="mso-spacerun: yes;"> </span>5.44<span style="mso-spacerun: yes;"> </span>2.81<span style="mso-spacerun: yes;"> </span>91.57</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 365.70<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>108.86<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">609.61</span><span style="mso-spacerun: yes;"> </span>1.82<span style="mso-spacerun: yes;"> </span>4.97<span style="mso-spacerun: yes;"> </span>2.48<span style="mso-spacerun: yes;"> </span>90.77</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 343.80<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>107.91<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">642.84</span><span style="mso-spacerun: yes;"> </span>1.77<span style="mso-spacerun: yes;"> </span>5.14<span style="mso-spacerun: yes;"> </span>2.67<span style="mso-spacerun: yes;"> </span>91.80</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 370.03<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>119.00<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">658.65</span><span style="mso-spacerun: yes;"> </span>1.76<span style="mso-spacerun: yes;"> </span>4.76<span style="mso-spacerun: yes;"> </span>2.44<span style="mso-spacerun: yes;"> </span>90.39</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">dm-12<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>0.00 362.60<span style="mso-spacerun: yes;"> </span>0.00<span style="mso-spacerun: yes;"> </span>113.42<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">640.62</span><span style="mso-spacerun: yes;"> </span>1.76<span style="mso-spacerun: yes;"> </span>4.86<span style="mso-spacerun: yes;"> </span>2.50<span style="mso-spacerun: yes;"> </span>90.48</span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Load Profile<span style="mso-spacerun: yes;"> </span>Per Second<span style="mso-spacerun: yes;"> </span>Per Transaction<span style="mso-spacerun: yes;"> </span>Per Exec<span style="mso-spacerun: yes;"> </span>Per Call</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">~~~~~~~~~~~~<span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>---------------<span style="mso-spacerun: yes;"> </span>--------------- ---------- ----------</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Redo size:<span style="mso-spacerun: yes;"> </span><span style="background: fuchsia; mso-highlight: fuchsia;">86,854,088.7</span><span style="mso-spacerun: yes;"> </span>2,312.4</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Logical reads:<span style="mso-spacerun: yes;"> </span>243,571.1<span style="mso-spacerun: yes;"> </span>6.5</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Block changes:<span style="mso-spacerun: yes;"> </span>251,819.1<span style="mso-spacerun: yes;"> </span>6.7</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Physical reads:<span style="mso-spacerun: yes;"> </span>40.0<span style="mso-spacerun: yes;"> </span>0.0</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Physical writes:<span style="mso-spacerun: yes;"> </span>20,626.0<span style="mso-spacerun: yes;"> </span>0.6</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Executes:<span style="mso-spacerun: yes;"> </span>37,959.4<span style="mso-spacerun: yes;"> </span>1.0</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Transactions:<span style="mso-spacerun: yes;"> </span>37,560.4</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-tab-count: 1;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">....</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Top 5 Timed Foreground Events</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>Avg<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";"><span style="mso-spacerun: yes;"> </span>wait<span style="mso-spacerun: yes;"> </span>% DB<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">Event<span style="mso-spacerun: yes;"> </span>Waits<span style="mso-spacerun: yes;"> </span>Time(s)<span style="mso-spacerun: yes;"> </span>(ms)<span style="mso-spacerun: yes;"> </span>time Wait Class</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">------------------------------ ------------ ----------- ------ ------ ----------</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">DB CPU<span style="mso-spacerun: yes;"> </span>2,053<span style="mso-spacerun: yes;"> </span>58.6<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">log buffer space<span style="mso-spacerun: yes;"> </span>36,487<span style="mso-spacerun: yes;"> </span>858<span style="mso-spacerun: yes;"> </span>24<span style="mso-spacerun: yes;"> </span>24.5 Configurat</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">local write wait<span style="mso-spacerun: yes;"> </span>4,956<span style="mso-spacerun: yes;"> </span>343<span style="mso-spacerun: yes;"> </span>69<span style="mso-spacerun: yes;"> </span>9.8 User I/O<span style="mso-spacerun: yes;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">enq: RO - fast object reuse<span style="mso-spacerun: yes;"> </span>3,140<span style="mso-spacerun: yes;"> </span>138<span style="mso-spacerun: yes;"> </span>44<span style="mso-spacerun: yes;"> </span>3.9 Applicatio</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-family: "Courier New";">enq: HW - contention<span style="mso-spacerun: yes;"> </span>16,982<span style="mso-spacerun: yes;"> </span>85<span style="mso-spacerun: yes;"> </span>5<span style="mso-spacerun: yes;"> </span>2.4 Configurat</span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-size: 12pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><span style="font-family: Calibri;">Conclusion: we don’t need SSD devices for redo on our storage array but entry level arrays and standalone servers should be tested.</span></span></div></div>Alexhttp://www.blogger.com/profile/11792418117922681882noreply@blogger.com3tag:blogger.com,1999:blog-1038484396849218459.post-34417454560712254052011-11-03T12:31:00.000+11:002014-10-03T13:35:31.404+10:00How to limit execution rate for particular query<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span style="font-family: Calibri;"><span lang="EN-US" style="mso-ansi-language: EN-US;">While investigation high system load after new application release I found that group of daemons were checking one table for new rows… thousands time</span>s per second. 4 cores were busy executing the same query again and again. Following temporary solution was implemented to solve the problem without application reconfiguration and restart. <span lang="EN-US" style="mso-ansi-language: EN-US;"></span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">--setup test user with DBA role. just don't want to bother with permissions</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">create</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">user</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">testrw</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">identified</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">by</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rw</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">default</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">tablespace</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">users;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">grant</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">dba</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">to</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">testrw</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">grant</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">execute</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">on</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">dbms_lock</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">to</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">testrw</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">grant</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">execute</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">on</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_ADVANCED_REWRITE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">to</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">testrw</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">conn</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">testrw</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">/</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rw</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DROP</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">TABLE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DROP</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VIEW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">v1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">-- test table that represents our application table</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">CREATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">TABLE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VARCHAR2</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">10</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">));</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">--sleep function will be used for rewrite</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">CREATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">OR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">REPLACE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FUNCTION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: olive; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">do_sleep</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">n</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">IN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">RETURN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">NUMBER</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<b><i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_LOCK.sleep</span></i></b><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">n</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">RETURN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">/</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">show</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">errors</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">--rewritten queries will use this view</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">CREATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">OR</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">REPLACE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VIEW</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">v1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">AS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> *</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: olive; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">do_sleep</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">)</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">--setup rewrite </span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SYS</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><b><i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_ADVANCED_REWRITE.drop_rewrite_equivalence</span></i></b><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'t1_to_v1_rewrite'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">EXCEPTION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">WHEN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">OTHERS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">THEN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">NULL;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SYS</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><b><i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_ADVANCED_REWRITE.declare_rewrite_equivalence</span></i></b><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(NAME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'t1_to_v1_rewrite'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">source_stmt</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'SELECT c1 FROM t1'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">destination_stmt</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'SELECT c1 FROM v1'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VALIDATE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FALSE,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rewrite_mode</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'GENERAL'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">/</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;">All looks fine and supposed to work but it doesn’t!</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">from</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00.00</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;">It is expected and we have to switch from default query_rewrite_integrity to trusted.</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">alter</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">session</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">set</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">query_rewrite_integrity</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">trusted;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Session</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">altered</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">.</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00.00</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">from</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">02.01</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span style="background: white; mso-highlight: white;"><span style="font-family: Calibri;">The problem is that it works the same way for all where clauses:</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">variable</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">varchar2</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">exec</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:=</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'C'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">select</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> * </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">from</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">where</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">02.00</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">select</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> * </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">from</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">where</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;">!</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">02.00</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;">It is slightly not what we wanted before, our task was limit the rate for *particular* query.</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">alter</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">session</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">set</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">query_rewrite_integrity</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">enforced;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DECLARE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">sqlt</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">VARCHAR2</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">32000</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">BEGIN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><b><i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_SQLTUNE.drop_sql_profile</span></i></b><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'sp_rewrite_t1_to_v1'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">);</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">EXCEPTION</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">WHEN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">OTHERS</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">THEN</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">NULL;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">sqlt</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'SELECT c1 FROM t1 WHERE c1 != :b1'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><b><i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">DBMS_SQLTUNE.import_sql_profile</span></i></b><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(NAME</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'sp_rewrite_t1_to_v1'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">sql_text</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">sqlt</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">force_match</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">TRUE,</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">PROFILE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">sqlprof_attr</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">(</span><span lang="EN-US" style="background: white; color: red; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">'OPT_PARAM(''query_rewrite_integrity'' ''TRUSTED'')'</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">));</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">END;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">/</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;">And final tests:</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">--two seconds as expected</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> !</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">02.00</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<i><span lang="EN-US" style="background: white; color: green; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">-- query was not rewritten</span></i><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SQL></span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">SELECT</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">FROM</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">t1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">WHERE</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">c1</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">=</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">b1</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">;</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">no</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">rows</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">selected</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">
<span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">Elapsed</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"> </span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00</span><span lang="EN-US" style="background: white; color: blue; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">:</span><span lang="EN-US" style="background: white; color: maroon; font-family: "Courier New"; font-size: 10pt; mso-ansi-language: EN-US; mso-highlight: white;">00.00</span><span lang="EN-US" style="background: white; color: black; font-family: "Courier New"; mso-ansi-language: EN-US; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span style="font-family: Calibri;">Problem has been resolved. The only limitation is to stay on default value of <span style="background: white; mso-highlight: white;">query_rewrite_integrity</span> and additional license on “Tuning Pack”.</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span style="font-family: Calibri;">Note 392214.1 was used as the reference. </span></div>
</div>
Alexhttp://www.blogger.com/profile/11792418117922681882noreply@blogger.com0