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.”