Pl/Sql Developer startup is very slow

[zapata]

Hello

Pl/Sql Developer startup is very slow

What could be a reason

Thanks for reply

 

[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\plsqldev.exe" DebugSQL

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

 

[zapata]

PL/SQL Developer
Version 9.0.0.1601
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2.024.696 kB (1.100.904 available)
Paging file : 3.962.672 kB (3.079.328 available)
Virtual memory : 2.097.024 kB (2.015.164 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
DebugSQL

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

25.8.2011 9:35:26 Application started
25.8.2011 9:35:26 InitPreferences
25.8.2011 9:35:26 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
25.8.2011 9:35:26 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
25.8.2011 9:35:26 PreferenceSet.Load OK
25.8.2011 9:35:26 Determine LocalPrefPath
25.8.2011 9:35:26 [1]: C:\Program Files\PLSQL Developer\Preferences
25.8.2011 9:35:26 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\zapata
25.8.2011 9:35:26 Load C:\Program Files\PLSQL Developer\Preferences\zapata = 0
25.8.2011 9:35:26 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\zapata\default.ini
25.8.2011 9:35:26 PreferenceSet.Load OK
25.8.2011 9:35:26 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\zapata\New.ini
25.8.2011 9:35:26 PreferenceSet.Load OK
25.8.2011 9:35:26 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\zapata\user.prefs
25.8.2011 9:35:26 PreferenceSet.Load OK
25.8.2011 9:35:26 InitPreferences end
25.8.2011 9:35:26 SortPreferenceSets
25.8.2011 9:35:26 - New
25.8.2011 9:35:26 - Default zapata
25.8.2011 9:35:26 - System Default
25.8.2011 9:35:26 DoUpdateChildList
25.8.2011 9:35:26 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
25.8.2011 9:35:26 ReadString OK
25.8.2011 9:35:26 pfReadRegistry: "C:\Program Files\PLSQL Developer\PLSQLDev.exe" "%1"
25.8.2011 9:35:26 LoadPreferences
25.8.2011 9:35:26 LoadPreferences searching for default
25.8.2011 9:35:26 C:\Program Files\PLSQL Developer\Preferences\zapata\default.ini
25.8.2011 9:35:26 C:\Program Files\PLSQL Developer\Preferences\zapata\New.ini
25.8.2011 9:35:26 LoadPreferences NewPref := nil
25.8.2011 9:35:26 LoadPreferences
25.8.2011 9:35:26 LoadPreferences Reading preferences
25.8.2011 9:35:26 LoadPreferences ReadPosition
25.8.2011 9:35:26 LoadPreferences ToolsBrowserItemClick(nil)
25.8.2011 9:35:26 LoadPreferences CreateBrowserFilters...
25.8.2011 9:35:26 LoadPreferences Files
25.8.2011 9:35:26 LoadPreferences Buttons
25.8.2011 9:35:26 LoadPreferences Printer
25.8.2011 9:35:26 LoadPreferences FileBrowserFolders
25.8.2011 9:35:26 LoadPreferences Connections
25.8.2011 9:35:26 LoadPreferences BrowserFolders
25.8.2011 9:35:26 LoadPreferences
25.8.2011 9:35:26 LoadPreferences end
25.8.2011 9:36:36 MacroLibFilename: c:\zapata.lib
25.8.2011 9:36:46 TOracleSession $02FE6740 Start Session.LogOn as scott@razvoj.WORLD
25.8.2011 9:36:54 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25.8.2011 9:36:54 TOracleQuery Query End (1 record processed)
Duration = 0,062
25.8.2011 9:36:54 TOracleSession $02FE6740 End
Duration = 8,578
25.8.2011 9:36:54 TOracleQuery $02FA1190 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
25.8.2011 9:36:54 TOracleQuery $02FA1190 End (1 record processed)
Duration = 0
25.8.2011 9:36:54 TOracleSession $02FE64A0 Start Session.LogOn as scott@razvoj.WORLD
25.8.2011 9:36:54 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25.8.2011 9:36:54 TOracleQuery Query End (1 record processed)
Duration = 0
25.8.2011 9:36:54 TOracleSession $02FE64A0 End
Duration = 0,094
25.8.2011 9:36:54 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25.8.2011 9:36:54 TOracleQuery Query End (5 records processed)
Duration = 0
25.8.2011 9:36:54 TOracleQuery $02FA0ED0 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
25.8.2011 9:36:54 TOracleQuery $02FA0ED0 End
Result = ORA-00942: table or view does not exist
Duration = 0,015
25.8.2011 9:36:54 LogonHistorySave start
25.8.2011 9:36:54 ChangeUserPref LogonHistory,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref DSA,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref ColumnAssociations,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref ImportAssociations,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref BrowserFilters,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref FileBrowserFolders,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref Connections,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref BrowserFolders,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref SessionQueries,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref ExternalTools,
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,031
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
25.8.2011 9:36:54 ChangeUserPref Documents,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref Reports,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 ChangeUserPref CurrentConnections,
25.8.2011 9:36:54 ChangeUserPref end
25.8.2011 9:36:54 PreferenceSet.Save
25.8.2011 9:36:54 PreferenceSet Filename = C:\Program Files\PLSQL Developer\Preferences\zapata\user.prefs
25.8.2011 9:36:54 PreferenceSet AltFile = user.prefs
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25.8.2011 9:36:54 PreferenceSet.Save end
25.8.2011 9:36:54 TOracleQuery $02FA12F0 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = SCOTT
25.8.2011 9:36:54 LogonHistorySave end
25.8.2011 9:36:54 FormCreate Logon.Executed -1
25.8.2011 9:36:54 FormCreate SessionChanged
25.8.2011 9:36:54 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
25.8.2011 9:36:54 TOracleQuery Query End (5 records processed)
Duration = 0
25.8.2011 9:36:54 TOracleQuery $02FA1030 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
25.8.2011 9:36:54 TOracleQuery $02FA1030 End
Result = ORA-00942: table or view does not exist
Duration = 0,062
25.8.2011 9:36:54 SessionChanged SetDBAViews
25.8.2011 9:36:54 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from all_synonyms where 1=0
25.8.2011 9:36:54 TOracleQuery $02FA1030 End (0 records processed)
Duration = 0,016
25.8.2011 9:36:54 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
25.8.2011 9:36:54 TOracleQuery $02FA1030 End
Result = ORA-00942: table or view does not exist
Duration = 0,031
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
25.8.2011 9:36:54 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25.8.2011 9:36:54 TOracleQuery $02FA1030 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
25.8.2011 9:36:54 TOracleQuery $02FA1030 End
Result = ORA-00942: table or view does not exist
Duration = 0,016
25.8.2011 9:36:54 TOracleQuery $02FA1030 Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
25.8.2011 9:36:55 TOracleQuery $02FA12F0 End (4 records processed)
Duration = 0,437
25.8.2011 9:36:55 TOracleQuery $02FA12F0 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = SCOTT
25.8.2011 9:36:55 TOracleQuery $02FA1030 End (16 records processed)
Duration = 0,328
25.8.2011 9:36:55 SessionChanged Authorizations.Load
25.8.2011 9:36:55 SessionChanged EnableAuthorizedMenus
25.8.2011 9:36:55 ExecuteConnectScript starts
25.8.2011 9:36:55 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
25.8.2011 9:36:55 TOracleQuery $02FA1030 End
Duration = 0
25.8.2011 9:36:55 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
25.8.2011 9:36:55 TOracleQuery $02FA1030 End
Duration = 0
25.8.2011 9:36:55 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
25.8.2011 9:36:55 TOracleQuery $02FA1030 End
Duration = 0
25.8.2011 9:36:55 ExecuteConnectScript ends
25.8.2011 9:36:55 SetSessionAction starts: Primary Session
25.8.2011 9:36:55 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from dual
25.8.2011 9:36:55 TOracleQuery $02FA1030 End (1 record processed)
Duration = 0
25.8.2011 9:36:55 TOracleQuery $02FA1030 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
25.8.2011 9:36:55 TOracleQuery $02FA1030 End
Duration = 0
25.8.2011 9:36:55 SetSessionAction ends
25.8.2011 9:36:55 SessionChanged LoadRecentObjects
25.8.2011 9:36:55 SessionChanged Logoff secondary sessions
25.08.2011 9:36:55 SessionChanged EnableChildFunctions
25.08.2011 9:36:55 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\zapata\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\zapata\product\11.2.0\client_1\bin\oci.dll
25.08.2011 9:36:55 Lock
25.08.2011 9:36:55 UnLock
25.08.2011 9:36:56 SortPreferenceSets
25.08.2011 9:36:56 - New
25.08.2011 9:36:56 - Default zapata
25.08.2011 9:36:56 - System Default
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,782
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,016
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,032
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from all_synonyms where 1=0
25.08.2011 9:36:56 TOracleQuery $02FA1030 End (0 records processed)
Duration = 0,015
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,031
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Result = ORA-00942: table or view does not exist
Duration = 0,016
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,031
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,031
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,032
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,046
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,016
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 DoUpdateChildList
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,109
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 FormActivate start
25.08.2011 9:36:56 FormActivate end
25.08.2011 9:36:56 WMUpdatePopups starts
25.08.2011 9:36:56 LoadDesktop starts
25.08.2011 9:36:56 LoadDesktop OpenProject
25.08.2011 9:36:56 OpenProject: C:\Program Files\PLSQL Developer\Projects\tecaj.prj
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,094
25.08.2011 9:36:56 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 DoUpdateChildList
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
25.08.2011 9:36:56 TOracleQuery Query End (5 records processed)
Duration = 0,016
25.08.2011 9:36:56 SessionChanged SetDBAViews
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from all_synonyms where 1=0
25.08.2011 9:36:56 TOracleQuery $02FA1030 End (0 records processed)
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Result = ORA-00942: table or view does not exist
Duration = 0,016
25.08.2011 9:36:56 SessionChanged Authorizations.Load
25.08.2011 9:36:56 SessionChanged ApplyPreferences
25.08.2011 9:36:56 SortPreferenceSets
25.08.2011 9:36:56 - New
25.08.2011 9:36:56 - Default zapata
25.08.2011 9:36:56 - System Default
25.08.2011 9:36:56 SessionChanged EnableAuthorizedMenus
25.08.2011 9:36:56 ExecuteConnectScript starts
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Duration = 0,015
25.08.2011 9:36:56 ExecuteConnectScript ends
25.08.2011 9:36:56 SetSessionAction starts: Primary Session
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = select null from dual
25.08.2011 9:36:56 TOracleQuery $02FA1030 End (1 record processed)
Duration = 0
25.08.2011 9:36:56 TOracleQuery $02FA1030 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
25.08.2011 9:36:56 TOracleQuery $02FA1030 End
Duration = 0
25.08.2011 9:36:56 SetSessionAction ends
25.08.2011 9:36:56 SessionChanged LoadRecentObjects
25.08.2011 9:36:56 SessionChanged Logoff secondary sessions
25.08.2011 9:36:56 SessionChanged EnableChildFunctions
25.08.2011 9:36:56 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\zapata\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\zapata\product\11.2.0\client_1\bin\oci.dll
25.08.2011 9:36:56 Lock
25.08.2011 9:36:56 UnLock
25.08.2011 9:36:56 LoadDesktop ends
25.08.2011 9:36:56 WMUpdatePopups ends
25.08.2011 9:37:00 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 3,406
25.08.2011 9:37:00 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:00 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,282
25.08.2011 9:37:00 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:00 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,328
25.08.2011 9:37:00 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,36
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,032
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,093
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,079
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,046
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 SortPreferenceSets
25.08.2011 9:37:01 - New
25.08.2011 9:37:01 - Default zapata
25.08.2011 9:37:01 - System Default
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,141
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (100 records processed)
Duration = 0,031
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Next for up to 100 records
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (2 records processed)
Duration = 0,016
25.08.2011 9:37:01 TOracleQuery $02FA12F0 Start Query.Execute
SQL =
select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema
or o.owner = 'PUBLIC'
:SCHEMA = SCOTT
25.08.2011 9:37:01 TOracleQuery $02FA12F0 End (0 records processed)
Duration = 0,016
25.08.2011 9:37:01 TOracleSession $02FE64A0 Start Session.LogOff
25.08.2011 9:37:01 TOracleSession $02FE64A0 End
Duration = 0,015
25.08.2011 9:37:16 TStatistics.Init starts
25.08.2011 9:37:16 InitStatNames starts
25.08.2011 9:37:16 select name from v$statname order by statistic#
25.08.2011 9:37:16 TOracleQuery $02FA0ED0 Start Query.Execute
SQL = select name from v$statname order by statistic#
25.08.2011 9:37:16 TOracleQuery $02FA0ED0 End
Result = ORA-00942: table or view does not exist
Duration = 0,031