Oracle Database Discussions

Hello,

we use Oracle 10.2.0.3 on Solaris 10 running on a SunFire V440 (2x1600MHz CPU, 8GB RAM, 3x147GB SCSI HDD).
There is a partitioned table with 11 million records using 10 partitions and consumes ~1,4 GB space.

The problem is that a 3rd party tool sends a request to the DB, but it never returns. I have copied the executed sql from the tool log file and executed from sqlplus but after 5 days I have killed the execution and so I don't really have a usable summary. However I know that the result of the select should be 0.

Any tip what should I try?

Thanks in advance!

The query is:
Select COUNT(COMMANDID) from COMMANDLOG
where STATEOFEXECUTION='failed' and COMMANDID in
(
Select COMMANDID from CommandLog where (
EVENTTIME between '23072008 11:10:00' AND '25072008 03:25:00'
AND COMMAND like 'Create ADJCGSMC%' AND SUBSTR(COMMAND,0,45) NOT LIKE '%MXN25%'
AND SUBSTR(COMMAND,0,45) NOT LIKE '%:987654321%'
AND COMMAND LIKE '%%')
)
Order by COMMANDID;