Delete Queries Hang When Executed in a SQL Window

[singularity]

Version 9.0

In a SQL window, when I try to execute a simple DELETE query

delete tbl;

on a table with only 3 rows, it hangs on "Initializing..." and never executes. Same thing happens when I try to run a DELETE on any table. Other DML commands work fine however.
When I try to run a DELETE in a Command window instead, it works.
Any ideas?

 

[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).

 

[singularity]

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

Physical memory : 2,097,152 kB (2,097,152 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (2,032,880 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files

Plug-Ins

3/21/2012 9:00:52 AM Application started
3/21/2012 9:00:52 AM InitPreferences
3/21/2012 9:00:52 AM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
3/21/2012 9:00:52 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
3/21/2012 9:00:52 AM PreferenceSet.Load OK
3/21/2012 9:00:52 AM Determine LocalPrefPath
3/21/2012 9:00:52 AM [1]: C:\Program Files\PLSQL Developer\Preferences
3/21/2012 9:00:52 AM LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\ADB4312
3/21/2012 9:00:52 AM Load C:\Program Files\PLSQL Developer\Preferences\ADB4312 = 0
3/21/2012 9:00:52 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\ADB4312\default.ini
3/21/2012 9:00:52 AM PreferenceSet.Load OK
3/21/2012 9:00:52 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\ADB4312\user.prefs
3/21/2012 9:00:52 AM PreferenceSet.Load OK
3/21/2012 9:00:52 AM InitPreferences end
3/21/2012 9:00:52 AM SortPreferenceSets
3/21/2012 9:00:52 AM - Default ADB4312
3/21/2012 9:00:52 AM - System Default
3/21/2012 9:00:52 AM DoUpdateChildList
3/21/2012 9:00:52 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
3/21/2012 9:00:52 AM ReadString OK
3/21/2012 9:00:52 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\PLSQLDev.exe" "%1"
3/21/2012 9:00:52 AM LoadPreferences
3/21/2012 9:00:52 AM LoadPreferences searching for default
3/21/2012 9:00:52 AM C:\Program Files\PLSQL Developer\Preferences\ADB4312\default.ini
3/21/2012 9:00:52 AM LoadPreferences NewPref := nil
3/21/2012 9:00:52 AM LoadPreferences
3/21/2012 9:00:52 AM LoadPreferences Reading preferences
3/21/2012 9:00:52 AM LoadPreferences ReadPosition
3/21/2012 9:00:52 AM LoadPreferences ToolsBrowserItemClick(nil)
3/21/2012 9:00:52 AM LoadPreferences CreateBrowserFilters...
3/21/2012 9:00:52 AM LoadPreferences Files
3/21/2012 9:00:52 AM LoadPreferences Buttons
3/21/2012 9:00:52 AM LoadPreferences Printer
3/21/2012 9:00:52 AM LoadPreferences FileBrowserFolders
3/21/2012 9:00:52 AM LoadPreferences Connections
3/21/2012 9:00:52 AM LoadPreferences BrowserFolders
3/21/2012 9:00:52 AM LoadPreferences
3/21/2012 9:00:52 AM LoadPreferences end
3/21/2012 9:00:52 AM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\ADB4312.lib
3/21/2012 9:00:52 AM Adding new connection
3/21/2012 9:00:52 AM Username = adb4312
3/21/2012 9:00:52 AM Database = EDWPRO
3/21/2012 9:00:52 AM Adding new connection
3/21/2012 9:00:52 AM Username = cr_sandbox
3/21/2012 9:00:52 AM Database = EDWPRO
3/21/2012 9:01:02 AM TOracleSession $02EFE930 Start Session.LogOn as adb4312@EDWPRO
3/21/2012 9:01:02 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/21/2012 9:01:02 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleSession $02EFE930 End
Duration = 0.141
3/21/2012 9:01:02 AM TOracleQuery $02EA60C0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
3/21/2012 9:01:02 AM TOracleQuery $02EA60C0 End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleSession $02EFEBD0 Start Session.LogOn as adb4312@EDWPRO
3/21/2012 9:01:02 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/21/2012 9:01:02 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleSession $02EFEBD0 End
Duration = 0.094
3/21/2012 9:01:02 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/21/2012 9:01:02 AM TOracleQuery Query End (5 records processed)
Duration = 0.015
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 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)
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleQuery $02EA6220 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 = ADB4312
3/21/2012 9:01:02 AM TOracleQuery $02EA6220 End (0 records processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleQuery $02EA6220 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from sys.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 = ADB4312
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 End
Result = ORA-00942: table or view does not exist
Duration = 0
3/21/2012 9:01:02 AM LogonHistorySave start
3/21/2012 9:01:02 AM ChangeUserPref LogonHistory,
3/21/2012 9:01:02 AM ChangeUserPref DSA,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref ColumnAssociations,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref ImportAssociations,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref BrowserFilters,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref FileBrowserFolders,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref Connections,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref BrowserFolders,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref SessionQueries,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref ExternalTools,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref Documents,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref Reports,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM ChangeUserPref CurrentConnections,
3/21/2012 9:01:02 AM ChangeUserPref end
3/21/2012 9:01:02 AM PreferenceSet.Save
3/21/2012 9:01:02 AM PreferenceSet Filename = C:\Program Files\PLSQL Developer\Preferences\ADB4312\user.prefs
3/21/2012 9:01:02 AM PreferenceSet AltFile = user.prefs
3/21/2012 9:01:02 AM PreferenceSet.Save end
3/21/2012 9:01:02 AM LogonHistorySave end
3/21/2012 9:01:02 AM FormCreate Logon.Executed -1
3/21/2012 9:01:02 AM FormCreate SessionChanged
3/21/2012 9:01:02 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/21/2012 9:01:02 AM TOracleQuery Query End (5 records processed)
Duration = 0.015
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM SessionChanged SetDBAViews
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 End (0 records processed)
Duration = 0.016
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/21/2012 9:01:02 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 End
Result = ORA-00942: table or view does not exist
Duration = 0.015
3/21/2012 9:01:02 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End (5 records processed)
Duration = 0.282
3/21/2012 9:01:03 AM SessionChanged Authorizations.Load
3/21/2012 9:01:03 AM SessionChanged EnableAuthorizedMenus
3/21/2012 9:01:03 AM WindowAllowed(1)
3/21/2012 9:01:03 AM WindowAllowed done
3/21/2012 9:01:03 AM WindowAllowed(1)
3/21/2012 9:01:03 AM WindowAllowed done
3/21/2012 9:01:03 AM ExecuteConnectScript starts
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:03 AM ExecuteConnectScript ends
3/21/2012 9:01:03 AM SetSessionAction starts: Primary Session
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from dual
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End (1 record processed)
Duration = 0
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:03 AM SetSessionAction ends
3/21/2012 9:01:03 AM SessionChanged LoadRecentObjects
3/21/2012 9:01:03 AM SessionChanged Notify children
3/21/2012 9:01:03 AM SessionChanged Logoff secondary sessions
3/21/2012 9:01:03 AM SessionChanged EnableChildFunctions
3/21/2012 9:01:03 AM SessionChanged
OCIDLL forced to C:\oracle\ora102\bin\oci.dll
3/21/2012 9:01:03 AM Lock
3/21/2012 9:01:03 AM UnLock
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.766
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.015
3/21/2012 9:01:03 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:03 AM SortPreferenceSets
3/21/2012 9:01:03 AM - Default ADB4312
3/21/2012 9:01:03 AM - System Default
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End (0 records processed)
Duration = 0.015
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/21/2012 9:01:03 AM TOracleQuery $02EA5E00 End
Result = ORA-00942: table or view does not exist
Duration = 0
3/21/2012 9:01:03 AM Lock
3/21/2012 9:01:03 AM UnLock
3/21/2012 9:01:03 AM DoUpdateChildList
3/21/2012 9:01:03 AM FormActivate start
3/21/2012 9:01:04 AM FormActivate end
3/21/2012 9:01:04 AM WMUpdatePopups starts
3/21/2012 9:01:04 AM Adding new connection
3/21/2012 9:01:04 AM Username = adb4312
3/21/2012 9:01:04 AM Database = EDWPRO
3/21/2012 9:01:04 AM Adding new connection
3/21/2012 9:01:04 AM Username = cr_sandbox
3/21/2012 9:01:04 AM Database = EDWPRO
3/21/2012 9:01:04 AM LoadDesktop starts
3/21/2012 9:01:04 AM DoUpdateChildList
3/21/2012 9:01:04 AM Lock
3/21/2012 9:01:04 AM Lock
3/21/2012 9:01:04 AM UnLock
3/21/2012 9:01:04 AM UnLock
3/21/2012 9:01:04 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/21/2012 9:01:04 AM TOracleQuery Query End (5 records processed)
Duration = 0
3/21/2012 9:01:04 AM SessionChanged SetDBAViews
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End (0 records processed)
Duration = 0
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End
Result = ORA-00942: table or view does not exist
Duration = 0.015
3/21/2012 9:01:04 AM SessionChanged Authorizations.Load
3/21/2012 9:01:04 AM SessionChanged ApplyPreferences
3/21/2012 9:01:04 AM SortPreferenceSets
3/21/2012 9:01:04 AM - Default ADB4312
3/21/2012 9:01:04 AM - System Default
3/21/2012 9:01:04 AM SessionChanged EnableAuthorizedMenus
3/21/2012 9:01:04 AM WindowAllowed(1)
3/21/2012 9:01:04 AM WindowAllowed done
3/21/2012 9:01:04 AM WindowAllowed(1)
3/21/2012 9:01:04 AM WindowAllowed done
3/21/2012 9:01:04 AM ExecuteConnectScript starts
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:04 AM ExecuteConnectScript ends
3/21/2012 9:01:04 AM SetSessionAction starts: Primary Session
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = select null from dual
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End (1 record processed)
Duration = 0
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
3/21/2012 9:01:04 AM TOracleQuery $02EA5E00 End
Duration = 0
3/21/2012 9:01:04 AM SetSessionAction ends
3/21/2012 9:01:04 AM SessionChanged LoadRecentObjects
3/21/2012 9:01:04 AM SessionChanged Notify children
3/21/2012 9:01:04 AM SessionChanged Logoff secondary sessions
3/21/2012 9:01:04 AM SessionChanged EnableChildFunctions
3/21/2012 9:01:04 AM SessionChanged
OCIDLL forced to C:\oracle\ora102\bin\oci.dll
3/21/2012 9:01:04 AM Lock
3/21/2012 9:01:04 AM UnLock
3/21/2012 9:01:04 AM LoadDesktop ends
3/21/2012 9:01:04 AM WMUpdatePopups ends
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 2.36
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.64
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.079
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.171
3/21/2012 9:01:06 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:09 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 2.094
3/21/2012 9:01:09 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:09 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.547
3/21/2012 9:01:09 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 1.188
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.078
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.015
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 End (100 records processed)
Duration = 0.016
3/21/2012 9:01:10 AM TOracleQuery $02EA6220 Start Query.Next for up to 100 records
3/21/2012 9:01:11 AM TOracleQuery $02EA6220 End (89 records processed)
Duration = 0.516
3/21/2012 9:01:11 AM TOracleQuery $02EA6220 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 = ADB4312
3/21/2012 9:01:11 AM TOracleQuery $02EA6220 End (13 records processed)
Duration = 0.015
3/21/2012 9:01:11 AM TOracleSession $02EFEBD0 Start Session.LogOff
3/21/2012 9:01:11 AM TOracleSession $02EFEBD0 End
Duration = 0
3/21/2012 9:01:12 AM Create TSQLForm Start
3/21/2012 9:01:12 AM Create TSQLForm Inherited
3/21/2012 9:01:12 AM TSQLForm.FormCreate Start
3/21/2012 9:01:12 AM Lock
3/21/2012 9:01:12 AM UnLock
3/21/2012 9:01:12 AM SQLForm
3/21/2012 9:01:12 AM TSQLForm.FormCreate Finished
3/21/2012 9:01:12 AM Create TSQLForm SetupMainFont
3/21/2012 9:01:12 AM Create TSQLForm Activate
3/21/2012 9:01:12 AM UpdateChildList [timer]
3/21/2012 9:01:12 AM Create TSQLForm Activate done
3/21/2012 9:01:12 AM Create TSQLForm UpdateWindowList
3/21/2012 9:01:12 AM UpdateChildList [timer]
3/21/2012 9:01:12 AM Create TSQLForm Positioning
3/21/2012 9:01:12 AM Create TSQLForm Finished
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM FileAge: Q:\D943\F11701\SECURED\PHI\Analytic Team Folder\Automated Reports\PlanCompass Commercial\Step 1 code.sql = 8:59:44 PM
3/21/2012 9:01:13 AM SQLForm
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM NavigationBookmarks.EnableButtons(Rebuild)
3/21/2012 9:01:13 AM NavigationBookmarks: Backward=0, Forward=0
3/21/2012 9:01:13 AM CheckFileDate WindowFileDate = 8:59:44 PM
3/21/2012 9:01:13 AM FileAge: Q:\D943\F11701\SECURED\PHI\Analytic Team Folder\Automated Reports\PlanCompass Commercial\Step 1 code.sql = 8:59:44 PM
3/21/2012 9:01:13 AM DoUpdateChildList
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM Lock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:13 AM UnLock
3/21/2012 9:01:17 AM SQLForm Initializing...
3/21/2012 9:01:17 AM SetConnected starts
3/21/2012 9:01:17 AM SetConnected: Connect starts
3/21/2012 9:01:17 AM TOracleSession $02F01870 Start Session.LogOn as adb4312@EDWPRO
3/21/2012 9:01:17 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/21/2012 9:01:17 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/21/2012 9:01:17 AM TOracleSession $02F01870 End
Duration = 0.094
3/21/2012 9:01:17 AM SetConnected: (Dis)connect ends
3/21/2012 9:01:17 AM SetSessionAction starts: SQL Window - Step 1 code.sql
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Execute
SQL = select null from dual
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End (1 record processed)
Duration = 0
3/21/2012 9:01:17 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/21/2012 9:01:17 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/21/2012 9:01:17 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/21/2012 9:01:17 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - Step 1 code.sql
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End
Duration = 0
3/21/2012 9:01:17 AM SetSessionAction ends
3/21/2012 9:01:17 AM ExecuteConnectScript starts
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End
Duration = 0
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End
Duration = 0
3/21/2012 9:01:17 AM ExecuteConnectScript ends
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End (1 record processed)
Duration = 0.016
3/21/2012 9:01:17 AM EnableOutput starts
3/21/2012 9:01:17 AM TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enablesize);
end if;
end;
:ENABLE = 1
:SIZE = 10000
3/21/2012 9:01:17 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
3/21/2012 9:01:17 AM EnableOutput done
3/21/2012 9:01:17 AM InitStatistics starts
3/21/2012 9:01:17 AM TStatistics.Init starts
3/21/2012 9:01:17 AM InitStatNames starts
3/21/2012 9:01:17 AM select name from v$statname order by statistic#
3/21/2012 9:01:17 AM TOracleQuery $02EA59E0 Start Query.Execute
SQL = select name from v$statname order by statistic#
3/21/2012 9:01:17 AM TOracleQuery $02EA59E0 End (371 records processed)
Duration = 0
3/21/2012 9:01:17 AM 371 statistics found
3/21/2012 9:01:17 AM StatQuery.ReadBuffer = 372
3/21/2012 9:01:17 AM InitStatNames ends
3/21/2012 9:01:17 AM StatQuery.Describe starts
3/21/2012 9:01:17 AM TOracleQuery $02E68970 Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
3/21/2012 9:01:17 AM TOracleQuery $02E68970 End
Duration = 0.016
3/21/2012 9:01:17 AM StatQuery.Describe ends
3/21/2012 9:01:17 AM TStatistics.Init ends
3/21/2012 9:01:17 AM InitStatistics ends
3/21/2012 9:01:17 AM CreateQueryTabs starts
3/21/2012 9:01:20 AM GotoQueryTab 0
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChanging
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChange
3/21/2012 9:01:20 AM GotoQueryTab done
3/21/2012 9:01:20 AM GotoQueryTab 0
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChanging
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChange
3/21/2012 9:01:20 AM GotoQueryTab done
3/21/2012 9:01:20 AM CreateQueryTabs ends
3/21/2012 9:01:20 AM SQLForm
3/21/2012 9:01:20 AM GotoQueryTab 0
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChanging
3/21/2012 9:01:20 AM GotoQueryTab: QueryTabControlChange
3/21/2012 9:01:20 AM GotoQueryTab done
3/21/2012 9:01:20 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
3/21/2012 9:01:20 AM TOracleQuery Query End
Duration = 0
3/21/2012 9:01:23 AM CheckFileDate WindowFileDate = 8:59:44 PM
3/21/2012 9:01:23 AM FileAge: Q:\D943\F11701\SECURED\PHI\Analytic Team Folder\Automated Reports\PlanCompass Commercial\Step 1 code.sql = 8:59:44 PM
3/21/2012 9:01:23 AM NavigationBookmarks.EnableButtons(Rebuild)
3/21/2012 9:01:23 AM NavigationBookmarks: Backward=0, Forward=0
3/21/2012 9:04:37 AM CheckFileDate WindowFileDate = 8:59:44 PM
3/21/2012 9:04:37 AM FileAge: Q:\D943\F11701\SECURED\PHI\Analytic Team Folder\Automated Reports\PlanCompass Commercial\Step 1 code.sql = 8:59:44 PM
3/21/2012 9:04:37 AM NavigationBookmarks.EnableButtons(Rebuild)
3/21/2012 9:04:37 AM NavigationBookmarks: Backward=0, Forward=0

 

[Marco Kalter]

Can you update to the current 9.0.6 version and try the same?

 

[singularity]

Unfortunately, we're at the mercy of our IT department, and 9.0.2 is the latest version they have certified at the moment. We do have people running versions 7 and 8, who are not having this issue.