Message-Id: <10550.111318@fatcity.com> From: VIVEK_SHARMA Date: Thu, 6 Jul 2000 15:46:43 +0530 Subject: Cache Table Mark Is space Equal to ONLY the Data in the Table Allocated from the db_block_buffers & NOT the SUN of EXTENT Sizes of the Table ? NOTE - The EXTENT Size can be far greater than Actual Data Size in the Table > -----Original Message----- > From: aheda@cdotd.ernet.in [SMTP:aheda@cdotd.ernet.in] > Sent: Thursday, July 06, 2000 2:13 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: > > but even if the whole table cannot be cached but should my hitratio should > be as low as 45% as 40 rows are selected in single block read. > > > Arvind > > > On Wed, 5 Jul 2000 uucp-relay-delhi!mleith@bradmark.co.uk wrote: > > > Your table is too large for your db block buffer. > > > > 100,000 rows, 40 rows in a block - 2500 blocks * 4kb = 10,000 which is > around 10mb. Your db block buffer is only 8mb, if you want to fully cache > this table you need to increase your db block buffer. > > > > HTH > > > > Mark > > > > -----Original Message----- > > From: MIME :aheda@cdotd.ernet.in Sent: Wednesday, July 05, > 2000 7:07 AM > > To: Mark Leith > > Cc: ORACLE-L@fatcity.com > > Subject: RE: > > > > > > > > Arvind > > For the fist question : I had tried the alter table xxxx cache > > but even after doing this when I give a select query on the same table i > > misses the cache and goes to the Disk > > > > about second question I can give you the size of sga and shared poll > > sga=24Mb > > shared pool 15Mb > > data bufers 8Mb > > table size=1 Mb > > block size 4kb > > > > > > thanks > > arvind On Tue, 4 Jul 2000 uucp-relay-delhi!mleith@bradmark.co.uk wrote: > > > > > alter table xxxxx cache; > > > > To undo this statement - alter table xxxxx nocache; > > > > Need a bit of environment info for your second question please.. > > > > HTH > > > > Mark > > > > -----Original Message----- > > > From: MIME :aheda@cdotd.ernet.in Sent: Tuesday, July 04, > 2000 3:30 PM > > > To: ORACLE-L@fatcity.com > > > Subject: > > > > > 1).how can we cache the whole data of a table? > > > > 2) why do we get a hit ratio of less than 50 % while we execute > select * > > > query on a single table contaiining 100000 rows and each db_block > contains > > > aroud 40 rows of table. > > > > > > Arvind > > > > > -- Author: INET: aheda@cdotd.ernet.in > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > -------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > << File: ENVELOPE.TXT >> > << File: ENVELOPE.TXT >> > > > > > -- > Author: > INET: aheda@cdotd.ernet.in > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may