Expert Knowledgebase
We have a data warehouse (using segmented tablespaces for tables) which are
100% read-only, that is, no updating, no deleting, no inserting is
permitted. Would it be prudent to use LOCKSIZE TABLE for use with these
tables to prevent large numbers of page locks from being taken? We have
some application programs (which use this data) being bound with an
isolation parameter of UR, but some programs are being bound with CS,
although the actual data would not change while they are executing. Would
appreciate your input on whether or not changing the locksize to table would
improve performance for the queries by reducing the number of locks being
taken. Can you think of any negative ramifications to using LOCKSIZE TABLE
for these tables?
QUESTION POSED ON: 01 FEB 2005
QUESTION ANSWERED BY:
Craig Mullins
Well, I think the most prudent course of action would be to use
ISOLATION(UR) for the programs/statements that access these tables. I cannot
really think of any horrible consequences of switching to LOCKSIZE TABLE
under the exact circumstances you outline above. Of course, as soon as you
try to make one modification to any of these tables you'll experience
problems with LOCKSIZE TABLE. Either you'll never get the lock to make the
update or the update will lock everyone else out from access. If you are
confident that there are no updates (inserts/updates/deletes) then give it a
try. Personally, I'd feel more comfortable myself using UR to turn off
locking in the queries... of course, as soon as you make any updates in
that scenario your queries can possibly return inconsistent results (because
they did no locking).
Related Topics:
Search Advice from more than 250 TechTarget Experts
Your question may have already been answered! Browse or search more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice
ASSOCIATED RSS FEEDS
 |
|
Expert Answer Center: Expert Q&As |
|
View all RSS Feeds | RSS Info
|
|
|
|
|
|
|
| TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of . |
|
| | | |
All Rights Reserved, , TechTarget |
|
|
|
|
|
