Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Who took my memory away?
joebayeriI_at_hotmail.com wrote:
> I have a linux box,
>
> Linux 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 i686 i386
> GNU/Linux
>
> I just installed Oracle 10g.0.2 on it, and I have two instances on it.
> It is empty database, w/o releasing to public usage yet.
> SQL> show parameter sga
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> lock_sga boolean FALSE
> pre_page_sga boolean FALSE
> sga_max_size big integer 776M
> sga_target big integer 300M
> SQL>
>
> So for 2 instance, I should only use 1.6G.
> But,
>
> top - 16:04:55 up 9 days, 23:27, 3 users, load average: 0.00, 0.00,
> 0.00
> Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
> Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi,
> 0.0% si
> Mem: 16629416k total, 14481520k used, 2147896k free, 214612k
> buffers
> Swap: 8388576k total, 4k used, 8388572k free, 13794444k cached
>
> I have 16G of memory, but 14G were used. How are using it?
>
> Your help is highly appreciated.
Opps, I should use
SQL> show sga
Total System Global Area 813694976 bytes
Fixed Size 1264380 bytes Variable Size 213910788 bytes Database Buffers 591396864 bytes Redo Buffers 7122944 bytesReceived on Fri Dec 15 2006 - 15:21:09 CST