Title: 9.2 peculiarity ... locking issue
I have a form that refers a package in the database. I open the form in forms designer, connect to database and compile the form. I do not run it.
While the forms is sitting at compile stage, I try to recompile the package that is referred by the form
monitoring a locking issue on database(oracle
8.1.7.0 on sun ), when I
look at all active session there are no active
session, but the same time
there are two active rollback segment assign to two
session, my question is
can we have an inactive session with an active
rollback segment?
Thanks
List,
I am monitoring a locking issue on database(oracle 8.1.7.0 on sun ), when I
look at all active session there are no active session, but the same time
there are two active rollback segment assign to two session, my question is
can we have an inactive session with an active rollback segment
Yes.
-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Locking Issue
List,
I am monitoring a locking issue on database(oracle 8.1.7.0 on
sun ), when I
look at all active
This is hugely irritating, and I guess it may be a
version-dependent thing, but I can't get the exact
match for the quoted locks by setting up three
tables in the manner described.
The locking information varies between 8.1.7.3
and 9.0.1.3, but I can't get a PK/FK issue to
behave (mis-behave ?)
I have been spending most of my morning trying to resolve a locking issue. I think
I could me missing the forest for the trees. This is what happens: a user kicks off
two identical jobs from two different PCs. Each of these jobs is doing the same
thing, but against different rows of data
to resolve a locking
issue. I think I could me missing the forest for the trees. This is
what happens: a user kicks off two identical jobs from two different
PCs. Each of these jobs is doing the same thing, but against different
rows of data (they are processing work orders in our system, but each
-Original Message-
From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Help with Locking Issue
I have been spending most of my morning trying to resolve a locking
issue. I think I could me missing
Cool! Happy querying...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with Locking Issue
I had already checked
://www.jlcomp.demon.co.uk/faq/ind_faq.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 18 April 2002 19:15
I have been spending most of my morning trying to resolve a locking
issue. I think I could me missing the forest for the trees. This is
what happens: a user
with Locking Issue
I have been spending most of my morning trying to resolve a
locking
issue. I think I could me missing the forest for the trees. This is
what
happens: a user kicks off two identical jobs from two different PCs.
Each
of these jobs is doing the same thing, but against
Hello All
we got a problem with DBMS_ALERT package. On clients we get sometimes an
error message:
ORA-2: ORU-10001: lock request error, status: 2
Where can be a problem? Is it a problem of ENQUEUE_RESOURCES or DML_LOCKS
parameters?
How can I check it?
Thank you for any responce
Regards
Ivo
ORA-2 is an error raised by raise_application_error.
In other words, you must examine the code, as it is
a custom error message.
Jared
On Tuesday 04 September 2001 07:25, Libal, Ivo wrote:
Hello All
we got a problem with DBMS_ALERT package. On clients we get sometimes an
error message:
Jared, wish that was entirely true, look at
$ORACLE_HOME/rdbms/admin/dbmsutil.sql some of oracle's code is using low
numbered 2 error nums :((at least thats that the internal docs say)
joe
[EMAIL PROTECTED] 09/04/01 12:32PM
ORA-2 is an error raised by
raise_application_error.In
To: [EMAIL PROTECTED]
cc:
Subject: Fwd: RE: Locking issue
This message comes from DBMS_ALERT_INFO package body. You need to contact
OWS.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
jkstill@cybco To: [EMAIL PROTECTED]
n.com cc:
Subject: Fwd: Re: Locking issue
Kevin,
Here's one that has been posted to our site recently by a customer
(www.cool-tools.co.uk Support User Defined Collections BLOCKER):
select l.sid sid,
s.username username,
s.program program,
t.sql_text,
u.name
DBA Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73 Princeton Street North, Chelmsford 01863
-Original Message-From: Kevin Lange
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 2:47
PMTo: Multiple recipients of list ORACLE-LSubject:
Locking Is
Title: Message
Thanks Christopher. I will see
what I can get out of them.
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 23, 2001 10:24
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Locking Issue
Take a look
Back to the experts
We have an
application that, litterally overnight, developed locking
issues.
Our users
start working just fine. Then, right now cause unknown, our inserts
start being blocked. Usually there are so many so fast that we do
not even know what is
check out $ORACLE_HOME/rdbms/admin/utlockt.sql
joe
[EMAIL PROTECTED] 08/22/01 02:46PM
Back to the experts
We have an
application that, litterally overnight, developed locking
issues.
Our users
start working just fine. Then, right now cause unknown, our inserts
start
I had similar problem with my database and that was due to MTS. Disabling MTS resolved
the locking issue. I think this has been resolved in the newer versions of oracle8.
Thanks
Rakesh
We have an application that, litterally overnight, developed locking issues.
Our users start working just
23 matches
Mail list logo