On 9/14/05, Michael McMullen <ganstadba@xxxxxxxxxxx> wrote: > > Well, I did ask for platform. And a 40Gb database on windows 2000 SE, how > many people have those? SQL> select sum(bytes)/1024/1024/1204 SizeGB 2 from dba_data_files; SIZEGB ---------- 48.75 1 row selected. SQL> show sga Total System Global Area 1496394596 bytes Fixed Size 457572 bytes Variable Size 494927872 bytes Database Buffers 998244352 bytes Redo Buffers 2764800 bytes running on windows SE. Admittedly the buffer cache is rather larger than 250mb -- > Niall Litchfield > Oracle DBA > http://www.niall.litchfield.dial.pipex.com