shared_pool_internal

sharedpool()sharedpool.,sharedpool.?.,.:sharedpool:Sessionaltered.trace:9i:SQL@gettrcnameTRACE_FILE_NAME--------------------------------------------------------------------------------/opt/oracle/admin/hsjf/udump/hsjf_ora_24983.trc8i:SQL@gettrcnameTRACE_FILE_NAME--------------------------------------------------------------------------------/usr/oracle8/admin/guess/udump/guess_ora_22038.trcSharedPoolfreelistfree,FreeListsizeBucketOracle8i,bucketsize(size):oracle:/usr/oracle8/admin/guess/udumpcatguess_ora_22038.trc|grepBucketBucket0size=44Bucket1size=76Bucket2size=140Bucket3size=268Bucket4size=524Bucket5size=1036Bucket6size=2060Bucket7size=4108Bucket8size=8204Bucket9size=16396Bucket10size=32780,76Bucket0;32780,Bucket10,,sharedpool,,BucketOraclesharedpoolBucket,bucket,chunkchunk,Bucket,,Bucket0,(,Bucket09030shared_pool_size150M)Bucketchunk2000sharepool,chunk,Bucket0sharepoolLatch,sharepoolOracle9i,shared_pool_sizeshared_pool_sizeOracle9i:[oracle@jumperoracle]$sqlplus/assysdbaSQL*Plus:Release9.2.0.3.0-ProductiononWedAug1822:13:072004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.3.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.3.0-ProductionSQLaltersessionsetevents'immediatetracenameheapdumplevel2';Sessionaltered.SQL@gettrcnameTRACE_FILE_NAME--------------------------------------------------------------------------------/opt/oracle/admin/hsjf/udump/hsjf_ora_24983.trcSQLSQL![oracle@jumperoracle]$cd$admin[oracle@jumperudump]$cathsjf_ora_24983.trc|grepBucketBucket0size=16Bucket1size=20Bucket2size=24Bucket3size=28Bucket4size=32Bucket5size=36Bucket6size=40Bucket7size=44Bucket8size=48Bucket9size=52Bucket10size=56Bucket11size=60Bucket12size=64Bucket13size=68Bucket14size=72Bucket15size=76Bucket16size=80Bucket17size=84Bucket18size=88Bucket19size=92Bucket20size=96Bucket21size=100Bucket22size=104Bucket23size=108Bucket24size=112Bucket25size=116Bucket26size=120Bucket27size=124Bucket28size=128Bucket29size=132Bucket30size=136Bucket31size=140Bucket32size=144Bucket33size=148Bucket34size=152Bucket35size=156Bucket36size=160Bucket37size=164Bucket38size=168Bucket39size=172Bucket40size=176Bucket41size=180Bucket42size=184Bucket43size=188Bucket44size=192Bucket45size=196Bucket46size=200Bucket47size=204Bucket48size=208Bucket49size=212Bucket50size=216Bucket51size=220Bucket52size=224Bucket53size=228Bucket54size=232Bucket55size=236Bucket56size=240Bucket57size=244Bucket58size=248Bucket59size=252Bucket60size=256Bucket61size=260Bucket62size=264Bucket63size=268Bucket64size=272Bucket65size=276Bucket66size=280Bucket67size=284Bucket68size=288Bucket69size=292Bucket70size=296Bucket71size=300Bucket72size=304Bucket73size=308Bucket74size=312Bucket75size=316Bucket76size=320Bucket77size=324Bucket78size=328Bucket79size=332Bucket80size=336Bucket81size=340Bucket82size=344Bucket83size=348Bucket84size=352Bucket85size=356Bucket86size=360Bucket87size=364Bucket88size=368Bucket89size=372Bucket90size=376Bucket91size=380Bucket92size=384Bucket93size=388Bucket94size=392Bucket95size=396Bucket96size=400Bucket97size=404Bucket98size=408Bucket99size=412Bucket100size=416Bucket101size=420Bucket102size=424Bucket103size=428Bucket104size=432Bucket105size=436Bucket106size=440Bucket107size=444Bucket108size=448Bucket109size=452Bucket110size=456Bucket111size=460Bucket112size=464Bucket113size=468Bucket114size=472Bucket115size=476Bucket116size=480Bucket117size=484Bucket118size=488Bucket119size=492Bucket120size=496Bucket121size=500Bucket122size=504Bucket123size=508Bucket124size=512Bucket125size=516Bucket126size=520Bucket127size=524Bucket128size=528Bucket129size=532Bucket130size=536Bucket131size=540Bucket132size=544Bucket133size=548Bucket134size=552Bucket135size=556Bucket136size=560Bucket137size=564Bucket138size=568Bucket139size=572Bucket140size=576Bucket141size=580Bucket142size=584Bucket143size=588Bucket144size=592Bucket145size=596Bucket146size=600Bucket147size=604Bucket148size=608Bucket149size=612Bucket150size=616Bucket151size=620Bucket152size=624Bucket153size=628Bucket154size=632Bucket155size=636Bucket156size=640Bucket157size=644Bucket158size=648Bucket159size=652Bucket160size=656Bucket161size=660Bucket162size=664Bucket163size=668Bucket164size=672Bucket165size=676Bucket166size=680Bucket167size=684Bucket168size=688Bucket169size=692Bucket170size=696Bucket171size=700Bucket172size=704Bucket173size=708Bucket174size=712Bucket175size=716Bucket176size=720Bucket177size=724Bucket178size=728Bucket179size=732Bucket180size=736Bucket181size=740Bucket182size=744Bucket183size=748Bucket184size=752Bucket185size=756Bucket186size=760Bucket187size=764Bucket188size=768Bucket189size=772Bucket190size=776Bucket191size=780Bucket192size=784Bucket193size=788Bucket194size=792Bucket195size=796Bucket196size=800Bucket197size=804Bucket198size=808Bucket199size=812Bucket200size=876Bucket201size=940Bucket202size=1004Bucket203size=1068Bucket204size=1132Bucket205size=1196Bucket206size=1260Bucket207size=1324Bucket208s