Description of problem:
Configuration Overview page takes ~90 seconds to load. Deploying files are also slow and occasionally errors out (in the beginning of the report it used to consistently error out with traceback).

web UI /rhn/configuration/Overview.do page is slow - it loads in about 90-120 sec for me.  I took a snapshot vs. oracle statspack for the single action of clicking on and thus loading this page.  There may be performance issues in java layer as well, but as far as oracle, the following query is shown in the report as taking about 1 minute -
...
    CPU                  CPU per             Elapsd                     Old
  Time (s)   Executions  Exec (s)  %Total   Time (s)    Buffer Gets  Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
      0.45            1       0.45   37.2      55.33          24,538 3763434616
SELECT DISTINCT TC.* from  (select CF.id, CC.id AS config_channe
l_id, CFT.label AS type,               CFN.path, CCT.label AS co
nfig_channel_type, CF.modified,               CC.name AS config_
channel_name          from rhnConfigFile CF, rhnConfigChannel CC
, rhnConfigFileName CFN,               rhnConfigChannelType CCT,
...
which corresponds to recent_modified_config_files_for_user query in
code/src/com/redhat/rhn/common/db/datasource/xml/config_queries.xml:
...
<mode name="recent_modified_config_files_for_user"
class="com.redhat.rhn.frontend.dto.ConfigFileDto">
  <query params="org_id, user_id, num">
SELECT DISTINCT TC.*
from  (select CF.id, CC.id AS config_channel_id, CFT.label AS type,
              CFN.path, CCT.label AS config_channel_type, CF.modified,
              CC.name AS config_channel_name
         from rhnConfigFile CF, rhnConfigChannel CC, rhnConfigFileName CFN,
              rhnConfigChannelType CCT, rhnConfigRevision CR, rhnConfigFileType
CFT
        where CF.config_channel_id = CC.id
          and CC.org_id = :org_id
          and CC.confchan_type_id = CCT.id
          and CF.config_file_name_id = CFN.id
          and CF.latest_config_revision_id = CR.id
          and CR.config_file_type_id = CFT.id
          and rhn_config_channel.get_user_file_access(CF.id, :user_id) = 1
     order by CF.modified desc) TC
where rownum &lt;= :num
  </query>
</mode>

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info: