5 Replies Latest reply on May 2, 2011 6:02 AM by gsalem-Oracle

    select query on dba_mviews is hanging


      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..

      Oracle Database 11g Enterprise Edition Release - 64bit Production
      PL/SQL Release - Production
      CORE Production
      TNS for Linux: Version - Production
      NLSRTL Version - 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..