Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 877321003359D3 for ; Fri, 21 Aug 2020 14:52:03 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 925AB23880; Fri, 21 Aug 2020 08:51:08 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1598014268; bh=dVYgKmWqkQkvWHK24BQRKQNLKMrcZT+ED1b/iJ+1mo8=; h=From:Sender:Sender:From; b=SUq4Z/Npk48fpBsz41Sc5bb7M0VhI85QraKiUN5I07OJU34MzQTPeEesa8l9oWYsa tLDdKhzNj5jlPvEWomhpBSSLSHN2qIboxwEFzrON3bbmm0KGrwmxjashYb2moUH1R/ 03FUNXQaad1HJLscaasRI9SASRI8GejwTX1pJDRU= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fRmW-UijW3OO; Fri, 21 Aug 2020 08:51:08 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B92921FF4; Fri, 21 Aug 2020 08:50:22 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1598014266; bh=dVYgKmWqkQkvWHK24BQRKQNLKMrcZT+ED1b/iJ+1mo8=; h=From:Sender:Sender:From; b=iGOdIPVcH7D0zJCJN+VF7Ie5s+zK7jcCXizn5CfOV49uZtdi5KzC4B366wXuLDxv0 F9D3gRfxIeU00oYZ1yKuMXAtYIhKHeBPvg7IhcLhh78xh+fc1RBY3TZE+/tcZX56Xo mX9Zimd+c6nWb22RtLR0k+gNeIZnan6Qz6TCXD+Y= Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 Aug 2020 08:49:37 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E011F25954 for ; Fri, 21 Aug 2020 08:49:36 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RKgL3PBdC7KI for ; Fri, 21 Aug 2020 08:49:36 -0400 (EDT) Received: from smtp1.vontobel.ch (smtp1.vontobel.ch [194.56.165.25]) (using TLSv1.2 with cipher ADH-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 7EFB22594B for ; Fri, 21 Aug 2020 08:49:36 -0400 (EDT) Received: from vontobel.ch (localhost [127.0.0.1]) by smtp1.vontobel.ch (Mission Control Email Gateway, 18401) with SMTP id 4BY1Yq0D21zcWsC for ; Fri, 21 Aug 2020 14:49:35 +0200 (MEST) Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 Authentication-Results: vonn-mx001-ch-zur-1; dkim=none IronPort-SDR: ROWHKfT5JC4Z1a44GdDUqAl1dl1HIbBZOOP5Jqz4AzHuYZJkj2lz8Sf2JLbpH4lFU+2SRETqAa 71tOqDbNk2Gw== Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 X-DLP-CHECK: passed MIME-Version: 1.0 Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 IronPort-SDR: ume3cN6oama1bQs62K3fk1CjrAzKJc4PyHUJLoWul2vWJxtnqqgKhjlPE0aD17ZXuYNfvt6H6z kHDaXDwnadxg== Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 Received: from trusted client by smtp1.vontobel.ch; Fri Aug 21 14:49:35 2020 From: Noveljic Nenad To: "ORACLE-L (oracle-l@freelists.org)" Subject: Reproducing ORA-04036 Thread-Topic: Reproducing ORA-04036 Date: Fri, 21 Aug 2020 12:49:13 +0000 Message-ID: <8562_1598014175_5F3FC2DF_8562_2555_1_27378bab0c664171a446991b88b5f127@vontobel.com> Accept-Language: de-CH, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: multipart/alternative; boundary="_000_27378bab0c664171a446991b88b5f127vontobelcom_" X-archive-position: 77554 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: nenad.noveljic@vontobel.com Precedence: normal Reply-To: nenad.noveljic@vontobel.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --_000_27378bab0c664171a446991b88b5f127vontobelcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Anybody has a script for reproducing ORA-04036 in 19c? Allocating PL/SQL co= llections doesn't trigger the error: SQL> select max(pga_alloc_mem)/power(1024,2) from v$process ; MAX(PGA_ALLOC_MEM)/POWER(1024,2) -------------------------------- 6466.71202 SQL> show parameter pga PARAMETER_NAME TYPE VALUE ------------------------------------------------------------ ----------- --= ---------------------------------------------------------------------------= ----------------------- pga_aggregate_limit big integer 2G SQL> !dbhome .../product/19.7.0.0.200414 I had a nice test case with excessive PGA allocations during parsing in 12c= , but "unfortunately" Oracle fixed that problem. Best regards, Nenad https://nenadnoveljic.com/blog/about ____________________________________________________ Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.


Important Notice

This message is intended only for the individual named. It may contain conf= idential or privileged information. If you are not the named addressee you = should in particular not disseminate, distribute, modify or copy this e-mai= l. Please notify the sender immediately by e-mail, if you have received thi= s message by mistake and delete it from your system.
Without prejudice to any contractual agreements between you and us which sh= all prevail in any case, we take it as your authorization to correspond wit= h you by e-mail if you send us messages by e-mail. However, we reserve the = right not to execute orders and instructions transmitted by e-mail at any t= ime and without further explanation.
E-mail transmission may not be secure or error-free as information could be= intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also p= rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob= el Holding Ltd. and any of its affiliates (hereinafter collectively referre= d to as "Vontobel Group") for any damages resulting from e-mail use is excl= uded. You are advised that urgent and time sensitive messages should not be= sent by e-mail and if verification is required please request a printed ve= rsion.
Please note that all e-mail communications to and from the Vontobel Group a= re subject to electronic storage and review by Vontobel Group. Unless state= d to the contrary and without prejudice to any contractual agreements betwe= en you and Vontobel Group which shall prevail in any case, e-mail-communica= tion is for informational purposes only and is not intended as an offer or = solicitation for the purchase or sale of any financial instrument or as an = official confirmation of any transaction.
The legal basis for the processing of your personal data is the legitimate = interest to develop a commercial relationship with you, as well as your con= sent to forward you commercial communications. You can exercise, at any tim= e and under the terms established under current regulation, your rights. If= you prefer not to receive any further communications, please contact your = client relationship manager if you are a client of Vontobel Group or notify= the sender. Please note for an exact reference to the affected group entity the corpora= te e-mail signature. For further information about data privacy at Vontobel Group please consult= www.vontobel.com.

--_000_27378bab0c664171a446991b88b5f127vontobelcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Anybody has a script for reproducing O= RA-04036 in 19c? Allocating PL/SQL collections doesn’t trigger the er= ror:

 

S= QL> select max(pga_alloc_mem)/power(1024,2) from v$process ;

MAX(PGA_ALLOC_MEM)/POWER(1024,2)
--------------------------------
6466.71202

SQL> show parameter pga

PARAMETER_NAME TYPE VALUE
------------------------------------------= ------------------ ----------- --------------------------------------------= --------------------------------------------------------
pga_aggregate_limit big integer 2G<= br>

SQL> !dbhome
.../product/19.7.0.0.200414<= span lang=3D"EN-US" style=3D"font-size:10.0pt;font-family:"Arial"= ,sans-serif">

 

I had a nice test case with excessive = PGA allocations during parsing in 12c, but “unfortunately” Orac= le fixed that problem.

 

Best regards,

 

Nenad

 

htt= ps://nenadnoveljic.com/blog/about

 

_______________________________________________= _____

Please consider the environment before printing= this e-mail.

Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.<= span style=3D"color:green">


Important Notice

This message is intended only for the individual named. It may contain conf= idential or privileged information. If you are not the named addressee you = should in particular not disseminate, distribute, modify or copy this e-mai= l. Please notify the sender immediately by e-mail, if you have received thi= s message by mistake and delete it from your system.
Without prejudice to any contractual agreements between you and us which sh= all prevail in any case, we take it as your authorization to correspond wit= h you by e-mail if you send us messages by e-mail. However, we reserve the = right not to execute orders and instructions transmitted by e-mail at any t= ime and without further explanation.
E-mail transmission may not be secure or error-free as information could be= intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also p= rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob= el Holding Ltd. and any of its affiliates (hereinafter collectively referre= d to as "Vontobel Group") for any damages resulting from e-mail use is excl= uded. You are advised that urgent and time sensitive messages should not be= sent by e-mail and if verification is required please request a printed ve= rsion.
Please note that all e-mail communications to and from the Vontobel Group a= re subject to electronic storage and review by Vontobel Group. Unless state= d to the contrary and without prejudice to any contractual agreements betwe= en you and Vontobel Group which shall prevail in any case, e-mail-communica= tion is for informational purposes only and is not intended as an offer or = solicitation for the purchase or sale of any financial instrument or as an = official confirmation of any transaction.
The legal basis for the processing of your personal data is the legitimate = interest to develop a commercial relationship with you, as well as your con= sent to forward you commercial communications. You can exercise, at any tim= e and under the terms established under current regulation, your rights. If= you prefer not to receive any further communications, please contact your = client relationship manager if you are a client of Vontobel Group or notify= the sender. Please note for an exact reference to the affected group entity the corpora= te e-mail signature. For further information about data privacy at Vontobel Group please consult= www.vontobel.com.

--_000_27378bab0c664171a446991b88b5f127vontobelcom_-- -- http://www.freelists.org/webpage/oracle-l