CM,
We are using ORACLE 8.1.7.3 on HP-UX 11.0 for a fairly
large warehouse project ( 150 Gigs growing at the rate
of 15 Gigs a month) and with all the bells and
whistles like STAR_TRANSFORMATION and partitioning
turned on. Apart from some memory leak issue we are
not facing any major problems.
HTH
And usually they are caused by app. design issues, not database issues.
Of course, unless you are dealing with MS SQL Server.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original Message -
To: "Multiple
Are they 04020 deadlocks or 00060 deadlocks ?
Are they deadlocking on TX mode 6 or TX mode 4 ?
There isn't much useful information in your post,
but if you are using bitmap star transformations
it is possible that your deadlock is a TX mode 4
type due to concurrent updates in overlapping
bitmap
Hi,
Deadlocks happen for N number of reasons. Please post
the deadlock graph for further investigation.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 22, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Is anyone hav
Is anyone having deadlocking issues with the 8.1.7.2 release of Oracle?
If you are, how serious are these errors? What are the consequences
of the deadlock error messages.How long does it actually take to
clean up the deadlocks? Does one of the transactions roll back?
Does it then reissue l