Velayutham, Prakash wrote:
% Will this change get back into 1.6?
Currently we don't plan backporting it to 1.6.
% Prakash
%
% On Apr 6, 2012, at 5:06 AM, Michael Mraka wrote:
%
% > Velayutham, Prakash wrote:
% > % Hi Michael,
% > %
% > % Here is a detailed response from our DBA.
% > %
% > %
Will this change get back into 1.6?
Prakash
On Apr 6, 2012, at 5:06 AM, Michael Mraka wrote:
> Velayutham, Prakash wrote:
> % Hi Michael,
> %
> % Here is a detailed response from our DBA.
> %
> % If you remove the first_rows hint from both the old query , the number of
> blocks retrieved is t
Velayutham, Prakash wrote:
% Hi Michael,
%
% Here is a detailed response from our DBA.
%
% 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.
...
I
On Apr 2, 2012, at 1:56 PM, Velayutham, Prakash wrote:
Velayutham, Prakash wrote:
% Hello,
%
% Spacewalk version - 1.6
% OS - CentOS 6 (x86_64)
%
% 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.
%
%
Velayutham, Prakash wrote:
% Hello,
%
% Spacewalk version - 1.6
% OS - CentOS 6 (x86_64)
%
% 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.
%
%
% She gave a tuned version of this query to be implemente
Velayutham, Prakash wrote:
% Hello,
%
% Spacewalk version - 1.6
% OS - CentOS 6 (x86_64)
%
% 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.
%
%
% She gave a tuned version of this query to be implem
Hello,
Spacewalk version - 1.6
OS - CentOS 6 (x86_64)
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.
SELECT /*+first_rows*/ chpkg.package_id, pkgcap.id, pkgcap.name,
pkgcap.version, pkgp.sense
FRO