Sunday, December 23, 2007

Log_buffer has no effect from 10g

I installed ORACLE SPOTLIGHT for RAC and found LOG_BUFFER was shown to occupy unusually large value, then I investigated and found fixed sga and log buffer are given a one granule size(4m) irrespective of log_buffer value.

SQL> select * from v$sgainfo;

NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 1290952 No
Redo Buffers 2899968 No
Buffer Cache Size 243269632 Yes
Shared Pool Size 163577856 Yes
Large Pool Size 4194304 Yes
Java Pool Size 4194304 Yes
Streams Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 419430400 No
Startup overhead in Shared Pool 37748736 No
Free SGA Memory Available 0

11 rows selected.

SQL> select (1290952+ 2899968) /1024 from dual;

(1290952+2899968)/1024
----------------------
4092.69531

23 comments:

Anonymous said...

I seldom leave comments on blog, but I have been to this post which was recommended by my friend, lots of valuable details, thanks again.

Anonymous said...

A guide Wіѕh this will Learn yοu footstеp-by-footstep instruсtions on hoω to
maκе lots gаmeѕ foг рrеѕchoοlers,
and thе undeгmentiοnеԁ Online Gаmes are sοme of thе verу Topper.
Wіll it Unlοosе Online Gаmes aгe bossy and Holԁ taκen Tеаr
oѵer thе traditional οut-of-door gаmes.
It was estimated in 2009 thаt by run-of-the-mill ѵοсalism аctors whо Prеsеnt thеir sicklу written lines ωithout a line of eхubеranсe or urgency.
The Fіshеr-Pгice webѕite hаs a ωhοlе gaming sites lаtеly, you maу
Receive reаlizеd the on thе faсe of
it huge ροpulаritу оf penguins іn οnlіne gamеѕ.



Му web-site; http://Mysocialadplace.com/

Anonymous said...

Βut those who Lead the uses of Using the in gamе
cuгrentness knoωn аs рearlѕ,
which Put down from merely аpproximately any сritter yоur Wοгk paгty will run іntо.



Also visit my webpage: seeold.com

Anonymous said...

Oh my goodness! Awesome article dude! Many thanks, However I am experiencing difficulties with
your RSS. I don't understand the reason why I cannot join it. Is there anybody else having similar RSS issues? Anybody who knows the answer can you kindly respond? Thanx!!

Here is my web-site DouglasSc

Anonymous said...

I wanted to thank you for this great read!! I absolutely enjoyed every bit of it.
I have got you book marked to look at new things you post…

Here is my homepage ... Saffron X Supplement

Anonymous said...

Wonderful website. A lot of helpful information here. I am sending it to several pals ans also sharing in delicious.
And of course, thanks in your sweat!

Stop by my blog ... http://trimextrindiet.com

Anonymous said...

Greetings! Very helpful advice within this post! It is the little changes that produce the largest changes.
Thanks a lot for sharing!

Stop by my web-site: Trimextrin

Anonymous said...

Helpful info. Fortunate me I discovered your website unintentionally, and I'm shocked why this accident did not happened earlier! I bookmarked it.

Review my site: Diet Plan

Anonymous said...

I was able to find good info from your blog articles.

My blog: http://trimextrindiet.com

Anonymous said...

hello there and thank you for your info – I've certainly picked up something new from right here. I did however expertise several technical points using this website, as I experienced to reload the site lots of times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will sometimes affect your placement in google and can damage your quality score if ads and marketing with Adwords. Anyway I'm
adding this RSS to my e-mail and could look out for much more of your respective exciting content.
Make sure you update this again soon.

Check out my web blog :: Xength X1 Male Enhancement

Anonymous said...

If some one wishes to be updated with most up-to-date technologies afterward he must be pay a quick visit this site
and be up to date every day.

Feel free to surf to my web page Muscle Core X

Anonymous said...

Right now it looks like Movable Type is the preferred blogging platform out there right now.
(from what I've read) Is that what you're using on your blog?


Look at my webpage: Natural Cleanse

Anonymous said...

I'm extremely inspired with your writing skills and also with the structure for your weblog. Is that this a paid subject or did you modify it your self? Either way keep up the nice quality writing, it is rare to see a nice weblog like this one today..

123 income academy

Anonymous said...

Somebody essentially help to make seriously articles I'd state. That is the very first time I frequented your website page and so far? I amazed with the research you made to make this actual post amazing. Wonderful process!

Also visit my blog; Pur Essence Anti Aging

Anonymous said...

I do accept as true with all of the ideas you have offered in your post.
They are really convincing and can definitely work.
Still, the posts are too short for novices. Could you please prolong
them a little from subsequent time? Thanks for the post.


Look into my page :: garcinia cambogia for weight loss []

Anonymous said...

Touche. Great arguments. Keep up the good work.


Stop by my homepage :: Lift and Glow Pro And Lift Serum Pro

Anonymous said...

Thank you for another informative web site. Where else may I get that type of
information written in such an ideal means? I have a mission that I
am simply now running on, and I have been on the look out for such information.


Here is my blog post: male enhancement pictures

Anonymous said...

Howdy! Quick question that's entirely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when browsing from my iphone 4. I'm trying to
find a template or plugin that might be able to resolve this problem.
If you have any suggestions, please share.
Many thanks!

wrinkle cream

Xia Zhang said...

http://www.shopbestgoods.com/
http://www.bestcustomsonline.com/
http://www.nike-jordanshoes.com/
http://www.polo-tshirts.com/
http://www.burberry-factory.com/
http://www.kate-spades.com/
http://www.barbour-factory.com/
http://www.coachlosangeles.com/
http://www.official-coachoutlet.com/
http://www.louisvuittonas.com/
http://www.burberryoutlet2014.com/
http://www.official-mkoutlet.com/
http://www.official-pradaoutlet.com/
http://www.beatsbydreoutlet.net/
http://www.michaelkorsonlineusa.com/
http://www.northsclearance.com/
http://www.ralph-laurensale.com/
http://www.gucci-shoesuk2014.com/
http://www.michael-korsusa.com/
http://www.polo-outlets.com/
http://www.hermes-outletonline.com/
http://www.ralphslauren.co.uk/
http://www.marcjacobsonsale.com/
http://www.mcmworldwides.com/
http://www.warmbootssale.com/
http://www.salongchamppairs.com/
http://www.canada-gooser.com/
http://www.michaelkors.so/
http://www.oakley-sunglassoutlet.com/
http://www.north-faceoutlets.net/
http://www.moncler-clearance.com/
http://www.woolrich-clearance.com/
http://www.barbour-jacketsoutlet.com/
http://www.moncler-jacketsoutletonline.com/
http://www.monsterbeatsbydres.net/
http://www.lv-guccishoesfactory.com/
http://www.cheapdiscountoutlet.com/
http://www.coachsfactoryoutlet.com/
http://www.coach-blackfriday2014.com/
http://www.coach-storeoutletonline.com/
http://www.coach-factorysoutletonline.com/
http://www.coachccoachoutlet.com/
http://www.coach-factories.net/
http://www.coach-pursesoutletonline.com/
http://www.coach-outletsusa.com/
http://www.zxcoachoutlet.com/
http://www.mischristmas.com/
http://www.misblackfriday.com/
http://www.newoutletonlinemall.com/
http://www.ralphlaurenepolo.com/
http://michaelkorsoutlet.mischristmas.com/
http://mcmbackpack.mischristmas.com/
http://monsterbeats.mischristmas.com/
http://northfaceoutlet.mischristmas.com/
http://mk.misblackfriday.com/
http://coachoutlet.misblackfriday.com/
http://coachfactory.misblackfriday.com/
http://uggaustralia.misblackfriday.com/
http://coachpurses.misblackfriday.com/
http://coachusa.misblackfriday.com/
http://coach.misblackfriday.com/
http://michaelkorss.misblackfriday.com/
http://michaelkors.misblackfriday.com/
http://airmax.misblackfriday.com/
http://michael-kors.misblackfriday.com/
https://twitter.com/CoachOutlet2014
https://www.facebook.com/coachoutletstoreonline
https://www.facebook.com/ralphlaurenoutletonline

oakleyses said...

tory burch outlet, polo ralph lauren, ugg boots, chanel handbags, tiffany jewelry, longchamp outlet, longchamp pas cher, gucci handbags, sac longchamp pas cher, uggs on sale, jordan pas cher, michael kors pas cher, ray ban sunglasses, oakley sunglasses, polo outlet, louboutin pas cher, longchamp outlet, burberry pas cher, louis vuitton, cheap oakley sunglasses, replica watches, replica watches, longchamp outlet, christian louboutin outlet, prada handbags, oakley sunglasses wholesale, louis vuitton outlet, oakley sunglasses, ray ban sunglasses, louis vuitton, prada outlet, nike outlet, louis vuitton outlet, christian louboutin, nike free run, nike roshe, ugg boots, nike air max, polo ralph lauren outlet online, kate spade outlet, christian louboutin uk, tiffany and co, nike free, oakley sunglasses, jordan shoes, louis vuitton outlet, nike air max, ray ban sunglasses

oakleyses said...

nike tn, ralph lauren uk, true religion outlet, nike air max uk, burberry handbags, michael kors, abercrombie and fitch uk, nike blazer pas cher, oakley pas cher, timberland pas cher, hogan outlet, uggs outlet, michael kors outlet online, replica handbags, sac vanessa bruno, true religion outlet, converse pas cher, guess pas cher, ray ban pas cher, ray ban uk, true religion outlet, michael kors outlet, mulberry uk, nike roshe run uk, hollister uk, coach outlet, kate spade, nike air max, new balance, true religion jeans, north face, coach outlet store online, uggs outlet, michael kors outlet online, polo lacoste, michael kors outlet, lululemon canada, nike air force, vans pas cher, michael kors outlet, hollister pas cher, michael kors outlet online, sac hermes, michael kors, burberry outlet, michael kors outlet online, north face uk, nike air max uk

oakleyses said...

converse, louboutin, soccer jerseys, ferragamo shoes, hermes belt, longchamp uk, p90x workout, north face outlet, baseball bats, instyler, nike trainers uk, babyliss, mont blanc pens, soccer shoes, nfl jerseys, valentino shoes, oakley, hollister clothing, abercrombie and fitch, chi flat iron, ralph lauren, nike air max, north face outlet, gucci, ray ban, vans, beats by dre, herve leger, jimmy choo outlet, giuseppe zanotti outlet, mac cosmetics, ghd hair, reebok outlet, nike roshe run, hollister, mcm handbags, timberland boots, nike air max, lululemon, bottega veneta, insanity workout, nike huaraches, vans outlet, hollister, iphone cases, wedding dresses, new balance shoes, converse outlet, asics running shoes, celine handbags

oakleyses said...

marc jacobs, ugg,uggs,uggs canada, louis vuitton, swarovski, barbour uk, montre pas cher, moncler outlet, louis vuitton, canada goose outlet, louis vuitton, pandora charms, wedding dresses, juicy couture outlet, moncler, canada goose outlet, louis vuitton, canada goose uk, ugg uk, canada goose, ugg pas cher, coach outlet, hollister, moncler, canada goose outlet, ugg, pandora jewelry, moncler outlet, karen millen uk, pandora jewelry, links of london, louis vuitton, canada goose, canada goose, swarovski crystal, moncler uk, moncler, moncler, doudoune moncler, juicy couture outlet, canada goose jackets, thomas sabo, replica watches, ugg,ugg australia,ugg italia, barbour, pandora uk, supra shoes, lancel, toms shoes