Techiio-author
Started by Jake WiliamsSep 30, 2021

Open
Temp table DBstats

1 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 1 VIEWES SHARE

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

Techiio-commentatorBruno Fernandez replied 4 months ago0 likes0 dislikes

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

You must be Logged in to reply
Trending Technologies
15
Software91
DevOps48
Frontend Development24
Backend Development20
Server Administration17
Linux Administration28
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance