Hi Folks

I am using PSD 9.0.0.1600. I have noticed that every time I run a SQL query in a SQL Window, there is a long delay (about 8 seconds) before the query starts to run during which time "Initializing..." appears on the status line. This time is not included in the execution time.

Below is a small extract from a Debug.txt file I generated that illustrates the problem, and may hold the answer. You will notice that there is nothing between these 2 lines:

19-Jul-2011 18:04:01 InitStatistics ends
19-Jul-2011 18:04:09 NavigationBookmarks.EnableButtons(Rebuild)

So for those 8 seconds nothing is happening.

Any ideas?

Best regards

Billy


19-Jul-2011 18:04:01 SQLForm Initializing...
19-Jul-2011 18:04:01 SetConnected starts
19-Jul-2011 18:04:01 Already connected: check connection
19-Jul-2011 18:04:01 TOracleQuery $03711650 Start Query.Execute
SQL = select 'x' from dual
19-Jul-2011 18:04:01 TOracleQuery $03711650 End (1 record processed)
Duration = 0.015
19-Jul-2011 18:04:01 Using existing connection
19-Jul-2011 18:04:01 EnableOutput starts
19-Jul-2011 18:04:01 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
:ENABLE = 1
:SIZE = 100000
19-Jul-2011 18:04:01 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
19-Jul-2011 18:04:01 EnableOutput done
19-Jul-2011 18:04:01 InitStatistics starts
19-Jul-2011 18:04:01 TOracleQuery $03711650 Start Query.Execute
SQL = select 'x' from dual
19-Jul-2011 18:04:01 TOracleQuery $03711650 End (1 record processed)
Duration = 0.015
19-Jul-2011 18:04:01 StartValues: StatQuery.ReadBuffer = 381
19-Jul-2011 18:04:01 StartValues: StatQuery.ReadBuffer set to 381
19-Jul-2011 18:04:01 TOracleQuery $03712410 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 1034
19-Jul-2011 18:04:01 TOracleQuery $03712410 End (0 records processed)
Duration = 0.016
19-Jul-2011 18:04:01 InitStatistics ends
19-Jul-2011 18:04:09 NavigationBookmarks.EnableButtons(Rebuild)
19-Jul-2011 18:04:09 NavigationBookmarks: Backward=0, Forward=0
19-Jul-2011 18:04:09 Lock
19-Jul-2011 18:04:09 UnLock
19-Jul-2011 18:04:09 SQLForm Executing...
19-Jul-2011 18:04:09 Lock
19-Jul-2011 18:04:09 UnLock
19-Jul-2011 18:04:09 SQLForm Executing...
19-Jul-2011 18:04:09 TSQLThread SQLThread Suspend ended
19-Jul-2011 18:04:09 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
19-Jul-2011 18:04:09 TOracleQuery Query End
Duration = 0
19-Jul-2011 18:04:09 TOracleQuery $03711BD0 Start Query.Execute
SQL = SELECT * FROM tdif_file_stages WHERE fstg_fle_id=90539 ORDER BY fstg_id
19-Jul-2011 18:04:09 TOracleQuery $03711BD0 End (8 records processed)
Duration = 0.016
19-Jul-2011 18:04:09 TOracleQuery SQLForm_2.TestQuery Start Query.Describe
SQL = SELECT * FROM tdif_file_stages
19-Jul-2011 18:04:09 TOracleQuery SQLForm_2.TestQuery End
Duration = 0.016
19-Jul-2011 18:04:09 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
19-Jul-2011 18:04:09 TOracleQuery Query End
Duration = 0.016
19-Jul-2011 18:04:09 TSQLThread SQLThread Postmessage
19-Jul-2011 18:04:09 TSQLThread SQLThread Suspend
19-Jul-2011 18:04:09 TSQLForm.ThreadFinished
19-Jul-2011 18:04:09 TSQLForm.ThreadFinished: SQLThread.Suspended
19-Jul-2011 18:04:09 SQLForm 8 rows selected in 0.078 seconds
19-Jul-2011 18:04:09 Lock
19-Jul-2011 18:04:09 UnLock
19-Jul-2011 18:04:09 EndValues: StatQuery.ReadBuffer = 381
19-Jul-2011 18:04:09 EndValues: StatQuery.ReadBuffer set to 381
19-Jul-2011 18:04:09 TOracleQuery $03712410 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 1034
19-Jul-2011 18:04:09 TOracleQuery $03712410 End (0 records processed)
Duration = 0.015
19-Jul-2011 18:04:09 NavigationBookmarks.EnableButtons(Rebuild)
19-Jul-2011 18:04:09 NavigationBookmarks: Backward=0, Forward=0
19-Jul-2011 18:04:09 TOracleQuery $037110D0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
19-Jul-2011 18:04:09 TOracleQuery $037110D0 End
Duration = 0
19-Jul-2011 18:04:09 SQLForm 8 rows selected in 0.078 seconds