×

注意!页面内容来自https://www.tek-tips.com/threads/what-does-nocache-do.707798/,本站不储存任何内容,为了更好的阅读体验进行在线解析,若有广告出现,请及时反馈。若您觉得侵犯了您的利益,请通知我们进行删除,然后访问 原网页

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

What does NOCACHE do?

Status
Not open for further replies.

Netherbeast

Programmer
Joined
Jun 42002
Messages
89
Location
US
Im new at this and I dont understand what NOCACHE does. Can anyone provide me with an answer?

thanks in advance
 
The CACHE option specifies that the blocks retrieved for the table are placed at the most recently used end of the LRU list in the buffer cache when a FULL table scan is performed.

The NOCACHE option specifies that the blocks retrieved for the table are placed at the least recently used end of the LRU list in the buffer cache when a FULL table scan is performed. This will cause the blocks read with a full table scan to be immediately flushed from the buffer cache.
 
You would normally CACHE a table when it was VERY smallone or two data buffers but frequently usedlookup tables may fit this. In this scenario you may find that unindexed full table scan from the SGA is faster than an indexso you want the table to stay in the SGA.

For most full table scansyou do NOT want the data keptyou want the current SGA to remain as unchanged as possibleso NOCACHE is the default.

I tried to remain child-likeall I acheived was childish.
 
You may also use this keyword when creating sequences. This means that no values are buffered in memory for future requests.

RegardsDima
 
Thanks for the answers.

Jimboyou mentioned a "look up table." What do you mean by that? Is that a faster way of doing SELECT * from table_name?

Thanks
 
Generally speakinglookup tables are reference tables. They are small in size and are predominently used to do cade lookups. Because they are small in size it's better to cash them.

Hope this helps.


Anand.
 
Many of the Apps I use have a master table with such parameters as: modules I ownthe language my users speakthe next PO number to assign to a POetc. small tables but frequently accessedand often very static. Forcing them to stay in the SGA can speed up routine actions (every form may check the user's language)

You may also have lookup tables that remember Oracle anonoumus Keys

this regular code becomes that overtime code
this temporary Foreman code become that overtime temporary foreman code
(my table like this only has 12 rowsit all fits in one data blockwhen an employee goes over 40 hours I lookup his new pay code)

I tried to remain child-likeall I acheived was childish.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Top