LARGE_POOL_SIZE settings

[MCubitt]

My init.ora file has a LARGE_POOL_SIZE set to 1048576 but in OEM it reports it as 16M. Any idea how thi scan be so?!



Applications Support
UK

 

[SantaMufasa]

Martin,

How are you (personally) determining LARGE_POOL_SIZE? Could someone be dynamically changing LARGE_POOL_SIZE? If these questions do not result in an explanation for the differences, then it sounds like a good question for Oracle MetaLink (if you have a Support account).

If you discover an explanation on your own, please advise us.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[MCubitt]

The Large Pool Size from TOAD says 16M.

The init.ora shows:
large_pool_size = 1048576.

My assumption is that the init.ora sets the value and this remains, unless Oracle can "Tune" it?

OEM shows as 16M too, so I would gather this is teh actual value.

You know, I will report it to Metalink just so we all know what's going on!

Thanks


Applications Support
UK

 

[MCubitt]

Having discussed this case with Metalink, it was concluded that the "granule" setting which is determined by SGA size is, in my DB, 16M. Therefore the value for large buffer pool has to be in multiples (or granules) of 16M. This is why I set 10M and it actually becomes 16M.

Thanks


Applications Support
UK

 

[SantaMufasa]

Martin,

I'm still puzzled: you said in your most recent post, "This is why I set 10M and it actually becomes 16M." Is this a new value you used...different from your original value of "1048576"? (Are you reading "1048576" as 10MB? Because it's actually 1MB.)

Also, if there is a discrepancy between your init<SID>.ora value and your run value, it could be because your Oracle is ignoring init<SID>.ora values since you are in reality using an "spfile". Can you confirm that you are not using an "spfile"?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[MCubitt]

Sorry,it was set as 1048576 which is of course 1MB but this rounded up to the nearest "granule" and gave 16M. I since updated it to 10000000 and it still went to 16M.

I am not using spfile and the Metalink guy got me to prove that by running a query or two. We even started the database with pfile = ... and again it was 16M.

So its the fact I can have 0, 16M, 32M, etc. Interesting I tried 32768000 and it came back as 16M, I had to use 33554432.

I can post Metalink's actual explanation if it is of interest?





Applications Support
UK