SAP Note 602667 - Perform a SQL Trace on an oracle utility or external program

Component : Oracle - Backoffice Service Delivery

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 :

766349FAQ: Oracle SQL optimization
12826ORA-00904 or EXP-00037 during database export