0032119: Oracle: importing big sample data is very slow

diff -r 35c9dae4b4ae src/org/apache/ddlutils/Platform.java
--- a/src/org/apache/ddlutils/Platform.java	Fri Jan 29 14:06:43 2016 +0100
+++ b/src/org/apache/ddlutils/Platform.java	Thu Feb 04 10:41:50 2016 +0100
@@ -289,7 +289,7 @@
    * Creates the database specified by the given parameters. Please note that this method does not
    * use a data source set via {@link #setDataSource(DataSource)} because it is not possible to
    * retrieve the connection information from it without establishing a connection.<br/>
-   * The given connection url is the url that you'd use to connect to the already-created database.<br/>
+   * The given connection url is the url that you'd use to connect to the already-created database. <br/>
    * On some platforms, this method suppurts additional parameters. These are documented in the
    * manual section for the individual platforms.
    * 
@@ -1307,6 +1307,8 @@
   public void disableAllFkForTable(Connection connection, Table table, boolean continueOnError)
       throws DatabaseOperationException;
 
+  public void updateStatistics();
+
   public void disableDatasetFK(Connection connection, Database model, OBDataset dataset,
       boolean continueOnError) throws DatabaseOperationException;
 
@@ -1498,4 +1500,5 @@
   public void setBatchEvaluator(SQLBatchEvaluator batchEvaluator);
 
   public SQLBatchEvaluator getBatchEvaluator();
+
 }
diff -r 35c9dae4b4ae src/org/apache/ddlutils/platform/PlatformImplBase.java
--- a/src/org/apache/ddlutils/platform/PlatformImplBase.java	Fri Jan 29 14:06:43 2016 +0100
+++ b/src/org/apache/ddlutils/platform/PlatformImplBase.java	Thu Feb 04 10:41:50 2016 +0100
@@ -3384,4 +3384,9 @@
   public SQLBatchEvaluator getBatchEvaluator() {
     return batchEvaluator;
   }
+
+  @Override
+  public void updateStatistics() {
+    // do not update statistics in default implementation
+  }
 }
diff -r 35c9dae4b4ae src/org/apache/ddlutils/platform/SqlBuilder.java
--- a/src/org/apache/ddlutils/platform/SqlBuilder.java	Fri Jan 29 14:06:43 2016 +0100
+++ b/src/org/apache/ddlutils/platform/SqlBuilder.java	Thu Feb 04 10:41:50 2016 +0100
@@ -4887,4 +4887,5 @@
   public void setForcedRecreation(String forcedRecreation) {
     this.forcedRecreation = forcedRecreation;
   }
+
 }
diff -r 35c9dae4b4ae src/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
--- a/src/org/apache/ddlutils/platform/oracle/Oracle8Platform.java	Fri Jan 29 14:06:43 2016 +0100
+++ b/src/org/apache/ddlutils/platform/oracle/Oracle8Platform.java	Thu Feb 04 10:41:50 2016 +0100
@@ -21,6 +21,7 @@
 
 import java.io.StringWriter;
 import java.io.Writer;
+import java.sql.CallableStatement;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
@@ -30,6 +31,9 @@
 import java.util.List;
 import java.util.Map;
 
+import javax.sql.DataSource;
+
+import org.apache.commons.dbcp.BasicDataSource;
 import org.apache.ddlutils.DatabaseOperationException;
 import org.apache.ddlutils.PlatformInfo;
 import org.apache.ddlutils.model.Database;
@@ -467,4 +471,38 @@
   public String limitOneRow() {
     return " where rownum<2";
   }
+
+  @Override
+  public void updateStatistics() {
+    long t = System.currentTimeMillis();
+    DataSource ds = getDataSource();
+    String userName;
+    if (ds instanceof BasicDataSource) {
+      userName = ((BasicDataSource) ds).getUsername();
+    } else {
+      userName = getUsername();
+    }
+    getLog().info("Updating statistics for " + userName + "...");
+
+    Connection con = null;
+    String st = "{call dbms_stats.gather_schema_stats('" + userName + "', cascade=>TRUE)}";
+    try {
+      con = getDataSource().getConnection();
+
+      CallableStatement cst = con.prepareCall(st);
+      cst.execute();
+    } catch (SQLException e) {
+      getLog().error("Couldn't execute " + st, e);
+    } finally {
+      if (con != null) {
+        try {
+          con.close();
+        } catch (SQLException e) {
+          getLog().error("Error while closing the connection", e);
+        }
+      }
+    }
+
+    getLog().info("...statistics updated in " + (System.currentTimeMillis() - t) + " ms");
+  }
 }
diff -r 35c9dae4b4ae src/org/openbravo/ddlutils/task/ImportSampledata.java
--- a/src/org/openbravo/ddlutils/task/ImportSampledata.java	Fri Jan 29 14:06:43 2016 +0100
+++ b/src/org/openbravo/ddlutils/task/ImportSampledata.java	Thu Feb 04 10:41:50 2016 +0100
@@ -158,6 +158,15 @@
         }
       }
 
+      try {
+        con = platform.borrowConnection();
+        platform.updateStatistics();
+      } finally {
+        if (con != null) {
+          platform.returnConnection(con);
+        }
+      }
+
       log.info("Running modulescripts...");
       try {
         ModuleScriptHandler hd = new ModuleScriptHandler();