Oracle sessions - not closed

O

Ole Henrik Steinmo

Member
Hi,

I'm using PL/SQL Developer 7.1.2.1362 and I have noticed that PL/SQL dev does not always close the session when I'm logging off. The session remains inactive until I kills it.
We are running oracle 9.2.0.7.0.

After a while all the allowed processes will be occupied. Is this a bug in PL/SQL developer or could this be an error in the database?

We are using multi session connection by the way.
 
I'm not aware of any problem like this. Is this reproducible? If so, 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.
 
I have also a problem with log out and session remains active until i kill it.

We have 2 oracle installation 10.1 and 10.2.

It works ok on both installation since yesterday.
After a restart of the server's logout on 10.2 not
works.

Clicking on the 'Session log off' program never finish, i can only close the program.

I active the debug mod but i can see nothing wrong.

--------------
PL/SQL Developer
Version 7.1.4.1390
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1.047.764 kB (474.244 available)
Paging file : 2.519.064 kB (2.064.724 available)
Virtual memory : 2.097.024 kB (2.025.672 available)

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

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

Preference Files

Plug-Ins

25.11.2007 12:00:29 Application started
25.11.2007 12:00:29 InitPreferences
25.11.2007 12:00:29 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
25.11.2007 12:00:29 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
25.11.2007 12:00:29 PreferenceSet.Load OK
25.11.2007 12:00:29 Determine LocalPrefPath
25.11.2007 12:00:29 [1]: C:\Program Files\PLSQL Developer\Preferences
25.11.2007 12:00:29 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\karalb
25.11.2007 12:00:29 Load C:\Program Files\PLSQL Developer\Preferences\karalb = 0
25.11.2007 12:00:29 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\karalb\default.ini
25.11.2007 12:00:29 PreferenceSet.Load OK
25.11.2007 12:00:29 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\karalb\user.prefs
25.11.2007 12:00:29 PreferenceSet.Load OK
25.11.2007 12:00:29 InitPreferences end
25.11.2007 12:00:29 SortPreferenceSets
25.11.2007 12:00:29 - Default karalb
25.11.2007 12:00:29 - System Default
25.11.2007 12:00:29 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
25.11.2007 12:00:29 ReadString OK
25.11.2007 12:00:29 pfReadRegistry: "c:\program files\plsql developer\plsqldev.exe" "%1"
25.11.2007 12:00:29 LoadPreferences
25.11.2007 12:00:29 LoadPreferences searching for default
25.11.2007 12:00:29 C:\Program Files\PLSQL Developer\Preferences\karalb\default.ini
25.11.2007 12:00:29 LoadPreferences NewPref := nil
25.11.2007 12:00:29 LoadPreferences
25.11.2007 12:00:29 LoadPreferences Reading preferences
25.11.2007 12:00:29 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
25.11.2007 12:00:29 ReadString OK
25.11.2007 12:00:29 pfReadRegistry: "c:\program files\plsql developer\plsqldev.exe" "%1"
25.11.2007 12:00:29 LoadPreferences ReadPosition
25.11.2007 12:00:29 LoadPreferences ToolsBrowserItemClick(nil)
25.11.2007 12:00:29 LoadPreferences CreateBrowserFilters...
25.11.2007 12:00:29 LoadPreferences Files
25.11.2007 12:00:29 LoadPreferences Logon
25.11.2007 12:00:29 LoadPreferences Buttons
25.11.2007 12:00:29 LoadPreferences Printer
25.11.2007 12:00:29 LoadPreferences BrowserFolders
25.11.2007 12:00:29 LoadPreferences
25.11.2007 12:00:29 LoadPreferences end
25.11.2007 12:00:29 MacroLibFilename: C:\Documents and Settings\karalb\My Documents\PLSQL Developer\Macros\karalb.lib
25.11.2007 12:00:29 FormCreate Logon.Execute
25.11.2007 12:00:36 TOracleSession PLSQLDevForm.Session Start Session.LogOn as system@sbz01.daxtor.it
25.11.2007 12:00:37 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25.11.2007 12:00:37 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,156
25.11.2007 12:00:37 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
25.11.2007 12:00:37 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0,125
25.11.2007 12:00:37 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25.11.2007 12:00:37 TOracleQuery Query End (1 record processed)
Duration = 0,125
25.11.2007 12:00:37 TOracleSession PLSQLDevForm.Session End
Duration = 1,36
25.11.2007 12:00:37 LogonHistorySave start
25.11.2007 12:00:37 ChangeUserPref LogonHistory,
25.11.2007 12:00:37 ChangeUserPref DSA,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref ColumnAssociations,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref ImportAssociations,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref BrowserFilters,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref BrowserFolders,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref SessionQueries,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref ExternalTools,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref Documents,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 ChangeUserPref Reports,
25.11.2007 12:00:37 ChangeUserPref end
25.11.2007 12:00:37 LogonHistorySave end
25.11.2007 12:00:37 FormCreate Session.Connected
25.11.2007 12:00:37 FormCreate Logon.Executed -1
25.11.2007 12:00:37 FormCreate TDBNames.Make
25.11.2007 12:00:37 FormCreate SessionChanged
25.11.2007 12:00:37 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
25.11.2007 12:00:37 TOracleQuery Query End (5 records processed)
Duration = 0,141
25.11.2007 12:00:37 SessionChanged SetDBAViews
25.11.2007 12:00:37 TOracleQuery $02B008C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
25.11.2007 12:00:38 TOracleQuery $02B008C0 End (0 records processed)
Duration = 0,14
25.11.2007 12:00:38 TOracleQuery $02B008C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
25.11.2007 12:00:38 TOracleQuery $02B008C0 End (0 records processed)
Duration = 0,141
25.11.2007 12:00:38 SessionChanged Authorizations.Load
25.11.2007 12:00:38 TOracleQuery $02B00760 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.11.2007 12:00:38 TOracleQuery $02B00760 End
Result = ORA-00942: table or view does not exist
Duration = 0,14
25.11.2007 12:00:38 SessionChanged EnableAuthorizedMenus
25.11.2007 12:00:38 TOracleSession $016BF710 Start Session.LogOn as system@sbz01.daxtor.it
25.11.2007 12:00:39 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25.11.2007 12:00:39 TOracleQuery Query End (1 record processed)
Duration = 0,125
25.11.2007 12:00:39 TOracleSession $016BF710 End
Duration = 0,922
25.11.2007 12:00:39 SetSessionAction starts: Main session
25.11.2007 12:00:39 TOracleQuery $02B00A20 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')
25.11.2007 12:00:39 TOracleQuery $02B008C0 Start Query.Execute
SQL = select null from dual
25.11.2007 12:00:39 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,156
25.11.2007 12:00:39 TOracleQuery $02B008C0 End (1 record processed)
Duration = 0,156
25.11.2007 12:00:39 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:39 TOracleQuery $02B008C0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
25.11.2007 12:00:39 TOracleQuery $02B008C0 End
Duration = 0,078
25.11.2007 12:00:39 SetSessionAction ends
25.11.2007 12:00:39 ExecuteConnectScript starts
25.11.2007 12:00:39 ExecuteConnectScript ends
25.11.2007 12:00:39 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
25.11.2007 12:00:39 TOracleQuery $02B00A20 End (77 records processed)
Duration = 0,094
25.11.2007 12:00:39 TOracleQuery $02B00A20 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from 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')
25.11.2007 12:00:39 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0,125
25.11.2007 12:00:39 SessionChanged LoadRecentObjects
25.11.2007 12:00:39 SessionChanged Notify children
25.11.2007 12:00:39 SessionChanged Logoff secondary sessions
25.11.2007 12:00:39 SessionChanged SessionMode = smMulti
25.11.2007 12:00:39 SessionChanged EnableChildFunctions
25.11.2007 12:00:39 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\Oracle\product\10.1.0\Client_1
Found: oci.dll
Using: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
25.11.2007 12:00:39 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
25.11.2007 12:00:39 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,344
25.11.2007 12:00:39 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:39 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0,141
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,063
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,079
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,062
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,062
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:40 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:40 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,172
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,079
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,079
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:41 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,079
25.11.2007 12:00:41 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:42 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,36
25.11.2007 12:00:42 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:42 TOracleQuery $02B00A20 End (100 records processed)
Duration = 0,078
25.11.2007 12:00:42 TOracleQuery $02B00A20 Start Query.Next for up to 100 records
25.11.2007 12:00:43 SortPreferenceSets
25.11.2007 12:00:43 - Default karalb
25.11.2007 12:00:43 - System Default
25.11.2007 12:00:43 TOracleQuery $02B008C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
25.11.2007 12:00:43 TOracleQuery $02B008C0 End (0 records processed)
Duration = 0,125
25.11.2007 12:00:43 TOracleQuery $02B008C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
25.11.2007 12:00:44 TOracleQuery $02B008C0 End (0 records processed)
Duration = 0,125
25.11.2007 12:00:44 WMUpdatePopups starts
25.11.2007 12:00:44 LoadDesktop starts
25.11.2007 12:00:44 LoadDesktop ends
25.11.2007 12:00:44 WMUpdatePopups ends
25.11.2007 12:00:51 TOracleSession PLSQLDevForm.Session Start Session.LogOff
25.11.2007 12:00:51 TOracleSession PLSQLDevForm.Session End
Duration = 0,062
25.11.2007 12:00:51 SessionChanged SetDBAViews
25.11.2007 12:00:51 SessionChanged Authorizations.Load
25.11.2007 12:00:51 SessionChanged ApplyPreferences
25.11.2007 12:00:51 SortPreferenceSets
25.11.2007 12:00:51 - Default karalb
25.11.2007 12:00:51 - System Default
25.11.2007 12:00:51 SessionChanged EnableAuthorizedMenus

----------------

Karlheinz
 
Hi,

I have done som testing for regenerate the problem and it seems to me it could be a network problem. When I'm loosing the network connection oracle does not close the sessions. When I'm logging on again, oracle / PL/SQL developer will start a new session. Even though I have not closed down the sql windows or closed down PL/SQL developer.

I'm currently working on a project where the network unfortunately is not stable all the time.

I'm attaching the debug log, thanks for helping!

PL/SQL Developer 7.1.2.1362
C:\Program Files\PLSQL Developer\plsqldev.exe

25/11/2007 16:01:44 Application started
25/11/2007 16:01:44 InitPreferences
25/11/2007 16:01:44 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
25/11/2007 16:01:44 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
25/11/2007 16:01:44 PreferenceSet.Load OK
25/11/2007 16:01:44 Load C:\Documents and Settings\steinole.EU.000\Application Data\PLSQL Developer\Preferences\steinole = 0
25/11/2007 16:01:44 PreferenceSet.Load C:\Documents and Settings\steinole.EU.000\Application Data\PLSQL Developer\Preferences\steinole\default.ini
25/11/2007 16:01:44 PreferenceSet.Load OK
25/11/2007 16:01:44 PreferenceSet.Load C:\Documents and Settings\steinole.EU.000\Application Data\PLSQL Developer\Preferences\steinole\user.prefs
25/11/2007 16:01:44 PreferenceSet.Load OK
25/11/2007 16:01:44 InitPreferences end
25/11/2007 16:01:44 SortPreferenceSets
25/11/2007 16:01:44 - Default steinole
25/11/2007 16:01:44 - System Default
25/11/2007 16:01:44 LoadPreferences
25/11/2007 16:01:44 LoadPreferences searching for default
25/11/2007 16:01:44 C:\Documents and Settings\steinole.EU.000\Application Data\PLSQL Developer\Preferences\steinole\default.ini
25/11/2007 16:01:44 LoadPreferences NewPref := nil
25/11/2007 16:01:44 LoadPreferences
25/11/2007 16:01:44 LoadPreferences Reading preferences
25/11/2007 16:01:44 LoadPreferences ReadPosition
25/11/2007 16:01:44 LoadPreferences ToolsBrowserItemClick(nil)
25/11/2007 16:01:44 LoadPreferences CreateBrowserFilters...
25/11/2007 16:01:44 LoadPreferences Files
25/11/2007 16:01:44 LoadPreferences Logon
25/11/2007 16:01:44 LoadPreferences Buttons
25/11/2007 16:01:44 LoadPreferences Printer
25/11/2007 16:01:44 LoadPreferences BrowserFolders
25/11/2007 16:01:44 LoadPreferences
25/11/2007 16:01:44 LoadPreferences end
25/11/2007 16:01:44 FormCreate Logon.Execute
25/11/2007 16:01:48 TOracleSession PLSQLDevForm.Session Start Session.LogOn as eckernel_ectest@QG_TEST.QG.COM
25/11/2007 16:01:48 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25/11/2007 16:01:48 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
25/11/2007 16:01:48 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20000)), nchr(20) from dual
25/11/2007 16:01:48 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
25/11/2007 16:01:48 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25/11/2007 16:01:48 TOracleQuery Query End (1 record processed)
Duration = 0
25/11/2007 16:01:48 TOracleSession PLSQLDevForm.Session End
Duration = 0.156
25/11/2007 16:01:48 LogonHistorySave start
25/11/2007 16:01:48 ChangeUserPref LogonHistory,
25/11/2007 16:01:48 ChangeUserPref DSA,
25/11/2007 16:01:48 ChangeUserPref end
25/11/2007 16:01:48 ChangeUserPref ColumnAssociations,
25/11/2007 16:01:48 ChangeUserPref end
25/11/2007 16:01:48 ChangeUserPref ImportAssociations,
25/11/2007 16:01:48 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref BrowserFilters,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref BrowserFolders,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref SessionQueries,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref ExternalTools,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref Documents,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 ChangeUserPref Reports,
25/11/2007 16:01:49 ChangeUserPref end
25/11/2007 16:01:49 LogonHistorySave end
25/11/2007 16:01:49 FormCreate Session.Connected
25/11/2007 16:01:49 FormCreate Logon.Executed -1
25/11/2007 16:01:49 FormCreate TDBNames.Make
25/11/2007 16:01:49 FormCreate SessionChanged
25/11/2007 16:01:49 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
25/11/2007 16:01:49 TOracleQuery Query End (5 records processed)
Duration = 0
25/11/2007 16:01:49 SessionChanged SetDBAViews
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.016
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery End (2 records processed)
Duration = 0.016
25/11/2007 16:01:49 SessionChanged Authorizations.Load
25/11/2007 16:01:49 TOracleQuery $02CB18F0 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/11/2007 16:01:49 TOracleQuery $02CB18F0 End
Result = ORA-00942: table or view does not exist
Duration = 0
25/11/2007 16:01:49 SessionChanged EnableAuthorizedMenus
25/11/2007 16:01:49 TOracleSession $016FF1D0 Start Session.LogOn as eckernel_ectest@QG_TEST.QG.COM
25/11/2007 16:01:49 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25/11/2007 16:01:49 TOracleQuery Query End (1 record processed)
Duration = 0
25/11/2007 16:01:49 TOracleSession $016FF1D0 End
Duration = 0.063
25/11/2007 16:01:49 SetSessionAction starts: Main session
25/11/2007 16:01:49 TOracleQuery $02CB1A50 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')
25/11/2007 16:01:49 TOracleQuery $02CB1790 Start Query.Execute
SQL = select null from dual
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1790 End (1 record processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1790 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1790 End
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 SetSessionAction ends
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 ExecuteConnectScript starts
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 ExecuteConnectScript ends
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 SessionChanged LoadRecentObjects
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 SessionChanged Notify children
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 SessionChanged Logoff secondary sessions
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 SessionChanged SessionMode = smMulti
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 SessionChanged EnableChildFunctions
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 Toolbar.NavDisable
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\Oracle\product\10.1.0\Client_1
Found: oci.dll
Using: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 Toolbar.NavDisable
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 SortPreferenceSets
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 - Default steinole
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 - System Default
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:49 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:49 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.015
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 Toolbar.NavDisable
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 Toolbar.NavDisable
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 Toolbar.NavDisable
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 WMUpdatePopups starts
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 LoadDesktop starts
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 LoadDesktop ends
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 WMUpdatePopups ends
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.032
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:50 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:50 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (96 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 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')
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.171
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.015
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.016
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:51 TOracleQuery $02CB1A50 End (100 records processed)
Duration = 0.015
25/11/2007 16:01:51 TOracleQuery $02CB1A50 Start Query.Next for up to 100 records
25/11/2007 16:01:52 TOracleQuery $02CB1A50 End (67 records processed)
Duration = 0.094
25/11/2007 16:01:52 TOracleSession $016FF1D0 Start Session.LogOff
25/11/2007 16:01:52 TOracleSession $016FF1D0 End
Duration = 0
25/11/2007 16:01:54 Create TSQLForm Start
25/11/2007 16:01:54 Create TSQLForm Inherited
25/11/2007 16:01:54 TSQLForm.FormCreate Start
25/11/2007 16:01:54 SQLForm
25/11/2007 16:01:54 TSQLForm.FormCreate Finished
25/11/2007 16:01:54 Create TSQLForm SetupMainFont
25/11/2007 16:01:54 Create TSQLForm Activate
25/11/2007 16:01:54 Create TSQLForm Activate done
25/11/2007 16:01:54 Create TSQLForm UpdateWindowList
25/11/2007 16:01:54 Create TSQLForm Positioning
25/11/2007 16:01:54 Create TSQLForm Finished
25/11/2007 16:01:54 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:01:54 NavigationBookmarks: Backward=0, Forward=0
25/11/2007 16:01:59 SQLForm Initializing...
25/11/2007 16:01:59 SetConnected starts
25/11/2007 16:01:59 SetConnected: Connect starts
25/11/2007 16:01:59 TOracleSession $01701E70 Start Session.LogOn as eckernel_ectest@QG_TEST.QG.COM
25/11/2007 16:01:59 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25/11/2007 16:01:59 TOracleQuery Query End (1 record processed)
Duration = 0
25/11/2007 16:01:59 TOracleSession $01701E70 End
Duration = 0.094
25/11/2007 16:01:59 SetConnected: (Dis)connect ends
25/11/2007 16:01:59 SetSessionAction starts: SQL Window - New
25/11/2007 16:01:59 TOracleQuery $02CB10B0 Start Query.Execute
SQL = select null from dual
25/11/2007 16:01:59 TOracleQuery $02CB10B0 End (1 record processed)
Duration = 0
25/11/2007 16:01:59 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25/11/2007 16:01:59 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25/11/2007 16:01:59 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20000)), nchr(20) from dual
25/11/2007 16:01:59 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25/11/2007 16:01:59 TOracleQuery $02CB10B0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
25/11/2007 16:01:59 TOracleQuery $02CB10B0 End
Duration = 0.016
25/11/2007 16:01:59 SetSessionAction ends
25/11/2007 16:01:59 ExecuteConnectScript starts
25/11/2007 16:01:59 ExecuteConnectScript ends
25/11/2007 16:01:59 TOracleQuery $02CB10B0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
25/11/2007 16:01:59 TOracleQuery $02CB10B0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
25/11/2007 16:01:59 EnableOutput starts
25/11/2007 16:01:59 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 = 10000
25/11/2007 16:01:59 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
25/11/2007 16:01:59 EnableOutput done
25/11/2007 16:01:59 InitStatistics starts
25/11/2007 16:01:59 TStatistics.Init starts
25/11/2007 16:01:59 TStatistics.Init ends
25/11/2007 16:01:59 InitStatistics ends
25/11/2007 16:01:59 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:01:59 NavigationBookmarks: Backward=0, Forward=0
25/11/2007 16:01:59 SQLForm Executing...
25/11/2007 16:01:59 SQLForm Executing...
25/11/2007 16:01:59 TSQLThread SQLThread.Execute
25/11/2007 16:01:59 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
25/11/2007 16:01:59 TOracleQuery Query End
Duration = 0
25/11/2007 16:01:59 TOracleQuery $02CB1370 Start Query.Execute
SQL = select * from dual
25/11/2007 16:02:00 TOracleQuery $02CB1370 End (1 record processed)
Duration = 0
25/11/2007 16:02:00 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM dual
25/11/2007 16:02:00 TOracleQuery SQLForm.TestQuery End
Duration = 0
25/11/2007 16:02:00 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
25/11/2007 16:02:00 TOracleQuery Query End
Duration = 0
25/11/2007 16:02:00 TSQLThread SQLThread Postmessage
25/11/2007 16:02:00 TSQLThread SQLThread Suspend
25/11/2007 16:02:00 TSQLForm.ThreadFinished
25/11/2007 16:02:00 TSQLForm.ThreadFinished: SQLThread.Suspended
25/11/2007 16:02:00 SQLForm 1 row selected in 0.125 seconds
25/11/2007 16:02:00 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:02:00 NavigationBookmarks: Backward=0, Forward=0
25/11/2007 16:02:00 TOracleQuery $02CB1210 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
25/11/2007 16:02:00 TOracleQuery $02CB1210 End
Duration = 0
25/11/2007 16:02:00 SQLForm 1 row selected in 0.125 seconds
25/11/2007 16:02:01 Create TSQLForm Start
25/11/2007 16:02:01 Create TSQLForm Inherited
25/11/2007 16:02:01 TSQLForm.FormCreate Start
25/11/2007 16:02:01 SQLForm
25/11/2007 16:02:01 TSQLForm.FormCreate Finished
25/11/2007 16:02:02 AddNavigationBookmark starts
25/11/2007 16:02:02 AddNavigationBookmark GNV00001
25/11/2007 16:02:02 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:02:02 NavigationBookmarks: Backward=1, Forward=0
25/11/2007 16:02:02 AddNavigationBookmark ends
25/11/2007 16:02:02 Create TSQLForm SetupMainFont
25/11/2007 16:02:02 Create TSQLForm Activate
25/11/2007 16:02:02 Create TSQLForm Activate done
25/11/2007 16:02:02 Create TSQLForm UpdateWindowList
25/11/2007 16:02:02 Create TSQLForm Positioning
25/11/2007 16:02:02 Create TSQLForm Finished
25/11/2007 16:02:02 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:02:02 NavigationBookmarks: Backward=1, Forward=0
25/11/2007 16:02:07 SQLForm Initializing...
25/11/2007 16:02:07 SetConnected starts
25/11/2007 16:02:07 SetConnected: Connect starts
25/11/2007 16:02:07 TOracleSession $034CB110 Start Session.LogOn as eckernel_ectest@QG_TEST.QG.COM
25/11/2007 16:02:07 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
25/11/2007 16:02:07 TOracleQuery Query End (1 record processed)
Duration = 0
25/11/2007 16:02:07 TOracleSession $034CB110 End
Duration = 0.078
25/11/2007 16:02:07 SetConnected: (Dis)connect ends
25/11/2007 16:02:07 SetSessionAction starts: SQL Window - New
25/11/2007 16:02:07 TOracleQuery $02CB09D0 Start Query.Execute
SQL = select null from dual
25/11/2007 16:02:07 TOracleQuery $02CB09D0 End (1 record processed)
Duration = 0
25/11/2007 16:02:07 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
25/11/2007 16:02:07 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25/11/2007 16:02:07 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20000)), nchr(20) from dual
25/11/2007 16:02:07 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
25/11/2007 16:02:07 TOracleQuery $02CB09D0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
25/11/2007 16:02:07 TOracleQuery $02CB09D0 End
Duration = 0
25/11/2007 16:02:07 SetSessionAction ends
25/11/2007 16:02:07 ExecuteConnectScript starts
25/11/2007 16:02:07 ExecuteConnectScript ends
25/11/2007 16:02:07 TOracleQuery $02CB09D0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
25/11/2007 16:02:07 TOracleQuery $02CB09D0 End
Result = ORA-00942: table or view does not exist
Duration = 0.016
25/11/2007 16:02:07 EnableOutput starts
25/11/2007 16:02:07 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 = 10000
25/11/2007 16:02:07 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
25/11/2007 16:02:07 EnableOutput done
25/11/2007 16:02:07 InitStatistics starts
25/11/2007 16:02:07 TStatistics.Init starts
25/11/2007 16:02:07 TStatistics.Init ends
25/11/2007 16:02:07 InitStatistics ends
25/11/2007 16:02:07 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:02:07 NavigationBookmarks: Backward=1, Forward=0
25/11/2007 16:02:07 SQLForm Executing...
25/11/2007 16:02:07 SQLForm Executing...
25/11/2007 16:02:07 TSQLThread SQLThread.Execute
25/11/2007 16:02:07 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
25/11/2007 16:02:07 TOracleQuery Query End
Duration = 0
25/11/2007 16:02:07 TOracleQuery $02CB0C90 Start Query.Execute
SQL = select sysdate from dual
25/11/2007 16:02:07 TOracleQuery $02CB0C90 End (1 record processed)
Duration = 0
25/11/2007 16:02:08 TOracleQuery SQLForm_1.TestQuery Start Query.Describe
SQL = SELECT * FROM dual
25/11/2007 16:02:08 TOracleQuery SQLForm_1.TestQuery End
Duration = 0
25/11/2007 16:02:08 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
25/11/2007 16:02:08 TOracleQuery Query End
Duration = 0
25/11/2007 16:02:08 TSQLThread SQLThread Postmessage
25/11/2007 16:02:08 TSQLThread SQLThread Suspend
25/11/2007 16:02:08 TSQLForm.ThreadFinished
25/11/2007 16:02:08 TSQLForm.ThreadFinished: SQLThread.Suspended
25/11/2007 16:02:08 SQLForm 1 row selected in 0.125 seconds
25/11/2007 16:02:08 NavigationBookmarks.EnableButtons(Rebuild)
25/11/2007 16:02:08 NavigationBookmarks: Backward=1, Forward=0
25/11/2007 16:02:08 TOracleQuery $02CB0B30 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
25/11/2007 16:02:08 TOracleQuery $02CB0B30 End
Duration = 0.016
25/11/2007 16:02:08 SQLForm 1 row selected in 0.125 seconds
25/11/2007 16:02:29 TOracleQuery $02CB0B30 Start Query.Execute
SQL = select 'x' from dual
25/11/2007 16:02:48 TOracleQuery $02CB0B30 End
Result = ORA-03113: filslutt (EOF) p
 
You must log in or register to reply here.

Similar threads

L
  • Discussion Discussion
Crash Recovery don't restore all windows
Replies
5
Views
1K
Marco Kalter
Marco Kalter
M
  • Discussion Discussion
"A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used" on query using Oracle 21c
Replies
1
Views
1K
Marco Kalter
Marco Kalter
dgs!
  • Discussion Discussion
Oracle Cloud Login Issues
Replies
3
Views
2K
dgs!
dgs!
Marco Kalter
  • Locked
  • Sticky
  • Discussion Discussion
PL/SQL Developer 16.0 Beta 10 released
Replies
0
Views
542
Marco Kalter
Marco Kalter
C
  • Discussion Discussion
Problems with Worksets
Replies
11
Views
5K
cassiusdrow
C
Back
Top