Tracking exp with 10046 AND exp with 10046
I wrote a blog about why Oracle expdp is faster than exp. What is the principle? I learned from the official documentation. Now I am going to analyze the exp process through 10046.
C: \ Users \ Administrator> exp LCAMTEST/LCAMTEST@10.10.15.25 _ LCAM file = d:/test. dmp tables = (BPMS_RU_ACTIVE_INS)
SQL> SELECT p. spid, p. addr, p. pid, s. sid, SUBSTR (s. username, 1, 15) "USERNAME ",
SUBSTR (s. program, 1, 15) "PROGRAM"
FROM v $ process p, v $ session s
WHERE s. paddr = p. addr
AND addr = (SELECT paddr FROM v $ session where upper (program) LIKE 'exp % ');
SPID ADDR PID SID USERNAME PROGRAM
--------------------------------------------------
15067 1000000018c4ffd10 24 10 LCAMTEST exp.exe
To Log On As sys, otherwise oradebug setospid 15067 reports ORA-01031: insufficient permissions.
SQL> oradebug setospid 15067
Oracle pid: 18, Unix process pid: 15067, image: oracle @ oracle (S000)
SQL> oradebug unlimit
Processed statements
SQL> oradebug Event 10046 trace name context forever, level 12
Processed statements
D: \> tkprof lcamtest_s000_15067.trc 15067.txt
**************************************** ****************************************
Count = number of times OCI procedure was executed
Cpu = cpu time in seconds executing
Elapsed = elapsed time in seconds executing
Disk = number of physical reads of buffers from disk
Query = number of buffers gotten for consistent read
Current = number of buffers gotten in current mode (usually for update)
Rows = number of rows processed by the fetch or execute call
**************************************** ****************************************
SQL ID: 9c4gmqy4k7a7q
Plan Hash: 3521625488
SELECT/* + NESTED_TABLE_GET_REFS + */"LCAMTEST". "BPMS_RU_ACTIVE_INS ".*
FROM
"LCAMTEST". "BPMS_RU_ACTIVE_INS"
Call count cpu elapsed disk query current rows
-----------------------------------------------------------------------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 460025 18.25 13.83 31870 485572 0 2300122
-----------------------------------------------------------------------
Total 460025 18.25 13.83 31870 485572 0 2300122
Misses in library cache during parse: 0
Parsing user id: 87
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ----------------------
Virtual circuit wait 919983 0.25 309.81
SQL * Net message from client 460026 0.01 36.02
SQL * Net message to client 460025 0.00 0.67
Db file scattered read 250 0.07 1.68
**************************************** ****************************************