What internal limit on the PGA per process in DB 11.1 Standard ?
Hi, all.We have Oracle Linux 5.8 x86-64 +latest repository, UEK2. Processor 1x4 Xeon, 32 GB of RAM.
Oracle DB Standard 11.1 + PSU 11.1.0.7.11.
RDBMS used AMM, memory_target = 4G.
Database files are on ASM disk.
Parameters of the RDBMS:
orcl.__db_cache_size=2415919104
orcl.__java_pool_size=33554432
orcl.__large_pool_size=16777216
orcl.__oracle_base='/u01/app/oracle' #ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1073741824
orcl.__sga_target=3221225472
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=704643072
orcl.__streams_pool_size=16777216
*._realfree_heap_pagesize_hint=524288
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='NONE'
*.compatible='11.1.0.0.0'
Oracle DB Standard 11.1 + PSU 11.1.0.7.11.
RDBMS used AMM, memory_target = 4G.
Database files are on ASM disk.
Parameters of the RDBMS:
orcl.__db_cache_size=2415919104
orcl.__java_pool_size=33554432
orcl.__large_pool_size=16777216
orcl.__oracle_base='/u01/app/oracle' #ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1073741824
orcl.__sga_target=3221225472
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=704643072
orcl.__streams_pool_size=16777216
*._realfree_heap_pagesize_hint=524288
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='NONE'
*.compatible='11.1.0.0.0'
0