Query doesn't return

[bibi]

hi
i'm trying to run a simple select * from table query on one of our db.
the query does not return, (stuck)
this happens on every query againest this specific db.
when connected to other db , there is no problem.
when trying these queries on the problematic db but with sqlplus, there is no problem, it ok.

the problem is with version 6.0.6.947.

the problem does not exists with version 6.0.5.931

i tried to run pld with debug info, but all i found that it says the query is being executing, nothing more, it doent return with results
i need to kill pld process.

 

[Marco Kalter]

Strange. What is the database version?

 

[bibi]

database version is 9.2.0.6

i've checked other db's on the same machine of the "bad db" and they works ok

 

[bibi]

Hi

Problem solved.
after killing all sessions on this db, the problem
gone

 

[Marco Kalter]

Okay, thanks for letting me know.