RE: <No subject>

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_at_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_at_cdotd.ernet.in Sent: Tuesday, July 04, 2000 3:30 PM
> To: ORACLE-L_at_fatcity.com
> Subject: <No 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_at_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_at_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).
Received on Wed Jul 05 2000 - 01:23:25 CDT