Database Memory & 4030/4031 (MOSC)

MOSC Banner

send an 80MB document by consuming a WS

in Database Memory & 4030/4031 (MOSC) 3 commentsAnswered

We are trying to send an 80MB document by consuming a WS from DB (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) and presents us with the following message:

ORA-00604 ERROR occurred at recursive SQL level 1

ORA-00039 ERROR during periodic action

ORA-04036 PGA memory used by instance exceeds PGA_AGGREGATE_LMIT

According to the ORACLE documentation (https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1) it should be change a parameter in the DB, my question is: can you increase this parameter only for one user?

--------------------------------------------------------------------------------------------------------------

Estamos intentando enviar un documento de 80 MB al consumir un WS desde la DB (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) y nos presenta el siguiente mensaje:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center