Re: Granule size confusion

On Jun 29, 5:54 pm, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:
On Jun 29, 7:50 am, Steve Robin <ocma...@xxxxxxxxx> wrote:





According to oracle if SGA size is more then 128 MB then Granule size
will be 16 M.

But in my database:

sys ----- OEMREP> show parameter sga_max_size

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
sga_max_size big integer 143728252
sys ----- OEMREP> show sga

Total System Global Area 143728252 bytes
Fixed Size 454268 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
sys ----- OEMREP> select
COMPONENT,CURRENT_SIZE,MAX_SIZE,MIN_SIZE,GRANULE_SIZE from V
$SGA_DYNAMIC_COMPONENTS;

COMPONENT CURRENT_SIZE MAX_SIZE MIN_SIZE GRANULE_SIZE
-------------------- ------------ ---------- ---------- ------------
shared pool 50331648 50331648 50331648 4194304
large pool 8388608 8388608 8388608 4194304
buffer cache 33554432 33554432 33554432 4194304

Oracle Version : 9.2.0.8
Platform : Windows XP
Please let me know why..... ?

Windows. Please read the documentation on granule size again and
you'll discover that Windows does not follow the 'guidelines' posted
for Unix systems. The granule size for Windows platforms is 4 meg up
until the SGA reaches 1 gigabyte or greater in size, at which time it
becomes 8 meg. This is clearly stated here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create...

Please read it again.

David Fitzjarrell- Hide quoted text -

- Show quoted text -

Thanks for this link.
And I really apologies for this question as I could find it in
documents also. But thanks a lot for this link.

.

Relevant Pages

  • Re: Hats off to long-time Mac OS developers...
    ... documentation for Windows and the API itself diverged so often that ... Really, for any given platform, the worst experiences I had came from ... Apple, in 1989, decided to treat its developers as a revenue source. ... Drove large numbers of developers away just as Windows was becoming a ...
    (comp.sys.mac.programmer.misc)
  • Knowledge Management on the Windows Platform
    ... Is there a unified strategy of information management on the Windows ... shortcuts are examples of how the platform is expecting knowledge management ... In that documentation would be explained the utility value, ...
    (microsoft.public.windowsxp.general)
  • Re: moodss and putty problem
    ... I realize I should improve the documentation for windows, ... not my platform of choice ... Jean-Luc ...
    (comp.lang.tcl)
  • Re: Granule size confusion
    ... Oracle Version: 9.2.0.8 ... Platform: Windows XP ... The granule size for Windows platforms is 4 meg up ...
    (comp.databases.oracle.server)
  • Re: Exception setting SocketOption
    ... ups, I crosspost again ... ... > 2) According to Windows CE.NET OS documentation the platform itself does ...
    (microsoft.public.dotnet.framework.compactframework)