Getting a ‘Memory fault(coredump)’ when I start the oracle listener

Try to re-configure em completely

emctl stop dbconsole
emca -repos drop
emca -repos create
emca -deconfig dbcontrol db
emca -config dbcontrol db

The best regards

Two points to take into account:

• Have you executed the query first in Toad, and afterwards in python+cx_Oracle ? The first time you execute the query, Oracle needs to parse the query, create an execution plan, and execute the plan: read from disk into memory (buffer cache), execute the joins, etc, ... The second time, Oracle uses the same execution plan (stored in the SGA), and reads from the buffer cache, not disk. It can be a lot less time the second time you execute the same query.

• Loading 8000 rows/5GB of data (655Kbytes per row!!!) into TOAD, to display them in the GUI, can take a lot of time. With python+cx_Oracle you are not displaying anything, so you are saving a lot of time here.

EDITED: OK, so 8000 rows/5 Mb of data (655 bytes per row) shouldn't be a problem for TOAD to display.

• Compare the Oracle environment variables in Linux with the HKEY_LOCAL_MACHINE\Software\Oracle registry variables in Windows. Check if the NLS_SORT, NLS_LANG, NLS_... variables have the same value.