SQL*Loader direct path
The following views provide information relevant to the current SQL*Loader direct path operation:
- *$LOADCSTAT
View in which Oracle stores statistics about the number of rows processed during the current load. However, because you cannot query the view when the load is in progress, all queries of the view return “no rows found.”
- *$LOADPSTAT
View used by SQL*Loader to track statistics for the current direct load. Because this information applies only to the current session, it will always return zero rows when queried by a user.
- *$LOADTSTAT
View in which Oracle stores additional statistics about the number of rows discarded during the current load. However, because you cannot query the view when the load is in progress, all queries of the view return “no rows found.”
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access