Export tables SLOW?

[fctb]

Hi,

I don't know if this is happening only to me but it seems like export table (SQL Inserts) is VERY SLOW.

For example a 60k rows are exported in 20 minutes. The table has only 35 columns with no LOBs/CLOBs. A complete select/"parse" in the grid takes about 30sec.

Is there something I can check? Does anyone else has the same problem?

Thanks and Regards!

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).

 

[fctb]

Hi Marco,

in the debug file during the export I can see

00:00:20.269 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:00:20.272 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:00:22.839 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:00:22.842 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:00:25.411 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:00:25.413 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:00:27.943 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:00:27.945 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0

.................................................................................

             Duration = 0
00:22:44.892 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:44.898 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:22:47.023 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:47.026 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:22:49.144 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:49.147 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:22:51.273 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:51.275 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:22:53.394 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:53.396 TOracleQuery ___SNIPPET___AA29A80 End  (100 records processed)
             Duration = 0
00:22:55.508 TOracleQuery ___SNIPPET___AA29A80 Start Query.Next for up to 100 records
00:22:55.510 TOracleQuery ___SNIPPET___AA29A80 End  (66 records processed)

Changing the "Commit every" (to 1000) does not change the "(100 records processed)". Seems like the fetch is ok but the conversion the data to sql is very slow.

P.S. the computer where I'm executing the export is an I7-4790 CPU with 16GB of RAM (it's a decent computer )

Regards!

 

[fctb]

Hi,

As I had some time today, I installed an older version of PLSQLDev (11.0.6) and I tried the export. It is 10x faster (same table, same database, same computer).

00:00:05.801 TOracleQuery ___SNIPPET___C042FC0 End  (100 records processed)
             Duration = 2.032
00:00:05.803 TOracleQuery ___SNIPPET___C042FC0 Start Query.Next for up to 100 records
00:00:05.805 TOracleQuery ___SNIPPET___C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.806 TOracleQuery ___SNIPPET___C042FC0 Start Query.Next for up to 100 records
00:00:05.807 TOracleQuery ___SNIPPET___C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.808 TOracleQuery ___SNIPPET___C042FC0 Start Query.Next for up to 100 records
00:00:05.809 TOracleQuery ___SNIPPET___C042FC0 End  (100 records processed)
             Duration = 0
00:00:05.811 TOracleQuery ___SNIPPET___C042FC0 Start Query.Next for up to 100 records
00:00:05.812 TOracleQuery ___SNIPPET___C042FC0 End  (100 records processed)
             Duration = 0

.......................................

00:02:07.499 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:07.500 TOracleQuery ___SNIPPET___C043C20 End  (100 records processed)
             Duration = 0
00:02:07.675 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:07.677 TOracleQuery ___SNIPPET___C043C20 End  (100 records processed)
             Duration = 0
00:02:07.849 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:07.850 TOracleQuery ___SNIPPET___C043C20 End  (100 records processed)
             Duration = 0
00:02:08.023 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:08.025 TOracleQuery ___SNIPPET___C043C20 End  (100 records processed)
             Duration = 0
00:02:08.199 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:08.201 TOracleQuery ___SNIPPET___C043C20 End  (100 records processed)
             Duration = 0
00:02:08.348 TOracleQuery ___SNIPPET___C043C20 Start Query.Next for up to 100 records
00:02:08.350 TOracleQuery ___SNIPPET___C043C20 End  (66 records processed)
             Duration = 0
00:02:08.444 TOracleQuery Query Start Query.Execute

Did you tried the "Table export" with the latest version. Is the export ok on your side?

Regards!