Dude, Where's My Database?

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Tue, 18 Jul 2006 07:15:22 -0700 (PDT)
Message-ID: <20060718141522.75061.qmail@web34109.mail.mud.yahoo.com>

Hi All,

My database is configured to use approx. 4Gb of memory:

Connected to:
Oracle9i Release 9.2.0.6.0 - 64bit Production JServer Release 9.2.0.6.0 - Production

SQL> select *
2 from v$sga
3 /

NAME                      VALUE
-------------------- ----------
Fixed Size               748656
Variable Size         805306368
Database Buffers     3355443200
Redo Buffers            1323008

Yet, Linux is saying there's < 1Gb physical memory in use and no swap. Where is my database?

(Apologies for the formating)

top - 16:08:21 up 2:17, 4 users, load average: 0.12, 0.11, 0.04
Tasks: 102 total, 1 running, 101 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.4% us, 0.1% sy, 0.0% ni, 99.3% id, 0.2% wa, 0.0% hi, 0.0% si
Mem: 8169180k total, 906124k used, 7263056k free,

39152k buffers
Swap: 2031608k total, 0k used, 2031608k free, 742984k cached

The database has been up for 2 hours but is very lightly loaded. Linux version is:

Linux 2.6.9-34.0.1.ELsmp #1 SMP Wed May 17 16:59:36 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux

Doesn't Oracle allocate the entire SGA at start-up (or is on a demand basis?) I'd always understood it to be the former, in which case why can't I see it in memory using top?

Thanks for any info

Charlotte

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 18 2006 - 09:15:22 CDT