Help : Getting consistent view
From: Chan Kim Bor <a007700_at_hp9000.csc.cuhk.hk>
Date: Thu, 16 Jun 1994 04:02:05 GMT
Message-ID: <1994Jun16.040205.10258_at_hp9000.csc.cuhk.hk>
Date: Thu, 16 Jun 1994 04:02:05 GMT
Message-ID: <1994Jun16.040205.10258_at_hp9000.csc.cuhk.hk>
- Acquire EXCLUSIVE lock on those required tables before doing select. The drawback is no update can be done by other processes on those rows not involved in the reporting.
- Use SET TRANSACTION READ ONLY statement The drawback is that it needs a huge rollback segment and no update statement can be made after the SET TRANSACTION point.
- Use SELECT FOR UPDATE statement to acquire neccessary ROW LOCK. The drawback is that it only apply on single table and it needs to issue this statement one by one for all needed tables. There incurs time gap in getting table snapshot.
- Use Oracle 7 replication facility to create an exact table image upto the time when reporting starts and resumes after finished report generation. The drawback is that it requires extra space and effort to keep the reporting database.
Does any one have idea about what Oracle facilities or 3rd party products can solve the above mentioned problem? Any feedback is welcome and thanks in advance.
Best regards,
Kimmy. Received on Thu Jun 16 1994 - 06:02:05 CEST