Developer hangs exporting results

[Ron E]

I don't think this is a Developer issue, because similar things happen in other products - even SPOOLs from SQL Plus. I'm just wondering if anyone has experienced this.

We switched our datawarehouse to Oracle 10G several months ago. After that time, under several versions of Developer, as well as several versions of the Oracle client, if anything slows the system down, exports to a PC file start hanging up after a varying amount of time. Looking at the SQL Debug trace, we always see where the data transfer is continuing smoothly until the very end. At that point, it looks like this:

---------------------------
4/4/2008 3:51:45 PM TOracleQuery $02F524D0 Start Query.Next for up to 100 records
4/4/2008 3:51:45 PM TOracleQuery $02F524D0 End (100 records processed)
Duration = 0
4/4/2008 3:51:45 PM TOracleQuery $02F524D0 Start Query.Next for up to 100 records
4/4/2008 3:51:45 PM TOracleQuery $02F524D0 End (100 records processed)
Duration = 0.015
4/4/2008 3:51:45 PM TOracleQuery $02F524D0 Start Query.Next for up to 100 records

(I killed the process here...)
4/4/2008 3:57:45 PM Aborting thread
4/4/2008 3:57:47 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
--------------------
The PC requests the next 100 rows, and nothing is returned from the database. Once the database is less busy and running faster, the same file can be exported on the same PC with no problem.

We haven't found any errors on either side, and IP traces from both the PC and AIX box don't have any missed packets that we can see. Both sides just sit there, each waiting for the other to respond. We have let them sit for hours and even the sessions don't time out. The only unusual thing on the PC side is that the CPU always pegs at 100% and the fan speeds up like the PC is starting to overheat.

Has anybody ever run into anything like this and can point us to someplace to look?

Thanks,
Ron

 

[Marco Kalter]

Which process on the client PC takes up the 100% CPU time?

 

[pwo1433]

(From Ron E (It wouldn't let me log in the past couple days)

When it locks up, PLSQLDEV.EXE has 99% CPU usage in Task Manager, using about 39,825K memory. Performance shows 2 gig memory, 1,343,000 available, cache 1,494,900, handles 9772, threads 536 processes 43.

Ron

 

[Marco Kalter]

So this seems like an error when fetching the records, since the debug trace file never comes out of that call, and it takes up all the CPU time.

Do the same symptoms occur when "similar things happen in other products" as you say?

 

[Ron E]

The symptoms always seem to be the same (the CPU at 100%, the fan coming on, and the database session 'inactive' in a user response wait), but I haven't been able to get it to happen reliably when I could do an ODBC or other trace. I have some network people looking at the IP trace, but they don't sound like they've seen much so far. The people we have running Discoverer sometimes get locked up after it connects to the database, while it is running the queries to look up their User ID, security, and recently run queries. Access seems to have trouble sometimes on login, but mostly when viewing large tables or running a query to export. I haven't been able to get any kind of trace on any of those yet, but their symptoms are the same. I was just hoping somebody had run into something like this before. With no error messages, it's hard to debug.

 

[pwo1433]

We have found the problem is not related to anything of PL/SQL Dev. or Oracle, but is caused by a config problem in a security tool "Digital Guardian". Our techs changed that config and the problem is solved !!
Thanks.

 

[Marco Kalter]

Okay, thanks for letting us know.