We are using a tool called Marketic one to process letters.
In the beginning it inserts in a table. The insertion seems to hangs. It is been 2 hours it is doing nothing.
I have looked for the locks there is no locks on the table.
My database is in Archive log mode.
DB version is oracle 184.108.40.206
operating system is Win2000 advanced server
Can somebody guide me where I have to look for to find a solution?
Is just the INSERT hung? Can you do other operations on other sessions? If you have not enabled automatic archival, the entire instance will hang until you archive logs manually (although I don't think there is a good chance of that happening on a production database without being noticed before).
Hard to guess without further details.
An ounce of action is worth a ton of theory.
Have you looked to see what the session is waiting for?
Here are a couple of queries that may help (need to provide the sid)
col minutes for 999.999
select event, total_waits, (time_waited/100)/60 Minutes, average_wait, max_wait
where sid = &sid
AND event NOT LIKE 'SQL*Net%'
SELECT sw.sid, s.username, sw.event, sw.wait_time,
sw.state, sw.seconds_in_wait SEC_IN_WAIT
FROM v$session s, v$session_wait sw
WHERE s.username IS NOT NULL
AND sw.sid = s.sid
AND sw.event NOT LIKE '%SQL*Net%'