| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CACHE or NOCACHE
Do not cache it because it's obviously a transaction table and not a
reference
table. What you may pay attention to are extents, free lists and
initrans/maxtrans values. You should also consider using discrete
transactions where it is appropriate. What is more, make sure that your
DBWR and LGWR are well tuned, make sure that you have enough DML locks,
processes and the other relevand database resources. You should also make
sure that your hardware can support such a volume and that you are not
trying to get 200 MPH from an old Ford Escort.
-----Original Message-----
From: LOREN SUMMERS [mailto:loren_summers_at_yahoo.com]
Sent: Sunday, November 12, 2000 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: CACHE or NOCACHE
Hello Everyone,
I am new to the list and oracle8. We have a table in
which we will insert 100recs/second and update 200
recs/second. Should the table be put in KEEP buffer
cache or in default cache.
For every insert in this table we receive an
acknowlegement from another process in less than 20
minutes and based on that ack. two updates are
performed on the same row in that table.
for eg. Insert into table
bigtable(col1,col2,col3,ack,priority) values
('Test','test2','test3','Y');
After 10 minutes
Update table bigtable set ack ='Y' where col1='Test';
After 20 minutes
Update table bigtable set priority =1 where
col1='Test';
All these records are moved(Deleted) from this table to a history table every week.
I am not sure whether to put this table in keep cache or leave it in default cache.
Loren
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 Mon Nov 13 2000 - 09:36:21 CST
 |
 |