1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Getting out of process memory when trying to allocate while refreshing materalized view

Discussion in 'SQL PL/SQL' started by sneha.bharti, Mar 30, 2017.

  1. sneha.bharti

    sneha.bharti Active Member

    Messages:
    45
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Dear All,

    Greetings of the day !
    I need a help .I am working on a report now, in which I am using a materailized view, while refreshing it I am getting this error "out of process memory when trying to allocate 1094464 bytes", I have tried extending the temp tablespace memory but found the same error.

    Please help !
    Thank you.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,601
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Process memory is not the temporary tablespace, it's RAM and you most likely have too much memory allocated to your SGA and it's consuming so much memory that processes can't run to completion. You need to adjust SGA and PGA settings; no amount of 'fiddling' with the temp tablespace will help.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    771
    Likes Received:
    146
    Trophy Points:
    830
    Location:
    Russian Federation
    For exact diagnostics it is necessary to know precisely a few points :
    - what is the load on the system at run-time
    - is actual a statistics
    - is optimal the plan for your query .
    Can you provide the execution plan of your report?
    Perhaps,that the problem is in the report query.
     
  4. sneha.bharti

    sneha.bharti Active Member

    Messages:
    45
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Thank you Mr. Krasnoslobodtsev,

    I did some changes in my query for materialized view and it started working.