Can you see the progress of loading when sqlldr starts with DIRECT = TRUE?

Question

I upload a large file (~ 22 GB) to Oracle using sqlldr using the direct = TRUE option (otherwise it will probably take months). So he sat there for several hours, loading as far as I can tell, but I don’t know how much longer it will take. Is there a way to check progress with such a load?

Answer 1

You can track the growth of the table you are pasting. Check out dba_segments.

Answer 2

: ik_zelf , , rows .

, , - ROWS sqlldr

rows -                ( : 64, )

, sqlldr ,

Save data point reached - logical record count 10000

, . , Oracle, , :

- . ROWS , 15 . , ( ) , . ROWS .

, 15 8- , .

http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007779

, SYS.V_$LOADTSTAT SYS.V_$LOADPSTAT . , Oracle:

SELECT , " ", .