Oracle database statistics are very import in Cost Based optimizer (CBO). Sometimes the execution plan differs from production database to test databases even though the table, index structures are same. The execution plan might be good in production database compare to the test database. DBAs might get the complaints from the testers. In this situation DBAs can export the schema or table statistics to the test database.

Steps to transfer the optimizer statistics: TRANS schema stats from Prod to Test

Create the statistics table. DBAs can use any of the below mentioned syntax