ORA-04030, ora0403032-bit
-- Error: 20 m unavailable
Dump continued from file:/u01/app/oracle/diag/rdbms/szaa/szaa2/trace/szaa2_dw01_122659.trc
ORA-04030: out of process memory when trying to allocate 24520 bytes (koh-kghu sessi, kpmalloc)
-- 4 GB memory is used for export operations
Pid 112: 1860 KB used of 2229 KB allocated
Pid 113: 4102 MB used of 4105 MB allocated -------- view key points...
------------------------------------
Begin session detail for pid 113
Sid: 1625 ser: 56665 audsid: 0 user: 0/SYS
Flags: (0x8000051) USR/-flags_idl: (0x1) BSY /-/-/-/-/-
Flags2: (0xc0409)-/INC
Pid: 113 IO/S info: user: oracle, term: UNKNOWN, ospid: 122659
Image: oracle@szaadb02.shenzhenair.com (DW01)
Current SQL:
BEGIN
SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_FULL_02 ', 'backup', 0 );
END;
End session detail for pid 113
------------------------------------
Pid 114: 2200 KB used of 3557 KB allocated (1024 KB freeable)
-- Total memory allocation...
(Percentage is of 5140 MB total allocated memory)
80% pid 113: 4102 MB used of 4105 MB allocated <= current proc ------------- export process... 80% of Pga
3% pid 106: 37 MB used of 168 MB allocated (129 MB freeable)
2% pid 36: 73 MB used of 78 MB allocated
2% pid 37: 73 MB used of 78 MB allocated
2% pid 40: 73 MB used of 78 MB allocated
1% pid 91: 55 MB used of 56 MB allocated (704 KB freeable)
1% pid 38: 34 MB used of 36 MB allocated
1% pid 21: 13 MB used of 27 MB allocated (10 MB freeable)
1% pid 20: 13 MB used of 27 MB allocated (10 MB freeable)
0% pid 19: 13 MB used of 25 MB allocated (8256 KB freeable)
-- The total memory should be this... implicit parameter control...
18:10:09 sys @ szaa2 (szaadb02.shenzhenair.com)> show parameter pga
NAME TYPE VALUE
------------------------------------------------------------------------------------------------
Pga_aggregate_target big integer 5G
18:10:12 sys @ szaa2 (szaadb02.shenzhenair.com)>
Begin End
Host Mem (MB): 96,531.496, 531.4
SGA use (MB): 20,480.020, 480.0
PGA use (MB): 5, 075.9828.4 ---------------- the export process ends and the process rapidly decreases.
% Host Mem used for SGA + PGA: 26.4722.07
Normally exported memory usage
Host Mem (MB): 96,531.496, 531.4
SGA use (MB): 20,480.020, 480.0
PGA use (MB): 1,413.91, 179.1%
Host Mem used for SGA + PGA: 22.6822.44
-- The total memory should be this... implicit parameter control...
[Oracle @ szaa2/home/oracle/shsnc] $ ora _ param | grep pga
_ Pga_aggregate_target 5368709120 n I N Current target size for the aggregate PGA memory consumed
_ Kdli_sio_pga false y n use PGA allocations for direct IO
_ Kdli_sio_pga_top false y n pga allocations come from toplevel PGA heap
_ Ldr_pga_lim 0 y I N pga limit, beyond which new partition loads are delayed
_ Pga_large_extent_size 1048576 y n pga large extent size
_ Pga_max_size 1073725440 y n I N Maximum size of the PGA memory for one process
_ Pgactx_cap_stacks false y I N capture stacks for setting pgactx
_ Simulate_mem_transfer false y n I N simulate auto memory sga/pga transfers
_ Smm_advice_enabled true y n I N if TRUE, enable v $ pga_advice
_ Use_ism_for_pga true y n Use ISM for allocating large extents