OpenTemp table DBstats
I have created one Temp table which is truncated and load from Informatica Powercenter.
My question is those temp tables required DBSTATS, after the truncate and load happened? or it will automatically take the DBSTATS. because I'm facing an issue at the first time load. second time load looks fine
1 Replies
Bruno Fernandez replied 4 months ago0 likes0 dislikesStarting with Oracle 12cR1, Oracle will gather automatic statistics in bulk load operations, making it unnecessary to gather statistics subsequently. This means extra table scans for statistics collection are unnecessary and there is less chance that you will forget to gather statistics after bulk loads.
Operations such as CTAS
Bulk direct path insert select
A bulk load into an empty partitioned table will trigger the gathering of global statistics, but no partition-level statistics.
In any of these cases, you won't need to gather statistics, Oracle will do it automatically.
Software91
DevOps48
Frontend Development24
Backend Development20
Server Administration17
Linux Administration28
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Jhone ButtlerJhone ButtlerJhone Buttler
Subscribe to get latest updates