Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-04031 error appears in the solution 11.2.0.4 run utlrp.sql     - Java multi-threaded communications pipeline flow (Programming)

- Redis data types Introduction (Database)

- Linux Routine Task Scheduler (Linux)

- To remove those IP is prohibited Fail2ban on CentOS 6/7 (Server)

- Good wireless network security information spread in the air (Linux)

- Ubuntu is expected to allow you to install the latest Nvidia Linux drivers easier (Linux)

- Installation image conversion tool on your Ubuntu Converseen 0.8.1 (Linux)

- Will Laravel become the most successful PHP framework? (Programming)

- Installation GitLab appears ruby_block supervise_redis_sleep action run (Linux)

- BGP routers want to play it by CentOS (Linux)

- Spark build standalone version cluster (Server)

- Ten to improve the efficiency of the Linux bash tricks (Linux)

- GitLab Installation Guide -Ubuntu 14.04 LTS (Server)

- How to manage Vim plugin (Linux)

- Error: Unable to establish connection with FTP SFTP server (Server)

- CentOS 6.x systems installation + NIC driver installation (Realtek PCIe GBE Family Controller for Linux) (Linux)

- PHP file upload methods exist in the database (Programming)

- About Auto Layout and frame (Programming)

- Oracle how to maintain the consistency of read? (Database)

- Extended use of the swap file swap space on Linux (Linux)

 
         
  ORA-04031 error appears in the solution 11.2.0.4 run utlrp.sql
     
  Add Date : 2018-11-21      
         
         
         
  Last encounter a case:

At the customer site when running version 11.2.0.4 utlrp.sql compile the script, the following error:
ORA-12801: error signaled in parallel query server P237
ORA-12853: insufficient memory for PX buffers: current 84352K, max needed 13280400K
ORA-04031: unable to allocate 65560 bytes of shared memory ( "large pool", "unknown object", "large pool", "PX msg pool")
ORA-06512: at "SYS.UTL_RECOMP", line 804
ORA-06512: at line 4

Because:

Cause
 The degree of parallelism used for recompilation is determined automatically based on instance parameters cpu_count and parallel_threads_per_cpu.
 On systems with high number of cpus that can lead to high degree of parallelism and lead to high memory usage overall and high memory usage in the large pool since it is used by parallel execution for message buffers.

By default utlrp.sql passes a 0 to utlprp.sql:

From the above explanation we can rely on cpu_count know the value and parallel_threads_per_cpu if more cpu, this will be a high degree of parallelism, resulting in large pool uses more memory

So to solve this problem is simple

Reduce the degree of parallelism value instance

alter system set PARALLEL_MAX_SERVERS = 5 scope = both;
alter system set PARALLEL_SERVERS_TARGET = 2 scope = both;

Compile successfully.
     
         
         
         
  More:      
 
- Talk about Java EE Learning (Programming)
- Linux character device - user mode and kernel mode data transfer data (Linux)
- Detailed Linux platform chip programming process (Programming)
- Oracle 10g relations with the constraint of column properties NULLABLE (Database)
- CentOS6.3 build a Python 3.3 environment to access Oracle 11gR2 (Database)
- Linux system man help tips (Linux)
- Linux loopback adapter Driven Design (Programming)
- Django how to generate content in non-HTML formats (Programming)
- Linux command -nohup & (Linux)
- Android memory optimization of the memory cache (Linux)
- LNMP Note: Addressing mail function can not send mail (Server)
- Oracle Database Restore (Database)
- Hadoop 2.6.0 stand-alone / pseudo-distributed installation (Server)
- How to install Linux Go Language (Linux)
- Linux NIC driver and version information (Linux)
- ORA-12154: TNS: could not resolve the connect identifier specified solve (Database)
- CentOS6.6 ordinary users to use sudo command to borrow root user privileges (Linux)
- Analyzing Linux server architecture is 32-bit / 64-bit (Server)
- Analysis of MySQL High Availability (Database)
- Linux CentOS configuration SVN + SVN hook (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.