PLSQL Developer hangs selecting fields on result table

[Svetj]

Hi,
After executing a query on a sql window,
I need to select and copy some fields from result.
But since some days when I select a field,
or I try to order the results by a field,
the program hangs.
I can't know if something has changed on server side, but the problem is present only with some servers: 8.6.0.0 and 8.7.0.0.
With 8.7.4.0 and above there are no problems.

Trying with plsql developer 6 all works fine.

Below there are some information.
Thank you

----INFO
PL/SQL Developer
Version 7.0.3.1114 (MBCS)
18253.6320 - Unlimited user license
Windows XP version 6,0 (build 2600) Service Pack 2

Physical memory : 777.712 kB (165.328 available)
Paging file : 2.832.412 kB (2.063.772 available)
Virtual memory : 2.097.024 kB (2.001.516 available)

Parameters
C:\Programmi\PLSQL Developer\PLSQLDev.exe

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

Preference Files
C:\Programmi\PLSQL Developer\Preferences\Default\Default.ini
C:\Programmi\PLSQL Developer\Preferences\svetj\default.ini

Plug-Ins
*PL/SQL Developer CompareSource Plug-In version 2003/12/03 (C:\Programmi\PLSQL Developer\PlugIns\CompareSource.dll)
*PL/SQL Documentation (plsqldoc) (C:\Programmi\PLSQL Developer\PlugIns\plsqldoc.dll)
*texType (2.1) - www.softema.com (C:\Programmi\PLSQL Developer\PlugIns\texType.dll)
*TNSEditor Plugin (C:\Programmi\PLSQL Developer\PlugIns\TNSEditorPlugin.dll)
(* is Active)

Aliases
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle8i Enterprise Edition Release 8.1.6.0.0
Character size: 1 byte(s)

---- Registry

PL/SQL Developer
Version 7.0.3.1114 (MBCS)
18253.6320 - Unlimited user license
Windows XP version 6,0 (build 2600) Service Pack 2

Physical memory : 777.712 kB (165.328 available)
Paging file : 2.832.412 kB (2.063.772 available)
Virtual memory : 2.097.024 kB (2.001.516 available)

Parameters
C:\Programmi\PLSQL Developer\PLSQLDev.exe

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

Preference Files
C:\Programmi\PLSQL Developer\Preferences\Default\Default.ini
C:\Programmi\PLSQL Developer\Preferences\svetj\default.ini

Plug-Ins
*PL/SQL Developer CompareSource Plug-In version 2003/12/03 (C:\Programmi\PLSQL Developer\PlugIns\CompareSource.dll)
*PL/SQL Documentation (plsqldoc) (C:\Programmi\PLSQL Developer\PlugIns\plsqldoc.dll)
*texType (2.1) - www.softema.com (C:\Programmi\PLSQL Developer\PlugIns\texType.dll)
*TNSEditor Plugin (C:\Programmi\PLSQL Developer\PlugIns\TNSEditorPlugin.dll)
(* is Active)

Aliases
AT_SIEBEL_PROD
BE_SIEBEL_PROD
CH_SIEBEL_PROD
CHANGE_ME
CH-GENEVA
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle8i Enterprise Edition Release 8.1.6.0.0
Character size: 1 byte(s)

-----Debug.txt
PL/SQL Developer 7.0.3.1114 18253.6320 - Unlimited user license
C:\Programmi\PLSQL Developer\plsqldev.exe

12/09/2006 12.20.26 Application started
12/09/2006 12.20.26 InitPreferences
12/09/2006 12.20.26 Load C:\Programmi\PLSQL Developer\Preferences\Default = 0
12/09/2006 12.20.26 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\Default\Default.ini
12/09/2006 12.20.26 PreferenceSet.Load OK
12/09/2006 12.20.26 Load C:\Programmi\PLSQL Developer\Preferences\svetj = 0
12/09/2006 12.20.26 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\svetj\default.ini
12/09/2006 12.20.26 PreferenceSet.Load OK
12/09/2006 12.20.26 PreferenceSet.Load C:\Programmi\PLSQL Developer\Preferences\svetj\user.prefs
12/09/2006 12.20.26 PreferenceSet.Load OK
12/09/2006 12.20.26 InitPreferences end
12/09/2006 12.20.27 SortPreferenceSets
12/09/2006 12.20.27 - Default svetj
12/09/2006 12.20.27 - System Default
12/09/2006 12.20.27 LoadPreferences
12/09/2006 12.20.27 LoadPreferences searching for default
12/09/2006 12.20.27 C:\Programmi\PLSQL Developer\Preferences\svetj\default.ini
12/09/2006 12.20.27 LoadPreferences end
12/09/2006 12.20.27 FormCreate Logon.Execute
12/09/2006 12.20.35 TOracleSession PLSQLDevForm.Session Start Session.LogOn as user@PROD
12/09/2006 12.20.35 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/09/2006 12.20.35 TOracleQuery Query End (1 record processed)
Duration = 0
12/09/2006 12.20.35 TOracleSession PLSQLDevForm.Session End
Duration = 0,156
12/09/2006 12.20.35 LogonHistorySave start
12/09/2006 12.20.35 ChangeUserPref LogonHistory,
12/09/2006 12.20.36 ChangeUserPref DSA,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref ColumnAssociations,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref ImportAssociations,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref BrowserFilters,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref BrowserFolders,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref SessionQueries,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref ExternalTools,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref Documents,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 ChangeUserPref Reports,
12/09/2006 12.20.36 ChangeUserPref end
12/09/2006 12.20.36 LogonHistorySave end
12/09/2006 12.20.36 FormCreate Session.Connected
12/09/2006 12.20.36 FormCreate Logon.Executed -1
12/09/2006 12.20.36 FormCreate TDBNames.Make
12/09/2006 12.20.36 FormCreate SessionChanged
12/09/2006 12.20.36 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
12/09/2006 12.20.36 TOracleQuery Query End (5 records processed)
Duration = 0
12/09/2006 12.20.36 SessionChanged SetDBAViews
12/09/2006 12.20.36 SessionChanged Authorizations.Load
12/09/2006 12.20.36 TOracleQuery $02674040 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)
12/09/2006 12.20.36 TOracleQuery $02674040 End
Result = ORA-00942: table or view does not exist
Duration = 0,157
12/09/2006 12.20.36 SessionChanged EnableAuthorizedMenus
12/09/2006 12.20.36 TOracleSession $019153E0 Start Session.LogOn as siebel_int@uk_SIEBEL_PROD
12/09/2006 12.20.36 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/09/2006 12.20.36 TOracleQuery Query End (1 record processed)
Duration = 0
12/09/2006 12.20.36 TOracleSession $019153E0 End
Duration = 0,062
12/09/2006 12.20.36 SetSessionAction starts: Main session
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
12/09/2006 12.20.36 TOracleQuery $026741A0 Start Query.Execute
SQL = select null from dual
12/09/2006 12.20.36 TOracleQuery $026741A0 End (1 record processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $026741A0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
12/09/2006 12.20.36 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
12/09/2006 12.20.36 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,031
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,016
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,016
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (60 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
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')
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,047
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery BytesPerCharacterQuery End
Result = ORA-00904: invalid column name
Duration = 0,125
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,016
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $026741A0 End
Duration = 0,141
12/09/2006 12.20.36 SetSessionAction ends
12/09/2006 12.20.36 ExecuteConnectScript starts
12/09/2006 12.20.36 ExecuteConnectScript ends
12/09/2006 12.20.36 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
12/09/2006 12.20.36 TOracleQuery PLSQLDevForm.DynamicQuery End (0 records processed)
Duration = 0,015
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,015
12/09/2006 12.20.36 SessionChanged LoadRecentObjects
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 SessionChanged Notify children
12/09/2006 12.20.36 SessionChanged Logoff secondary sessions
12/09/2006 12.20.36 SessionChanged SessionMode = smMulti
12/09/2006 12.20.36 SessionChanged EnableChildFunctions
12/09/2006 12.20.36 Toolbar.NavDisable
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,062
12/09/2006 12.20.36 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\oracle\ora92
Found: oci.dll
Using: C:\oracle\ora92\bin\oci.dll
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,031
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,016
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,015
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,016
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (100 records processed)
Duration = 0,015
12/09/2006 12.20.36 Toolbar.NavDisable
12/09/2006 12.20.36 TOracleQuery $02673EE0 Start Query.Next for up to 100 records
12/09/2006 12.20.36 TOracleQuery $02673EE0 End (33 records processed)
Duration = 0
12/09/2006 12.20.37 TOracleSession $019153E0 Start Session.LogOff
12/09/2006 12.20.37 SortPreferenceSets
12/09/2006 12.20.37 - Default svetj
12/09/2006 12.20.37 TOracleSession $019153E0 End
Duration = 0
12/09/2006 12.20.37 - System Default
12/09/2006 12.20.37 Toolbar.NavDisable
12/09/2006 12.20.37 Toolbar.NavDisable
12/09/2006 12.20.37 WMUpdatePopups starts
12/09/2006 12.20.37 GetCrashList: 2034542.cfg
12/09/2006 12.20.37 LoadDesktop starts
12/09/2006 12.20.37 LoadDesktop ends
12/09/2006 12.20.37 WMUpdatePopups ends
12/09/2006 12.21.03 Create TSQLForm
12/09/2006 12.21.03 SQLForm
12/09/2006 12.21.03 NavigationBookmarks.EnableButtons(Rebuild)
12/09/2006 12.21.03 NavigationBookmarks: Backward=0, Forward=0
12/09/2006 12.21.17 SQLForm Initializing...
12/09/2006 12.21.17 SetConnected starts
12/09/2006 12.21.17 SetConnected: Connect starts
12/09/2006 12.21.17 TOracleSession $01915BC0 Start Session.LogOn as user@PROD
12/09/2006 12.21.17 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
12/09/2006 12.21.17 TOracleQuery Query End (1 record processed)
Duration = 0
12/09/2006 12.21.17 TOracleSession $01915BC0 End
Duration = 0,063
12/09/2006 12.21.17 SetConnected: (Dis)connect ends
12/09/2006 12.21.17 SetSessionAction starts: SQL Window - New
12/09/2006 12.21.17 TOracleQuery $02674720 Start Query.Execute
SQL = select null from dual
12/09/2006 12.21.17 TOracleQuery $02674720 End (1 record processed)
Duration = 0
12/09/2006 12.21.17 TOracleQuery $02674720 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
12/09/2006 12.21.17 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
12/09/2006 12.21.17 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
12/09/2006 12.21.17 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
12/09/2006 12.21.18 TOracleQuery BytesPerCharacterQuery End
Result = ORA-00904: invalid column name
Duration = 0,172
12/09/2006 12.21.18 TOracleQuery $02674720 End
Duration = 0,172
12/09/2006 12.21.18 SetSessionAction ends
12/09/2006 12.21.18 ExecuteConnectScript starts
12/09/2006 12.21.18 ExecuteConnectScript ends
12/09/2006 12.21.18 TOracleQuery $02674720 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
12/09/2006 12.21.18 TOracleQuery $02674720 End (1 record processed)
Duration = 0,016
12/09/2006 12.21.18 EnableOutput starts
12/09/2006 12.21.18 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 = 10000000
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
12/09/2006 12.21.18 EnableOutput done
12/09/2006 12.21.18 InitStatistics starts
12/09/2006 12.21.18 TStatistics.Init starts
12/09/2006 12.21.18 InitStatNames starts
12/09/2006 12.21.18 select name from v$statname order by statistic#
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,016
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0,016
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
12/09/2006 12.21.18 InitStatNames ends
12/09/2006 12.21.18 StatQuery.Describe starts
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0
12/09/2006 12.21.18 StatQuery.Describe ends
12/09/2006 12.21.18 TStatistics.Init ends
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 157
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery End (226 records processed)
Duration = 0
12/09/2006 12.21.18 InitStatistics ends
12/09/2006 12.21.18 NavigationBookmarks.EnableButtons(Rebuild)
12/09/2006 12.21.18 NavigationBookmarks: Backward=0, Forward=0
12/09/2006 12.21.18 SQLForm Executing...
12/09/2006 12.21.18 SQLForm Executing...
12/09/2006 12.21.18 TSQLThread SQLThread.Execute
12/09/2006 12.21.18 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
12/09/2006 12.21.18 TOracleQuery Query End
Duration = 0
12/09/2006 12.21.18 TOracleQuery $026749E0 Start Query.Execute
SQL = SELECT SYSDATE FROM dual
12/09/2006 12.21.18 TOracleQuery $026749E0 End (1 record processed)
Duration = 0
12/09/2006 12.21.18 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM dual
12/09/2006 12.21.18 TOracleQuery SQLForm.TestQuery End
Duration = 0,015
12/09/2006 12.21.18 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
12/09/2006 12.21.18 TOracleQuery Query End
Duration = 0
12/09/2006 12.21.18 TSQLThread SQLThread Postmessage
12/09/2006 12.21.18 TSQLForm.ThreadFinished
12/09/2006 12.21.18 TSQLThread SQLThread Suspend
12/09/2006 12.21.18 TSQLForm.ThreadFinished: SQLThread.Suspended
12/09/2006 12.21.18 SQLForm 1 row selected in 0,046 seconds
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 157
12/09/2006 12.21.18 TOracleQuery PLSQLDevForm.StatQuery End (226 records processed)
Duration = 0
12/09/2006 12.21.18 NavigationBookmarks.EnableButtons(Rebuild)
12/09/2006 12.21.18 NavigationBookmarks: Backward=0, Forward=0
12/09/2006 12.21.18 TOracleQuery $02674880 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
12/09/2006 12.21.18 TOracleQuery $02674880 End
Duration = 0
12/09/2006 12.21.18 SQLForm 1 row selected in 0,046 seconds
12/09/2006 12.21.26 TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare

t_owner varchar2(30);
t_name varchar2(30);

procedure check_mview is
dummy integer;
begin
if bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner = bject_owner
and object_name = bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;

begin
:sub_object := null;
if :deep != 0 then
begin
if art2 is null then
select constraint_type, owner, constraint_name
into bject_type, bject_owner, bject_name
from sys.all_constraints c
where c.constraint_name = art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name, art3
into bject_type, bject_owner, bject_name, :sub_object
from sys.all_constraints c
where c.constraint_name = art2 and c.owner = art1
and rownum = 1;
end if;
if bject_type = 'P' then bject_type := 'PRIMARY KEY'; end if;
if bject_type = 'U' then bject_type := 'UNIQUE KEY'; end if;
if bject_type = 'R' then bject_type := 'FOREIGN KEY'; end if;
if bject_type = 'C' then bject_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object := art2;
if part2 is null) or part1 != user) then
begin
select object_type, user, art1
into bject_type, bject_owner, bject_name
from sys.all_objects
where owner = user
and object_name = art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if bject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := art2;
if art3 is not null then
:sub_object := :sub_object || '.' || art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := art3;
begin
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = art1
and o.object_name = art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null
then
select 'USER', null, art1
into bject_type, bject_owner, bject_name
from sys.all_users u
where u.username = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null and :deep != 0
then
select 'ROLE', null, art1
into bject_type, bject_owner, bject_name
from sys.session_roles r
where r.role = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;
ART1 = DUAL
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
ART2 =
:SUB_OBJECT = Null
ART3 =
EEP = 0

 

[Marco Kalter]

This indicates an dictionary performance issue. The last PL/SQL Block execution simply takes a very long time, and it just contains a few dictionary queries. Perhaps your DBA can verify which statement is running when it hangs, and why it is so slow?

 

[Svetj]

Checking the session with another plsql developer, the sql text is:

declare

t_owner varchar2(30);
t_name varchar2(30);

procedure check_mview is
dummy integer;
begin
if bject_type = 'TABLE' then
select 1 into dummy
from sys.all_objects
where owner = bject_owner
and object_name = bject_name
and object_type = 'MATERIALIZED VIEW'
and rownum = 1;
bject_type := 'MATERIALIZED VIEW';
end if;
exception
when others then null;
end;

begin
:sub_object := null;
if :deep != 0 then
begin
if art2 is null then
select constraint_type, owner, constraint_name
into bject_type, bject_owner, bject_name
from sys.all_constraints c
where c.constraint_name = art1 and c.owner = user
and rownum = 1;
else
select constraint_type, owner, constraint_name, art3
into bject_type, bject_owner, bject_name, :sub_object
from sys.all_constraints c
where c.constraint_name = art2 and c.owner = art1
and rownum = 1;
end if;
if bject_type = 'P' then bject_type := 'PRIMARY KEY'; end if;
if bject_type = 'U' then bject_type := 'UNIQUE KEY'; end if;
if bject_type = 'R' then bject_type := 'FOREIGN KEY'; end if;
if bject_type = 'C' then bject_type := 'CHECK CONSTRAINT'; end if;
return;
exception
when no_data_found then null;
end;
end if;
:sub_object := art2;
if part2 is null) or part1 != user) then
begin
select object_type, user, art1
into bject_type, bject_owner, bject_name
from sys.all_objects
where owner = user
and object_name = art1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if bject_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = art1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := art2;
if art3 is not null then
:sub_object := :sub_object || '.' || art3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = art1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := art3;
begin
select o.object_type, o.owner, o.object_name
into bject_type, bject_owner, bject_name
from sys.all_objects o
where o.owner = art1
and o.object_name = art2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null
then
select 'USER', null, art1
into bject_type, bject_owner, bject_name
from sys.all_users u
where u.username = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
begin
if art2 is null and art3 is null and :deep != 0
then
select 'ROLE', null, art1
into bject_type, bject_owner, bject_name
from sys.session_roles r
where r.role = art1
and rownum = 1;
return;
end if;
exception
when no_data_found then null;
end;
bject_owner := null;
bject_type := null;
bject_name := null;
:sub_object := null;
end;

I executed all the queries without any problem:
how can I execute the entire procedure?
In this way I should be able to see where is the problem...
Thank you very much
Regards
Stefano

 

[Svetj]

Just another question:
does exist any difference between the procedure executed by plsql developer version 6 and 7?

 

[Marco Kalter]

I think the check_mview subprogram is new in 7.0.

 

[Marco Kalter]

how can I execute the entire procedure?
In this way I should be able to see where is the problem...

Just copy the text into a Test Window, right-click on the Variables grid and select "Scan variables", enter DUAL in the PART1 variable and 0 in the DEEP variable. Save the script and press Execute.

 

[Svetj]

Sorry for the delay.
I executed the procedure without any problem.
Otherwise I made some other tests,
with other computers:
someone has the same problem.
somebody else nothing..
It's very strange.
Have a nice weekend
Stefano