memory
Please explain which is having 0 value as free in below query.How we can tune memory/sga based on below query:
SPID PROGRAM MAX ALLOC USED FREE
------------ ------------------------------------------------ ---------- ---------- ---------- ----------
PSEUDO 0 0 0 0
17550 oracle@mactlp (PSP0) 462401 462401 314393 0
17548 oracle@mactlp (PMON) 462401 462401 315425 0
17552 oracle@mactlp (MMAN) 462401 462401 319193 0
17558 oracle@mactlp (LGWR) 23250753 23119681 10897369 131072
17554 oracle@mactlp (DBW0) 2149713 838993 400393 0
17562 oracle@mactlp (SMON) 5426081 2280353 580473 851968
17556 oracle@mactlp (DBW1) 709825 709825 402297 0
17566 oracle@mactlp (CJQ0) 6229569 5115457 738145 3538944
17560 oracle@mactlp (CKPT) 2344905 1492937 427001 851968
17568 oracle@mactlp (MMON) 3787609 3001177 1468193 786432
SPID PROGRAM MAX ALLOC USED FREE
------------ ------------------------------------------------ ---------- ---------- ---------- ----------
17564 oracle@mactlp (RECO) 1445441 1117761 545113 65536
17572 oracle@mactlp (D000) 1642049 882481 882481 0
17570 oracle@mactlp (MMNL) 659009 659009 324769 0
17574 oracle@mactlp (S000) 331329 227121 227121 0
17638 oracle@mactlp (ARC1) 22743873 22743873 10863721 0
18032 oracle@mactlp (q000) 2345889 1887137 869929 65536
25921 oracle@mactlp 4722241 2690625 1284737 786432
17636 oracle@mactlp