This content has been marked as final. Show 15 replies
BenK - your question is basically unanswerable.
How do you intend to "cache data in the SGA?"
Alter table CACHE option ???
Are you using AMM, It is the recommend by Oracle.
alter table CACHE doesn't keep the table in the cache, it just changes what happens when the table is full scanned
Enable Keep_pool will help but Just to make sure , Wait confirm from John first if this will work or not
12.5GB is not available completely for caching the data. Its just the buffer cache which can store it for you. I would ask you that what's the test that you have done which has ensured you that the caching would be a good idea for performance?
Aman has it right. WHY?
the keep pool, alter table cache, etc - I would not be doing ANY of these without a good reason.
Often times, people think that forcing a table to stay in the cache is a good idea. It rarely is. If you want things in the cache, use them. If they are used, they will naturally have their blocks cached. If you don't use them, they can get flushed out. But if you don't use them, why do you want them using memory that could better be used by other things?
My advice: don't try to second-guess Oracle's memory management and caching strategy. If you think you have a reason to, post it here and we can help you (or debunk your reason). Based on the fact that you've apparently calculated the SGA using that silly, meaningless "rule" that says give it 40% of your total RAM, I'd guess that you are looking around for a magic bullet, and you don't actually have a problem to solve.
Thank you .
But will it better to enable Keep_pool for Small table that experience full-table scans ?
hai John Stegeman ,
we are creating an online application for our application better performance Top said keep data in cache.
hai Antonio NAVARRO,
we are using AMM, is it (Alter table CACHE option ) right choice for me? what's the amount or size of data can i cache?
Tell "Top" (whoever that is) that Oracle does a fine job of keeping data cached that should be cached.
You don't need to do anything. DO NOT alter table cache. DO NOT use a keep pool.
edit: AMM = Automatic Memory Management
Ours is a Business application for our application performance (ex: recent search results) shouldbe cashed my question is how much GB data out of 12.GB SGA canbe cached?
I AM GOING TO SHOUT BECAUSE YOU ARE NOT LISTENING.
USE AUTOMATIC MEMORY MANAGEMENT. IF YOU DON'T KNOW WHAT THAT IS, READ THE DOCUMENTATION: http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm
ORACLE TAKES CARE OF CACHING THINGS AUTOMATICALLY. YOU DO NOT NEED TO DO ANYTHING.
IF YOU WANT TO CACHE THE ****RESULT**** (HARD TO EMPHASIZE WHEN I AM ALREADY SHOUTING), YOU CAN LOOK INTO THE RESULT SET CACHE WHICH YOU CAN ALSO READ ABOUT IN EITHER THE DOCUMENTATION OR THE MANY POSTS THAT GOOGLE WOULD FIND FOR YOU.
HOPE YOU CAN HEAR, I THINK THE LINE IS BAD OR SOMETHING
LOL :D you just remind me with anger management movie .
I am really SORRY i didn't read your previous post extreemly "SORRY"