SQL*Loader direct path
These views provide information relevant to the current SQL*Loader direct path operation:
- V$LOADCSTAT
View in which Oracle stores statistics about the number of rows processed during the current load. However, since you cannot query the view when the load is in progress, all queries of the view return no rows found.
- V$LOADPSTAT
View used by SQL*Loader to track statistics for the current direct load. Since this information applies only to the current session, it will always return rows when queried by a user.
- V$LOADTSTAT
View in which Oracle stores additional statistics about the number of rows discarded during the current load. However, since you cannot query the view when the load is in progress, all queries of the view return no rows found.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
