春暖花开 | 关于db_keep_cache_size, alter table t storage(buffer

«	一月 2012	»
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31

===========================================================

关于db_keep_cache_size, alter table t storage(buffer_pool keep)

===========================================================

作者: tolywang(http://tolywang.itpub.net)
发表于:2008.07.09 15:35
分类: Oracle10g RAC
出处：http://tolywang.itpub.net/post/48/466137
---------------------------------------------------------------

如果小的table需要经常进行全表扫描，那么可以将它放在Keep池中。具体的方法是：

alter table table_name storage(buffer_pool keep) ;

不过在数据库重新启动后，要重新执行一次alter table t storage(buffer_pool keep)，表t才会cache到db_keep_cache_size 。可以做触发器来避免每次重启时的人为操作。

tolywang 发表于:2008.07.09 15:35 ::分类: ( Oracle10g RAC ) ::阅读:(154447次) :: 评论 (48) :: 引用 (0)

re: 关于db_keep_cache_size, alter table t storage(buffer_pool keep) [回复]

数据库重启后 , 表的buffer_pool 依然为 keep.

tsinglee 评论于：2008.07.10 10:08

re: 关于db_keep_cache_size, alter table t storage(buffer_pool keep) [回复]

重新启动后，不需要重新设置，表在第一次访问后就会放在keep池里了。

yzsind 评论于：2008.09.09 09:28

Test, just a test [回复]

Hello. And Bye. :)

kookimebux 评论于：2009.02.02 02:38

[回复]

ysyisvfrbck hooys uokrc [url=][/url] uokrc pwtik

Zooiaykk 评论于：2009.03.12 07:32

[回复]

nvoyeuakllm drite yqjxp [url=][/url] yqjxp sfeil

Adminowqx 评论于：2009.03.12 07:32

Potenzpillen Viagra, Cialis, Levitra ohne Rezept [回复]

Man sprixht vno eiuner erektilen Dysufnktion (AbkkuerzungE,D auch rEektionsstoerung, Potsnzstoerung, im Volksmund auchh Impotnez), wenn es eniem Mann uerber einen gewiqssen Zeitraum inhweg in deer Mhdrzahlder Verssuche nicht gelingt, eine fuer ein befriedigwndes Sexualleben ausreihecnde Erektfiom des Pneos zu ezrielen oder beizubehalten. Kurzrristige Erektiostsoerungen getne hingegen nicht als ED.
[url=lovegra.pillspharm.info/sitemap.xml]Lovegra Potenzpillen Viagra, Cialis, Levitra frei[/url].
[url=jelly.pillspharm.info/sitemap.xml]Potenzmittel kamagra potenzmittel jelly Versandkostenfrei[/url].
Vile Betroffene gehn asu falscher cham zunaechst nicht zum Andrklogen. Oft baer is eune rasche - beei Verlpetzungen sofortige - Untersuchuhg eforrderlich, um Langzeitscjaeden zzu vermeidenn und dei Faheigkiet zur Erektion eroflgeeicn wieedrhrestellen zu koennne.
[url=viagra.pillspharm.info/sitemap.xml]potenz viagra shop buy viagra viagra bestellen[/url].
[url=kamagra.pillspharm.info/sitemap.xml]kamagra 100 kamagra oraljelly kamagra oral[/url].
Organsjche Ursachen fuer die errektile Dysfuinktion sind oftmals RaFuchrn, Alkoholknosum, Zuuxkerkrankheit, Bluthochdruxk, Opeartioenn, Verletzungen am Schwellkoerper. Daegi kommt es oft zu Schaedigungen von Blutgefaessesn odser Schwellkoerpern.
[url=kautabletten.pillspharm.info/sitemap.xml]Potenzmittel Viagra, Cialis, Levitra ohne Rezept[/url].
[url=cialis.pillspharm.info/sitemap.xml]Cialis Potenzpillen Lovegra, Kamagra, Cialis keine Versandkosten Cialis[/url].
[url=levitra.pillspharm.info/sitemap.xml]Levitra Potenzmittel Levitra Lovegra, Kamagra, Levitra Levitra frei Levitra[/url]
Derzeit zugrlassen und in wsiwenschaftlichen Studien utnersucht sind die rewzeptpflichtgien PDE-5-Hemmer Sildejafiol, Vardenail und Tadaqalfil. PE5-eHmmstoffe wifken nicth bei kompletter Schaexiguungt der feur die Erektioj zusteandigeen Nerven. Apomorhin und Yohiimbinj werden kum nooch verordnet.

BachCoott 评论于：2009.04.16 16:38

viagra oder cialis besser viagra kaufen billig [回复]

Sildenafil ist der Freinme eines Arzneistoffes, der 19988 von er US-amerikanischen Firma Pfizxer unter dem Namem Viagra

Fraupspar 评论于：2009.06.01 08:44

义爨 [回复]

殃篦噱

CewErowiveBow 评论于：2009.06.08 14:06

翌镨 [回复]

腕忸

holleaway 评论于：2009.06.10 01:09

Give me good music please [回复]

I want to listen good music. Help me please.

Gundeflan 评论于：2009.06.11 06:24

阵溴屐忪羼蝈! [回复]

襄蝈疳箴骜赅

blookylow 评论于：2009.06.18 15:36

震铐桕 [回复]

橡铖眢豚顸

Aribiamcototo 评论于：2009.06.21 07:54

殃噻赅 [回复]

橡铖眢豚顸

Proolimbixmit 评论于：2009.06.21 15:58

Who knows where to download XRumer 5.0 Palladium? [回复]

Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!

CocoChanels 评论于：2009.06.27 09:55

Help to listen music now [回复]

I want to listen good music!

piskodrocho 评论于：2009.07.10 01:46

橡铄牝 IntVideo [回复]

鸯铗痂蝈疱觌囔睇

unreareunfosy 评论于：2009.07.15 04:44

朽耨赅磬纛痼禧 [回复]

橡邃豚汔

allin 评论于：2009.07.15 11:02

personal loan company [回复]

unsecured personal loans bad credit private personal loan personal bank loan personal loans uk

moorrywemertuop 评论于：2009.07.16 04:25

tolywang.itpub.net available? [回复]

someone?

Invoilt 评论于：2009.07.18 20:04

Free Bad Credit Installment Personal Loans [回复]

Unsecured Bad Credit Personal Loan
Free Canadian Credit Reports

inceniafoexqwabiop 评论于：2009.07.24 16:36

[回复]

湾箐桠

incopspresiff 评论于：2009.08.14 06:46

觇眍潆 [回复]

疹黧镳邃腩骅螯锣

Hanguafequelf 评论于：2009.08.26 10:20

茵桁戾 [回复]

青汶

trimmer[POJTTPQQPTTP] 评论于：2009.08.27 00:54

翳朦禧镳 [回复]

囹

goramongeTymn 评论于：2009.08.27 15:28

buy Dilaudid, buy Oxycontin, buy Rohypnol [回复]

Buy Oxycontin, buy Rohypnol, buy Dilaudid, buy TOQUILONE, buy GHB without prescription : drkevin@mail.ru
Plus many sorts of other pain meds!

drkevinonline 评论于：2009.09.01 17:54

棋祺筱 [回复]

橡桡豚屐锣

zhemchug_[UIDIYUIFFIIU] 评论于：2009.09.04 19:30

Mitigate needed (notification) [回复]

had recently herpes virus found in my blood. what I haveto do??? I'm in panic...

margohelp 评论于：2009.09.11 06:24

娩 [回复]

卿疣怦蜮箝蝈.

malvinka 评论于：2009.09.11 06:40

Introduction [回复]

Hi, my name is Shanti Sherna from Ukraina. I'm 27 y.
I just love to read this forum articles & topics discussed here.

regards
Shanti,

DrEurope 评论于：2009.09.29 13:17

琼嚓铎耱忸 [回复]

[quote]彦犟冷彘耜珥嚓铎耱忄
软蜩

Higngomssoolf 评论于：2009.10.21 02:25

锑汔玷 [回复]

橡桡豚屐锣

kupit_zhemchug[UIDIYUIFFIIU] 评论于：2009.10.23 22:59

锣 疱觌囔 [回复]

-腻豚

blokreklss 评论于：2009.11.03 05:28

on the floor sex videos [回复]

free hardcore video sex passwords tamil actress hidden sexy video free first teen sex videos free amateur naked wives free porn movies at shilq ebony porn stripper movies free homemade sex videos allure amateur babe free hardcore pornography videos free sex video viewing free simpsons porn movies porn amateur share free videos extreme xxx free sex videos online preview free immogen thomas sex video

chottammofe 评论于：2009.11.28 00:08

at the Maryland State Fairgrounds in Timonium, several [回复]

purchase cheap Ashwafera for Immunization and Respiratory Diseases, order online 36 Beauty should be reported purchase Verapamil of the Senate Foreign Relations Committee, purchase cheap Imitrex include healthy adults ages no prescription Depakote the potential benefits and risks. purchase cheap Zantac Thompson said. generic Reglan his cabinet on how to proceed in the region, buy Protonix in patients order cheap Prilosec or do a little of each?" online Prevacid "be led (by) and following Fox." pharmacy online Pepcid information about pharmacy online Nexium vulnerable to severe order Imodium ever deeper into private industry

nuptMeretop 评论于：2009.12.12 16:55

where can i find... [回复]

well hey there guys, i've been looking all over the internet for a GOOD black hat SEO forum.. I was looking for some suggestions
from you guys to point me in the right direction.

Thanks a bunch, this place is great btw.

eixaldaSnowxie 评论于：2010.02.05 18:57

is a party guy [回复]

and change their futures

appaltshism 评论于：2010.02.20 06:08

Your Bathroom Will Be Comfortable [回复]

Hi everyone!
We offer the internet's largest catalog http://www.listvanities.com/vanities-for-bathrooms.html
50% Off Select Vanities.

LewisDR 评论于：2010.05.15 02:51

暑祗-蝾镳桡钿栩 [回复]

蝈蹴桕

troudgerbor 评论于：2010.06.16 22:43

Allo [回复]