2条sql INSERT INTO TICKET_RETURNRECORD_LOG。。。为何用这么大的PGA
SQL> select PROGRAM,PGA_USED_MEM/1024/1024/1024,PID,SPID,SERIAL# from v$process ORDER BY PGA_USED_MEM DESC;
PROGRAM PGA_USED_MEM/1024/1024/1024 PID SPID SERIAL#
---------------------------------------------------------------- --------------------------- ---------- ------------ ----------
ORACLE.EXE (SHAD) 4.00815272796899 60 8076 163
ORACLE.EXE (SHAD) 2.92796877492219 80 7208 5
ORACLE.EXE (SHAD) 0.00809733290225267 86 3120 6
ORACLE.EXE (SHAD) 0.00719132740050554 96 8048 4
ORACLE.EXE (SHAD) 0.00708841998130083 84 8080 7
ORACLE.EXE (SHAD) 0.0050244377925992 40 8528 190
ORACLE.EXE (SHAD) 0.0046797813847661 76 5144 15
ORACLE.EXE (SHAD) 0.00438929814845324 32 7032 186
ORACLE.EXE (LGWR) 0.00427673477679491 12 7372 1
ORACLE.EXE (SHAD) 0.00367977935820818 52 2612 13
ORACLE.EXE (SHAD) 0.00307064969092607 46 7576 56
ORACLE.EXE (SHAD) 0.00173879135400057 42 5936 148
ORACLE.EXE (MMON) 0.00150891859084368 22 5604 1
ORACLE.EXE (SHAD) 0.00147002656012774 38 464 174
ORACLE.EXE (SHAD) 0.00109616387635469 54 6848 58
ORACLE.EXE (SHAD) 0.00109403301030397 34 1652 129
ORACLE.EXE (D000) 0.00091912318021059 26 7452 1
ORACLE.EXE (SHAD) 0.000795972533524036 56 5764 120
ORACLE.EXE (CJQ0) 0.000769858248531818 20 7000 1
ORACLE.EXE (SHAD) 0.000668560154736042 66 8268 52
PROGRAM PGA_USED_MEM/1024/1024/1024 PID SPID SERIAL#
---------------------------------------------------------------- --------------------------- ---------- ------------ ----------
ORACLE.EXE (SMON) 0.00055126566439867 16 988 1
ORACLE.EXE (RECO) 0.000531305558979511 18 2812 1
ORACLE.EXE (DBW1) 0.000496973283588886 10 7928 1
ORACLE.EXE (SHAD) 0.000426215119659901 36 4572 35
ORACLE.EXE (CKPT) 0.000423622317612171 14 4504 1
ORACLE.EXE (SHAD) 0.000421901233494282 44 5756 95
ORACLE.EXE (DBW0) 0.000404653139412403 8 8160 1
ORACLE.EXE (SHAD) 0.000358176417648792 48 8008 169
ORACLE.EXE (MMNL) 0.00034149456769228 24 5616 1
ORACLE.EXE (MMAN) 0.000334289856255054 6 720 1
ORACLE.EXE (PMON) 0.00033301580697298 2 1580 1
ORACLE.EXE (PSP0) 0.000332054682075977 4 4748 1
ORACLE.EXE (S000) 0.00024773646146059 28 4524 1
ORACLE.EXE (J000) 0.000142849981784821 30 5188 3
PSEUDO 0 1 0
SQL> select b.SID,
2 b.SERIAL#,
3 p.SPID,
4 c.sql_id,
5 c.hash_value,
6 c.sql_text,
7 b.STATUS
8 from gv$session_wait a, gv$session b, gv$sqlarea c, gv$process p
9 where a.sid = b.sid
10 and p.addr = b.paddr
11 and b.sql_hash_value = c.hash_value
12 and b.username is not null
13 and b.status = 'ACTIVE'
14 -- and (b.program like '%PlSql%' or b.program like '%plsql%')
15 --and c.sql_id=''
16 AND p.SPID IN ('8076' ,'7208')
17 order by c.sql_id desc;
SID SERIAL# SPID SQL_ID HASH_VALUE SQL_TEXT STATUS
---------- ---------- ------------ ------------- ---------- -------------------------------------------------------------------------------- --------
48 55004 7208 18fmbmv4dtnub 3369915211 INSERT INTO TICKET_RETURNRECORD_LOG (LOG_ID, LOGDT, ACTION, USER_HOST, USER_IP, ACTIVE
45 49717 8076 18fmbmv4dtnub 3369915211 INSERT INTO TICKET_RETURNRECORD_LOG (LOG_ID, LOGDT, ACTION, USER_HOST, USER_IP, ACTIVE
SQL>