5 Replies Latest reply: May 2, 2011 1:02 AM by gsalem RSS

    select query on dba_mviews is hanging

    800104
      Hi,

      Can somebody guide me...??

      When I execute select statement for dba_mviews it is hanging forever..

      Strange thing is when I select column NUM_FRESH_PCT_REGIONS and NUM_STALE_PCT_REGIONS from dba_mviews only then it is hanging..otherwise it works fine..

      sql>BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE 11.2.0.1.0 Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production


      It is an exadata environment...

      I even tried with making the cell_offload_processing to false at session level..but still it didn't work..Plz help..