[Spacewalk-list] Query eating Oracle DB TEMP space

[Michael Mraka]

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.
% > % 
% > % 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 observed the same behaviour so thank you for confirmation.
% > I commited a change which removed first_row hint from current queries to
% > spacewlk master branch (commit f8c71ef4ae14db95ba3650cac3b55f1f9f153c6b).

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat