<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>
<div>On Apr 2, 2012, at 1:56 PM, Velayutham, Prakash wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Velayutham, Prakash wrote:</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% Hello,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% Spacewalk version - 1.6</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% OS - CentOS 6 (x86_64)</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% One of our Oracle DBAs recently mentioned that a query by Spacewalk is eating up a lot of TEMP space on the database server. Here is the query.</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% She gave a tuned version of this query to be implemented, but I wanted to see if this could be implemented upstream.</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% SELECT /*+first_rows*/ pkgp.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% FROM rhnPackageProvides pkgp,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% rhnPackageCapability pkgcap</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% WHERE pkgp.package_id in (select chpkg.package_id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% from rhnChannelPackage chpkg left join rhnPackageRepodata prd</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% ON prd.package_id = chpkg.package_id where chpkg.channel_id = :1</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% AND prd.primary_xml is null)</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% AND pkgp.capability_id = pkgcap.id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% order by pkgp.package_id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">%</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> </span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">% I am hoping one of the developers could take a look to see if this is doable.</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Hello Prakash,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">could you ask your DBA to check whether just removing /*+first_rows*/</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">hint also helps?</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">The query then should be</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">SELECT chpkg.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> FROM rhnPackageProvides pkgp,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> rhnPackageCapability pkgcap,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> rhnChannelPackage chpkg</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> LEFT JOIN rhnPackageRepodata prd</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> ON prd.package_id = chpkg.package_id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> WHERE chpkg.package_id = pkgp.package_id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> AND pkgp.capability_id = pkgcap.id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> AND chpkg.channel_id = :1</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> AND prd.primary_xml is null</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "> ORDER BY pkgp.package_id</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Regards,</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">--</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Michael Mr?ka</span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Satellite Engineering, Red Hat</span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Hi Michael,</span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Here is a detailed response from our DBA.</span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">If you remove the first_rows hint from both the old query , the number of blocks retrieved is the same at 5826 versus 108981. This might decrease the usage of TEMP space. We can try it and monitor.<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">SELECT /*+first_rows*/ chpkg.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">FROM rhnPackageProvides pkgp,<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnPackageCapability pkgcap, <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnChannelPackage chpkg left join rhnPackageRepodata prd<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">ON prd.package_id = chpkg.package_id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">WHERE chpkg.package_id = pkgp.package_id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND pkgp.capability_id = pkgcap.id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND chpkg.channel_id = 102 <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND prd.primary_xml is null <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">ORDER BY pkgp.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">/<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">call count cpu elapsed disk query current rows<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Parse 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Execute 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Fetch 1 1.56 1.57 0 108981 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">total 3 1.56 1.57 0 108981 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">SELECT chpkg.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">FROM rhnPackageProvides pkgp,<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnPackageCapability pkgcap, <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnChannelPackage chpkg left join rhnPackageRepodata prd<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">ON prd.package_id = chpkg.package_id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">WHERE chpkg.package_id = pkgp.package_id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND pkgp.capability_id = pkgcap.id <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND chpkg.channel_id = 102 <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND prd.primary_xml is null <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">ORDER BY pkgp.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">/<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">call count cpu elapsed disk query current rows<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Parse 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Execute 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Fetch 1 0.10 0.09 0 5826 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">total 3 0.10 0.09 0 5826 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">SELECT /*+first_rows*/ pkgp.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">FROM rhnPackageProvides pkgp,<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnPackageCapability pkgcap <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">WHERE pkgp.package_id in (select chpkg.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> from rhnChannelPackage chpkg left join rhnPackageRepodata prd<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> ON prd.package_id = chpkg.package_id where chpkg.channel_id = 102 <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> AND prd.primary_xml is null) <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND pkgp.capability_id = pkgcap.id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">order by pkgp.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">/<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">call count cpu elapsed disk query current rows<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Parse 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Execute 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Fetch 1 0.08 0.08 0 12606 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">total 3 0.08 0.08 0 12606 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">SELECT pkgp.package_id, pkgcap.id, pkgcap.name, pkgcap.version, pkgp.sense <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">FROM rhnPackageProvides pkgp,<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">rhnPackageCapability pkgcap <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">WHERE pkgp.package_id in (select chpkg.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> from rhnChannelPackage chpkg left join rhnPackageRepodata prd<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> ON prd.package_id = chpkg.package_id where chpkg.channel_id = 102 <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); "> AND prd.primary_xml is null) <o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">AND pkgp.capability_id = pkgcap.id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">order by pkgp.package_id<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">/<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">call count cpu elapsed disk query current rows<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Parse 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Execute 1 0.00 0.00 0 0 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">Fetch 1 0.06 0.06 0 5826 0 0<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">------- ------ -------- ---------- ---------- ---------- ---------- ----------<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: 'Berlin Sans FB', sans-serif; color: rgb(31, 73, 125); ">total 3 0.06 0.07 0 5826 0 0</span></div></span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; "><br></span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Does that answer your question?</span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Thanks,</span></pre>
<pre><span class="Apple-style-span" style="font-family: Helvetica; white-space: normal; ">Prakash</span></pre>
</div>
</blockquote>
<br>
</div>
<div><br>
</div>
<div>Hi,</div>
<div><br>
</div>
<div>Just wanted to know if you had any feedback on this response.</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Prakash</div>
</body>
</html>