cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
I will power on terminal A because I know that , I switched it
before.
If we have more terminal , think if we have 200 termianl and one of them
power off. !!!
but I do not know which one is it. In this case which one is lady !!!
( I see all terminals (lady ) in the session (Las Vegas) but
> Ali TOYGAR wrote:
>
> Hi ,
> I have a problem.
> I wrote an sql : in TERMINAL A
>
> select col1,col2
> from tableX
> where col1 = ...
> for update
>
> I wrot same sql , in other terminal TERMINAL B
>
>
Hi ,
I have a problem.
I wrote an
sql : in TERMINAL A
select col1,col2
from tableX
where col1 = ...
for update
I wrot same sql , in other terminal TERMINAL
B
select col1,col2
On Tuesday 30 October 2001 14:45, Janet Linsy wrote:
> Hi all,
>
> About the locking, could someone show me some script
> that shows who is locking others and who is being
> locked? And how to get the related locking or locked
> queries?
>
> Thank you!
>
> Janet
>
Well, here's the one I use. It
Hi all,
About the locking, could someone show me some script
that shows who is locking others and who is being
locked? And how to get the related locking or locked
queries?
Thank you!
Janet
__
Do You Yahoo!?
Make a great connection at Yahoo! P
How about trying v$session_wait and v$session_event? That should tell you
what it is waiting for.
Henry
-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I had a developer come to me yesterday and tell me his session had hung,
did you select * from v$lock...for his sid?
-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I had a developer come to me yesterday and tell me his session had hung,
and sure enough it had, he was executing an INSERT into a ta
Hi all,
I had a developer come to me yesterday and tell me his session had hung,
and sure enough it had, he was executing an INSERT into a table with 5
columns. Oracle was just sitting there, but all the other sessions
logged into the database were fine. I got the SQL out of the SQL Area
and ran
When you create or rebuild an index you usually lock
share the whole table. From 8.1.X and onwards you can
create and rebuild an index with the clause "online"
and transform that lock into a SSX lock. F.e.:
create index crow on ciclon(a) online;
Regards.
--- Harvinder Singh <[EMAIL PROTECTED]>
Hi,
we need to create a index on hot table(lot of updates r going on) but we r
getting error:
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
when i use create indexonline it just hangs there...
Is there any option to create index while not stopping the bat
M
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Lock Problem
Hi List,
We have an application running on Oracle database
8.0.5 on NT, this application developed for 1500 users
bu
ACLE-L
Subject: Lock Problem
Hi List,
We have an application running on Oracle database
8.0.5 on NT, this application developed for 1500 users
but after 15 connections every thing is locked, they
asked me to have a look and find out what's the
problem.
If any body have any clue which pa
Well my answer to "What most likely is the problem" is "Code".
Bad code generates poor locking. Alot of locking problems are code
problems.
But, look in v$lock (need to run catblock.sql if you haven't already) and
look at the lock types, and objects being locked.
Narrow it down to specific obje
Hi List,
We have an application running on Oracle database
8.0.5 on NT, this application developed for 1500 users
but after 15 connections every thing is locked, they
asked me to have a look and find out what's the
problem.
If any body have any clue which part must check first
and most likley wha
15 matches
Mail list logo
