Solution : https://service.sap.com/sap/support/notes/602667 (SAP Service marketplace login required)
Key words :
cd /oracle/t20/saptrace/usertraceorat20> ls -ltr-rw-rw---- 1 orat20 dba 358140 mar 7 09, terms sql trace exp imp external session reason, 0 - 64bit productionenter array fetch buffer size, sql> set pagesize 0sql> select sid, exporting table ce4hopc 5580443 rows exportedtable, sid serial# program---------- ---------- -------------------------- 9 16 exp@usacss02, sid ________________^ ^ serial# __________________, dmp > /dev/nullvolume size, identifyany sql related bottlenecks, oracle8i enterprise edition release 8
Related Notes :
766349 | FAQ: Oracle SQL optimization |
12826 | ORA-00904 or EXP-00037 during database export |