Database

Get Involved. Join the Conversation.

Topic

    Cristian Betancur
    ORA-10260: limit size (1048576) of the PGA heap set...
    Topic posted April 10, 2019 by Cristian BetancurBlue Ribbon: 750+ Points, tagged Apex, DBCS, Express, Patching, UI 
    70 Views, 1 Comment
    Title:
    ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded in DataLoad Wizard
    Summary:
    Dataload Wizard, into Oracle APEX with Oracle Database Cloud Schema Service, shows this error when I upload a file wit *.csv extension: ORA-10260
    Content:

    Hi

    I have an application In Oracle APEX, into Oracle Database Cloud Schema Service instance. It has a page with a DataLoad Wizard. When I upload a file with *.csv extension and 60,5MB, shows the next error: Error: SyntaxError: Unexpected end of JSON input.

    I enabled Debug in my application, and I saw the next error into Log information (I have uploaded it into this post):

    ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded
    

    I want to know what is the possible solution to this issue, because It is an important page to Tax Customer process.

    Thanks

    Cristian. 

    Version:
    APEX: 18.2.0.00.12; Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production; Oracle Database Cloud Schema Service: 16.1.0.0.0
    Document:

    Comment

     

    • Vladislav Uvarov

      Hi Cristian,

      You should split the large CSV file into multiple smaller files and perform the upload operation multiple times.

      -- Vlad