Re: Very Slow Process problem.
Abhay
Maybe its a long transaction? Check your logs with onstat -l.
HTH
Sujit
______________________________ Reply Separator _________________________________
Subject: Very Slow Process problem.
Author: abhay@cheerful.com at Internet
Date: 4/21/98 2:54 PM
Environment : OnLine 7.23uc4 and PeopleSoft
One query is running for 18 hours and we don't want to kill the process.
Query goes like this :
insert into c
select distinct col1,col2.....coln
from a,b
where b.col1=some value
and a.col1= some value
and a.col2=b.col2
and a.col3=b.col3 ....
Table a has 700000 rows and b has 8000 rows.
I checked no. of rows in c and there is nothing.
Does it mean that the select is still running ?
Please help.
Thanks in advance.
Abhay Mannur