+++ This bug was initially created as a clone of Bug #701457 +++

Description of problem:

On Satellite with more than 30k clients registered, the query below does not scale. 

SQL> SELECT DISTINCT
       S.id AS server_id, S.org_id org_id
  FROM rhnServer S
  JOIN rhnServerNeededView SNV
    on SNV.server_id = S.id
 WHERE SNV.channel_id = 1181
   AND SNV.errata_id = 31276
 AND EXISTS
   (SELECT 1 FROM rhnServerFeaturesView SFV WHERE
    SFV.server_id = S.id AND SFV.label = 'ftr_auto_errata_updates')
   AND UPPER(s.auto_update) = 'Y'
ORDER BY S.org_id  2    3    4    5    6    7    8    9   10   11
12  ;
ORDER BY S.org_id
               *
ERROR at line 12:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS

oracle@244531-rhndb1 ~]$ top

top - 10:09:48 up 87 days, 21:57,  2 users,  load average: 2.06, 2.42, 2.75
Tasks: 303 total,   2 running, 301 sleeping,   0 stopped,   0 zombie
Cpu(s): 25.9%us,  0.8%sy,  0.0%ni, 62.6%id, 10.1%wa,  0.1%hi,  0.5%si,  0.0%st
Mem:  37037420k total, 36516056k used,   521364k free,   398348k buffers
Swap: 37736676k total,   399272k used, 37337404k free, 29397360k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+ COMMAND
26629 oracle    25   0 5914m 1.4g 1.3g R 99.6  4.0   3623:27 oracle
11208 oracle    15   0 8031m 3.7g 1.6g S 75.3 10.4   4717:38 oracle
23601 oracle    15   0 8095m 3.6g 1.5g S 24.3 10.2   2388:48 oracle
5449 oracle    15   0 5771m 125m 122m S 12.4  0.3   0:01.10 oracle