Locking problem with Oralce 9i/PowerHouse

[Peter Bateman]

Frank:

It sounds like the granularity of the lock taken out by Oracle 9i
is rather coarse. Does Cognos even claim support for Oracle 9i?
Does Oracle have a lock monitoring tool? You can run Oracles's UTLLOCKT.SQL 
to show you where you are locked up.

It depends on the type of lock taken out by Quick.
I would try running a read_only transaction and the update transaction.
the read_only transaction would be commited often. I would put my find
and lookup processing in the read_only transaction.

One could do commit at update and in the higher level screen where
you nornally would do the commit for all the data manipulation command
create a procedure backout which reverses what was done in the subscreen. 
Not a great solution.


I hope this helps,
Regards,
Peter








>From: Frank Huizinga <frank.huizinga@solipsis.nl>
>To: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
>Subject: Locking problem with Oralce 9i/PowerHouse
>Date: Tue, 1 Apr 2003 15:44:27 +0200
>
>Hi,
>
>The problem is that I have a screen with just one file declared as primary
>and the Nocommit option applied to the screen statement, when two or more
>users are running this screen and one of them does an update the other ones
>are locked as long as the transaction has not been committed or rollbacked
>by the first user.
>
>How can I avoid users from being locked and still use the Nocommit option 
>on
>the screen statement.
>
>Sample:
>
>Screen X Nocommit
>
>File DAILY_RENTAL In AL_DB Primary
>
>Generate
>
>
>Thanks, Frank
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail