dropped connection / very long time to reconnect

[chucks]

If I leave PSD open on my desktop for a few minutes, it seems to drop the connection(s) it had open. When I return to it, and try to do something, I get spinning cursor. If I click on a PSD window again, I get a "whited-out" screen. This remains for a very long time (sometimes minutes), much much longer than it takes to connect when I first start PSD. Other applications (SQLDEVELOPER) don't seem to be loosing connections. (I am running multi-session, and tried un-checking "check connection" but it didn't make much difference. Any ideas on what might be going on?

 

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

 

[chucks]

Hi Marco,
Attached is the debug output. Thanks for the help on this!

PL/SQL Developer
Version 9.0.6.1665
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (2,354,832 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,960,376 available)

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

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

Preference Files

Plug-Ins

10/5/2012 8:44:54 AM Application started
10/5/2012 8:44:54 AM InitPreferences
10/5/2012 8:44:54 AM Load C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\default = 0
10/5/2012 8:44:54 AM PreferenceSet.Load C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
10/5/2012 8:44:54 AM PreferenceSet.Load OK
10/5/2012 8:44:54 AM Determine LocalPrefPath
10/5/2012 8:44:54 AM [1]: C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences
10/5/2012 8:44:54 AM LocalPrefPath: C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer
10/5/2012 8:44:54 AM Load C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer = 0
10/5/2012 8:44:54 AM PreferenceSet.Load C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\default.ini
10/5/2012 8:44:54 AM PreferenceSet.Load OK
10/5/2012 8:44:54 AM PreferenceSet.Load C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\user.prefs
10/5/2012 8:44:54 AM PreferenceSet.Load OK
10/5/2012 8:44:54 AM InitPreferences end
10/5/2012 8:44:54 AM SortPreferenceSets
10/5/2012 8:44:54 AM - Default csauer
10/5/2012 8:44:54 AM - System Default
10/5/2012 8:44:54 AM DoUpdateChildList
10/5/2012 8:44:54 AM FindPassword starts for epmv3@HPCRS
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for epmv3@HPCRS, no result
10/5/2012 8:44:54 AM FindPassword starts for epmv2d@HPCRS
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for epmv2d@HPCRS, no result
10/5/2012 8:44:54 AM FindPassword starts for citrus@apollo
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for citrus@apollo, no result
10/5/2012 8:44:54 AM FindPassword starts for citrus@hpcrs
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for citrus@hpcrs, no result
10/5/2012 8:44:54 AM FindPassword starts for x12@apollo
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for x12@apollo, no result
10/5/2012 8:44:54 AM FindPassword starts for sys@apollox
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for sys@apollox, no result
10/5/2012 8:44:54 AM FindPassword starts for sys@ZEUS
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Checking sys@apollox...
10/5/2012 8:44:54 AM Checking citrus@apollox...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for sys@ZEUS, no result
10/5/2012 8:44:54 AM FindPassword starts for vim@apOLLO
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Checking sys@apollox...
10/5/2012 8:44:54 AM Checking citrus@apollox...
10/5/2012 8:44:54 AM Checking sys@ZEUS...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for vim@apOLLO, no result
10/5/2012 8:44:54 AM FindPassword starts for vim@ODEN
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Checking sys@apollox...
10/5/2012 8:44:54 AM Checking citrus@apollox...
10/5/2012 8:44:54 AM Checking sys@ZEUS...
10/5/2012 8:44:54 AM Checking vim@apOLLO...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for vim@ODEN, no result
10/5/2012 8:44:54 AM FindPassword starts for vim@hPCRS
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Checking sys@apollox...
10/5/2012 8:44:54 AM Checking citrus@apollox...
10/5/2012 8:44:54 AM Checking sys@ZEUS...
10/5/2012 8:44:54 AM Checking vim@apOLLO...
10/5/2012 8:44:54 AM Checking vim@ODEN...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for vim@hPCRS, no result
10/5/2012 8:44:54 AM FindPassword starts for vim@zEUS
10/5/2012 8:44:54 AM Check current connections...
10/5/2012 8:44:54 AM Checking epmv3@ORACLE1...
10/5/2012 8:44:54 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:44:54 AM Checking claims@oracle1...
10/5/2012 8:44:54 AM Checking x12@oracle1...
10/5/2012 8:44:54 AM Checking sys@HPCRS...
10/5/2012 8:44:54 AM Checking vim@oracle1...
10/5/2012 8:44:54 AM Checking citrus@ORACLE1...
10/5/2012 8:44:54 AM Checking plvision@ORACLE1...
10/5/2012 8:44:54 AM Checking sys@oracle1...
10/5/2012 8:44:54 AM Checking epmv3@HPCRS...
10/5/2012 8:44:54 AM Checking epmv2d@HPCRS...
10/5/2012 8:44:54 AM Checking citrus@apollo...
10/5/2012 8:44:54 AM Checking citrus@hpcrs...
10/5/2012 8:44:54 AM Checking claims@zeus...
10/5/2012 8:44:54 AM Checking x12@apollo...
10/5/2012 8:44:54 AM Checking sys@apollox...
10/5/2012 8:44:54 AM Checking citrus@apollox...
10/5/2012 8:44:54 AM Checking sys@ZEUS...
10/5/2012 8:44:54 AM Checking vim@apOLLO...
10/5/2012 8:44:54 AM Checking vim@ODEN...
10/5/2012 8:44:54 AM Checking vim@hPCRS...
10/5/2012 8:44:54 AM Check connection definitions...
10/5/2012 8:44:54 AM FindPassword ends for vim@zEUS, no result
10/5/2012 8:44:54 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
10/5/2012 8:44:55 AM ReadString OK
10/5/2012 8:44:55 AM pfReadRegistry: "C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe" "%1"
10/5/2012 8:44:55 AM LoadPreferences
10/5/2012 8:44:55 AM LoadPreferences searching for default
10/5/2012 8:44:55 AM C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\default.ini
10/5/2012 8:44:55 AM LoadPreferences NewPref := nil
10/5/2012 8:44:55 AM LoadPreferences
10/5/2012 8:44:55 AM LoadPreferences Reading preferences
10/5/2012 8:44:55 AM LoadPreferences ReadPosition
10/5/2012 8:44:55 AM LoadPreferences ToolsBrowserItemClick(nil)
10/5/2012 8:44:55 AM LoadPreferences CreateBrowserFilters...
10/5/2012 8:44:55 AM LoadPreferences Files
10/5/2012 8:44:55 AM LoadPreferences Buttons
10/5/2012 8:44:55 AM LoadPreferences Printer
10/5/2012 8:44:55 AM LoadPreferences FileBrowserFolders
10/5/2012 8:44:55 AM LoadPreferences Connections
10/5/2012 8:44:55 AM LoadPreferences BrowserFolders
10/5/2012 8:44:55 AM LoadPreferences
10/5/2012 8:44:55 AM LoadPreferences end
10/5/2012 8:44:55 AM MacroLibFilename: C:\Program Files (x86)\PLSQL Developer\Macro\csauer.emlib
10/5/2012 8:44:55 AM Logging on..
10/5/2012 8:44:55 AM Creating new session
10/5/2012 8:44:55 AM Initializing new session
10/5/2012 8:44:55 AM Setting new session parameters
10/5/2012 8:44:55 AM Setting logon session
10/5/2012 8:44:55 AM OCI Initialization starts
10/5/2012 8:44:55 AM OCI Initialization done
10/5/2012 8:44:55 AM OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\product\11.2.0\client_1\bin\oci.dll
10/5/2012 8:44:55 AM Logon2 starting
10/5/2012 8:44:55 AM Logon2.Execute starts
10/5/2012 8:44:55 AM TOracleSession $05D8C140 Start Session.LogOn as epmv3@ORACLE1
10/5/2012 8:44:59 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/5/2012 8:44:59 AM TOracleQuery Query End (1 record processed)
Duration = 0.202
10/5/2012 8:44:59 AM TOracleSession $05D8C140 End
Duration = 3.791
10/5/2012 8:44:59 AM Logon2.Execute done
10/5/2012 8:44:59 AM Logon2 done
10/5/2012 8:44:59 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 8:44:59 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 8:44:59 AM TOracleQuery $05D4C4A0 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)
10/5/2012 8:44:59 AM TOracleQuery $05D4C4A0 End
Result = ORA-00942: table or view does not exist
Duration = 0.219
10/5/2012 8:44:59 AM LogonHistorySave start
10/5/2012 8:44:59 AM ChangeUserPref LogonHistory,
10/5/2012 8:44:59 AM ChangeUserPref DSA,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref ColumnAssociations,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref ImportAssociations,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref BrowserFilters,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref FileBrowserFolders,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref Connections,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref BrowserFolders,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref SessionQueries,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref ExternalTools,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref Documents,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref Reports,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM ChangeUserPref CurrentConnections,
10/5/2012 8:44:59 AM ChangeUserPref end
10/5/2012 8:44:59 AM PreferenceSet.Save
10/5/2012 8:44:59 AM PreferenceSet Filename = C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\user.prefs
10/5/2012 8:44:59 AM PreferenceSet AltFile = user.prefs
10/5/2012 8:44:59 AM PreferenceSet.Save end
10/5/2012 8:44:59 AM LogonHistorySave end
10/5/2012 8:44:59 AM FormCreate Logon.Executed -1
10/5/2012 8:44:59 AM FormCreate SessionChanged
10/5/2012 8:44:59 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 8:45:00 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:00 AM SessionChanged SetDBAViews
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/5/2012 8:45:00 AM TOracleQuery $05D4C340 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:00 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/5/2012 8:45:00 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 8:45:00 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/5/2012 8:45:01 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 8:45:01 AM SessionChanged Authorizations.Load
10/5/2012 8:45:01 AM SessionChanged EnableAuthorizedMenus
10/5/2012 8:45:01 AM WindowAllowed(1)
10/5/2012 8:45:01 AM WindowAllowed done
10/5/2012 8:45:01 AM WindowAllowed(1)
10/5/2012 8:45:01 AM WindowAllowed done
10/5/2012 8:45:01 AM ExecuteConnectScript starts
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 End
Duration = 0.109
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = alter session set plsql_code_type = native
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 End
Duration = 0.109
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 End
Duration = 0.109
10/5/2012 8:45:01 AM ExecuteConnectScript ends
10/5/2012 8:45:01 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:01 AM TOracleQuery $05D4C340 End
Duration = 0.109
10/5/2012 8:45:01 AM SetSessionAction ends
10/5/2012 8:45:01 AM SessionChanged LoadRecentObjects
10/5/2012 8:45:01 AM SessionChanged Notify children
10/5/2012 8:45:01 AM SessionChanged Logoff secondary sessions
10/5/2012 8:45:01 AM SessionChanged EnableChildFunctions
10/5/2012 8:45:01 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\product\11.2.0\client_1\bin\oci.dll
10/5/2012 8:45:01 AM Lock
10/5/2012 8:45:01 AM UnLock
10/5/2012 8:45:03 AM SortPreferenceSets
10/5/2012 8:45:03 AM - Default csauer
10/5/2012 8:45:03 AM - System Default
10/5/2012 8:45:03 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/5/2012 8:45:04 AM TOracleQuery $05D4C340 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:04 AM TOracleQuery $05D4C340 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/5/2012 8:45:04 AM TOracleQuery $05D4C340 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:04 AM Lock
10/5/2012 8:45:04 AM UnLock
10/5/2012 8:45:04 AM DoUpdateChildList
10/5/2012 8:45:04 AM FormActivate start
10/5/2012 8:45:04 AM FormActivate end
10/5/2012 8:45:04 AM WMUpdatePopups starts
10/5/2012 8:45:04 AM Adding new connection
10/5/2012 8:45:04 AM Username = epmv3
10/5/2012 8:45:04 AM Database = ORACLE1
10/5/2012 8:45:04 AM Adding new connection
10/5/2012 8:45:04 AM Username = epmv3
10/5/2012 8:45:04 AM Database = ORACLE1
10/5/2012 8:45:04 AM Adding new connection
10/5/2012 8:45:05 AM Username = epmv3pro
10/5/2012 8:45:05 AM Database = ORACLE1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = claims
10/5/2012 8:45:05 AM Database = oracle1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = x12
10/5/2012 8:45:05 AM Database = oracle1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = sys
10/5/2012 8:45:05 AM Database = HPCRS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = vim
10/5/2012 8:45:05 AM Database = oracle1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = citrus
10/5/2012 8:45:05 AM Database = ORACLE1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = plvision
10/5/2012 8:45:05 AM Database = ORACLE1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = sys
10/5/2012 8:45:05 AM Database = oracle1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = epmv3
10/5/2012 8:45:05 AM Database = HPCRS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = epmv2d
10/5/2012 8:45:05 AM Database = HPCRS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = citrus
10/5/2012 8:45:05 AM Database = apollo
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = citrus
10/5/2012 8:45:05 AM Database = hpcrs
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = claims
10/5/2012 8:45:05 AM Database = zeus
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = x12
10/5/2012 8:45:05 AM Database = apollo
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = sys
10/5/2012 8:45:05 AM Database = apollox
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = citrus
10/5/2012 8:45:05 AM Database = apollox
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = sys
10/5/2012 8:45:05 AM Database = ZEUS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = vim
10/5/2012 8:45:05 AM Database = apOLLO
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = vim
10/5/2012 8:45:05 AM Database = ODEN
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = vim
10/5/2012 8:45:05 AM Database = hPCRS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = vim
10/5/2012 8:45:05 AM Database = zEUS
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = claims
10/5/2012 8:45:05 AM Database = APOLLOX
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = epmv2d
10/5/2012 8:45:05 AM Database = apollox
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = system
10/5/2012 8:45:05 AM Database = ORACLE1
10/5/2012 8:45:05 AM Adding new connection
10/5/2012 8:45:05 AM Username = epmv2d
10/5/2012 8:45:05 AM Database = orACLE1
10/5/2012 8:45:05 AM LoadDesktop starts
10/5/2012 8:45:05 AM LoadDesktop Window = 4
10/5/2012 8:45:05 AM WindowAllowed(4)
10/5/2012 8:45:05 AM WindowAllowed done
10/5/2012 8:45:05 AM Create TCommandForm Start
10/5/2012 8:45:05 AM Create TCommandForm Inherited
10/5/2012 8:45:05 AM Create TCommandForm SetupMainFont
10/5/2012 8:45:05 AM Create TCommandForm Activate
10/5/2012 8:45:05 AM Create TCommandForm Activate done
10/5/2012 8:45:05 AM Create TCommandForm UpdateWindowList
10/5/2012 8:45:05 AM Create TCommandForm Positioning
10/5/2012 8:45:05 AM Create TCommandForm Finished
10/5/2012 8:45:05 AM Lock
10/5/2012 8:45:05 AM UnLock
10/5/2012 8:45:05 AM SetConnected starts
10/5/2012 8:45:05 AM SetConnected: Connect starts
10/5/2012 8:45:05 AM TOracleSession $05D8D640 Start Session.LogOn as epmv3@ORACLE1
10/5/2012 8:45:06 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/5/2012 8:45:06 AM TOracleQuery Query End (1 record processed)
Duration = 0.203
10/5/2012 8:45:06 AM TOracleSession $05D8D640 End
Duration = 1.295
10/5/2012 8:45:06 AM SetConnected: (Dis)connect ends
10/5/2012 8:45:06 AM SetSessionAction starts: Command Window - New
10/5/2012 8:45:06 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:06 AM TOracleQuery $05D4C1E0 End (1 record processed)
Duration = 0.202
10/5/2012 8:45:06 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/5/2012 8:45:07 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 8:45:07 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/5/2012 8:45:07 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.218
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Command Window - New
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 End
Duration = 0.094
10/5/2012 8:45:07 AM SetSessionAction ends
10/5/2012 8:45:07 AM ExecuteConnectScript starts
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 End
Duration = 0.109
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plsql_code_type = native
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 End
Duration = 0.109
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 End
Duration = 0.11
10/5/2012 8:45:07 AM ExecuteConnectScript ends
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
10/5/2012 8:45:07 AM TOracleQuery $05D4C1E0 End (1 record processed)
Duration = 0.202
10/5/2012 8:45:07 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 8:45:08 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 8:45:08 AM AddScript(login.sql)
10/5/2012 8:45:08 AM 1 Filename=login.sql
10/5/2012 8:45:08 AM CheckFile(C:\Program Files (x86)\PLSQL Developer, login.sql, sql)
10/5/2012 8:45:08 AM CheckFile (0) C:\Program Files (x86)\PLSQL Developer\login.sql
10/5/2012 8:45:08 AM 2 Filename=C:\Program Files (x86)\PLSQL Developer\login.sql
10/5/2012 8:45:08 AM Lock
10/5/2012 8:45:08 AM UnLock
10/5/2012 8:45:08 AM LoadDesktop ChildListIndex = 2
10/5/2012 8:45:08 AM LoadDesktop WindowName =
10/5/2012 8:45:08 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:08 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:08 AM TOracleQuery $05D4C1E0 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:08 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:08 AM TOracleQuery $05D4C1E0 End
Duration = 0.093
10/5/2012 8:45:08 AM SetSessionAction ends
10/5/2012 8:45:08 AM LoadDesktop Window = 3
10/5/2012 8:45:08 AM WindowAllowed(3)
10/5/2012 8:45:08 AM WindowAllowed done
10/5/2012 8:45:08 AM Create TProcEditForm Start
10/5/2012 8:45:08 AM Create TProcEditForm Inherited
10/5/2012 8:45:08 AM AddNavigationBookmark starts
10/5/2012 8:45:08 AM Lock
10/5/2012 8:45:08 AM UnLock
10/5/2012 8:45:08 AM Create TProcEditForm SetupMainFont
10/5/2012 8:45:08 AM Create TProcEditForm Activate
10/5/2012 8:45:08 AM Create TProcEditForm Activate done
10/5/2012 8:45:08 AM Create TProcEditForm UpdateWindowList
10/5/2012 8:45:08 AM Create TProcEditForm Positioning
10/5/2012 8:45:08 AM Create TProcEditForm Finished
10/5/2012 8:45:08 AM LoadDesktop ChildListIndex = 4
10/5/2012 8:45:08 AM Lock
10/5/2012 8:45:08 AM UnLock
10/5/2012 8:45:08 AM TOracleQuery $05D4C080 Start Query.Execute
SQL = select text from sys.all_source
where owner = wner
and name = :name
and type = :type
order by line
:OWNER = EPMV3
:NAME = SSPPATIENTACCOUNT_EPM
:TYPE = PROCEDURE
10/5/2012 8:45:08 AM TOracleQuery $05D4C080 End (100 records processed)
Duration = 0.203
10/5/2012 8:45:08 AM TOracleQuery $05D4C080 Start Query.Next for up to 100 records
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 End (94 records processed)
Duration = 0.109
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = wner
order by sequence
:NAME = SSPPATIENTACCOUNT_EPM
:TYPE = PROCEDURE
:OWNER = EPMV3
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:09 AM ProcEditForm.GetTabNames
10/5/2012 8:45:09 AM + SSPPATIENTACCOUNT_EPM
10/5/2012 8:45:09 AM ProcEditForm.GetTabNames done
10/5/2012 8:45:09 AM Lock
10/5/2012 8:45:09 AM Lock
10/5/2012 8:45:09 AM UnLock
10/5/2012 8:45:09 AM Lock
10/5/2012 8:45:09 AM UnLock
10/5/2012 8:45:09 AM UnLock
10/5/2012 8:45:09 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/5/2012 8:45:09 AM TOracleQuery Query End
Duration = 0.094
10/5/2012 8:45:09 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:09 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:09 AM UpdateContents(Clear)
10/5/2012 8:45:09 AM Source = CREATE OR REPLACE PROCEDURE "SSPPATIENTACCOUNT_EPM" (v_ClientID IN VARCHAR2 DEFAULT NULL,
10/5/2012 8:45:09 AM UpdatingContents: Thread Started
10/5/2012 8:45:09 AM ContentsThread: Execute
10/5/2012 8:45:09 AM ContentsThread: Analyze
10/5/2012 8:45:09 AM ContentsThread: Valid
10/5/2012 8:45:09 AM ContentsThread: Suspend started
10/5/2012 8:45:09 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:09 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:09 AM LoadDesktop WindowName =
10/5/2012 8:45:09 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:09 AM TOracleQuery $05D4C080 End
Duration = 0.109
10/5/2012 8:45:09 AM SetSessionAction ends
10/5/2012 8:45:09 AM LoadDesktop Window = 3
10/5/2012 8:45:09 AM WindowAllowed(3)
10/5/2012 8:45:09 AM WindowAllowed done
10/5/2012 8:45:09 AM Create TProcEditForm Start
10/5/2012 8:45:09 AM Create TProcEditForm Inherited
10/5/2012 8:45:10 AM Lock
10/5/2012 8:45:10 AM UnLock
10/5/2012 8:45:10 AM AddNavigationBookmark starts
10/5/2012 8:45:10 AM Create TProcEditForm SetupMainFont
10/5/2012 8:45:10 AM Create TProcEditForm Activate
10/5/2012 8:45:10 AM Create TProcEditForm Activate done
10/5/2012 8:45:10 AM Create TProcEditForm UpdateWindowList
10/5/2012 8:45:10 AM Create TProcEditForm Positioning
10/5/2012 8:45:10 AM Create TProcEditForm Finished
10/5/2012 8:45:10 AM LoadDesktop ChildListIndex = 3
10/5/2012 8:45:10 AM TOracleSession $08C85830 Start Session.LogOn as epmv3pro@ORACLE1
10/5/2012 8:45:11 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/5/2012 8:45:11 AM TOracleQuery Query End (1 record processed)
Duration = 0.203
10/5/2012 8:45:11 AM TOracleSession $08C85830 End
Duration = 1.576
10/5/2012 8:45:11 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:11 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:11 AM TOracleQuery $05D4BDC0 End (1 record processed)
Duration = 0.202
10/5/2012 8:45:11 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/5/2012 8:45:12 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 8:45:12 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/5/2012 8:45:12 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 8:45:12 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:12 AM TOracleQuery $05D4BDC0 End
Duration = 0.094
10/5/2012 8:45:12 AM SetSessionAction ends
10/5/2012 8:45:12 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 8:45:12 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 8:45:12 AM TOracleQuery $05D4BDC0 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)
10/5/2012 8:45:12 AM TOracleQuery $05D4BDC0 End
Result = ORA-00942: table or view does not exist
Duration = 0.219
10/5/2012 8:45:12 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select text from sys.all_source
where owner = wner
and name = :name
and type = :type
order by line
:OWNER = EPMV3PRO
:NAME = BILLINGPKG
:TYPE = PACKAGE
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.203
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 End (7 records processed)
Duration = 0.094
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = wner
order by sequence
:NAME = BILLINGPKG
:TYPE = PACKAGE
:OWNER = EPMV3PRO
10/5/2012 8:45:13 AM TOracleQuery $05D4BDC0 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:13 AM ProcEditForm.GetTabNames
10/5/2012 8:45:13 AM + BILLINGPKG
10/5/2012 8:45:13 AM ProcEditForm.GetTabNames done
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM Lock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM UnLock
10/5/2012 8:45:13 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/5/2012 8:45:13 AM TOracleQuery Query End
Duration = 0.094
10/5/2012 8:45:13 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:13 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:13 AM UpdateContents(Clear)
10/5/2012 8:45:13 AM Source = CREATE OR REPLACE PACKAGE BILLINGPKG
10/5/2012 8:45:13 AM UpdatingContents: Thread Started
10/5/2012 8:45:13 AM ContentsThread: Execute
10/5/2012 8:45:13 AM ContentsThread: Analyze
10/5/2012 8:45:13 AM ContentsThread: Valid
10/5/2012 8:45:14 AM ContentsThread: Suspend started
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select * from sys.all_objects
where object_type = bject_type
and owner = bject_owner
and object_name = bject_name
and :sub_object is null
:OBJECT_TYPE = PACKAGE BODY
:OBJECT_OWNER = EPMV3PRO
:OBJECT_NAME = BILLINGPKG
:SUB_OBJECT = Null
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (1 record processed)
Duration = 0.202
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select text from sys.all_source
where owner = wner
and name = :name
and type = :type
order by line
:OWNER = EPMV3PRO
:NAME = BILLINGPKG
:TYPE = PACKAGE BODY
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.218
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:14 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.093
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.093
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.11
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:15 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.11
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:16 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (43 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select text from sys.all_source
where owner = wner
and name = :name
and type = :type
order by line
:OWNER = EPMV3PRO
:NAME = BILLINGPKG
:TYPE = PACKAGE BODY
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.203
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:17 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.093
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:18 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.11
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.093
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.094
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.093
10/5/2012 8:45:19 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 End (100 records processed)
Duration = 0.109
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 Start Query.Next for up to 100 records
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 End (43 records processed)
Duration = 0.109
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select *
from sys.all_errors
where name = :name and type = :type and owner = wner
order by sequence
:NAME = BILLINGPKG
:TYPE = PACKAGE BODY
:OWNER = EPMV3PRO
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:20 AM ProcEditForm.GetTabNames
10/5/2012 8:45:20 AM + BILLINGPKG
10/5/2012 8:45:20 AM + BILLINGPKG
10/5/2012 8:45:20 AM ProcEditForm.GetTabNames done
10/5/2012 8:45:20 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/5/2012 8:45:20 AM TOracleQuery Query End
Duration = 0.094
10/5/2012 8:45:20 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:20 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:20 AM UpdateContents(Clear)
10/5/2012 8:45:20 AM Source = CREATE OR REPLACE PACKAGE BODY BILLINGPKG as
10/5/2012 8:45:20 AM UpdatingContents: Thread Started
10/5/2012 8:45:20 AM ContentsThread: Resume
10/5/2012 8:45:20 AM ContentsThread: Analyze
10/5/2012 8:45:20 AM ContentsThread: Valid
10/5/2012 8:45:20 AM ContentsThread: Suspend started
10/5/2012 8:45:20 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:20 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:20 AM LoadDesktop WindowName =
10/5/2012 8:45:20 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 End (1 record processed)
Duration = 0.219
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:20 AM TOracleQuery $05D4BDC0 End
Duration = 0.109
10/5/2012 8:45:20 AM SetSessionAction ends
10/5/2012 8:45:20 AM LoadDesktop Window = 1
10/5/2012 8:45:20 AM WindowAllowed(1)
10/5/2012 8:45:20 AM WindowAllowed done
10/5/2012 8:45:20 AM Create TSQLForm Start
10/5/2012 8:45:20 AM Create TSQLForm Inherited
10/5/2012 8:45:21 AM TSQLForm.FormCreate Start
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM SQLForm
10/5/2012 8:45:21 AM TSQLForm.FormCreate Finished
10/5/2012 8:45:21 AM AddNavigationBookmark starts
10/5/2012 8:45:21 AM Create TSQLForm SetupMainFont
10/5/2012 8:45:21 AM Create TSQLForm Activate
10/5/2012 8:45:21 AM Create TSQLForm Activate done
10/5/2012 8:45:21 AM Create TSQLForm UpdateWindowList
10/5/2012 8:45:21 AM Create TSQLForm Positioning
10/5/2012 8:45:21 AM Create TSQLForm Finished
10/5/2012 8:45:21 AM LoadDesktop ChildListIndex = 1
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM FileAge: C:\Users\csauer\Documents\epmdevWork\sql\copy_menu_to_production.sql = 5:53:44 AM
10/5/2012 8:45:21 AM SQLForm
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM LoadDesktop WindowName =
10/5/2012 8:45:21 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:21 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:21 AM TOracleQuery $05D4B580 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:21 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:21 AM TOracleQuery $05D4B580 End
Duration = 0.109
10/5/2012 8:45:21 AM SetSessionAction ends
10/5/2012 8:45:21 AM LoadDesktop Window = -1
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:21 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:21 AM DoUpdateChildList
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM Lock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM UnLock
10/5/2012 8:45:21 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 8:45:21 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 8:45:21 AM SessionChanged SetDBAViews
10/5/2012 8:45:21 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 End (0 records processed)
Duration = 0.203
10/5/2012 8:45:22 AM SessionChanged Authorizations.Load
10/5/2012 8:45:22 AM SessionChanged ApplyPreferences
10/5/2012 8:45:22 AM SortPreferenceSets
10/5/2012 8:45:22 AM - Default csauer
10/5/2012 8:45:22 AM - System Default
10/5/2012 8:45:22 AM SessionChanged EnableAuthorizedMenus
10/5/2012 8:45:22 AM WindowAllowed(1)
10/5/2012 8:45:22 AM WindowAllowed done
10/5/2012 8:45:22 AM WindowAllowed(1)
10/5/2012 8:45:22 AM WindowAllowed done
10/5/2012 8:45:22 AM ExecuteConnectScript starts
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 End
Duration = 0.109
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = alter session set plsql_code_type = native
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 End
Duration = 0.093
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 End
Duration = 0.109
10/5/2012 8:45:22 AM ExecuteConnectScript ends
10/5/2012 8:45:22 AM SetSessionAction starts: Primary Session
10/5/2012 8:45:22 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select null from dual
10/5/2012 8:45:23 AM TOracleQuery $05D4B580 End (1 record processed)
Duration = 0.203
10/5/2012 8:45:23 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 8:45:23 AM TOracleQuery $05D4B580 End
Duration = 0.109
10/5/2012 8:45:23 AM SetSessionAction ends
10/5/2012 8:45:23 AM SessionChanged LoadRecentObjects
10/5/2012 8:45:23 AM SessionChanged Notify children
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM SessionChanged Logoff secondary sessions
10/5/2012 8:45:23 AM SessionChanged EnableChildFunctions
10/5/2012 8:45:23 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 8:45:23 AM NavigationBookmarks: Backward=0, Forward=0
10/5/2012 8:45:23 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\product\11.2.0\client_1\bin\oci.dll
10/5/2012 8:45:23 AM WindowAllowed(4)
10/5/2012 8:45:23 AM WindowAllowed done
10/5/2012 8:45:23 AM WindowAllowed(3)
10/5/2012 8:45:23 AM WindowAllowed done
10/5/2012 8:45:23 AM WindowAllowed(3)
10/5/2012 8:45:23 AM WindowAllowed done
10/5/2012 8:45:23 AM WindowAllowed(1)
10/5/2012 8:45:23 AM WindowAllowed done
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM Lock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM UnLock
10/5/2012 8:45:23 AM LoadDesktop ends
10/5/2012 8:45:23 AM FindPassword starts for epmv3@HPCRS
10/5/2012 8:45:23 AM Check current connections...
10/5/2012 8:45:23 AM Checking epmv3@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:45:23 AM Checking claims@oracle1...
10/5/2012 8:45:23 AM Checking x12@oracle1...
10/5/2012 8:45:23 AM Checking sys@HPCRS...
10/5/2012 8:45:23 AM Checking vim@oracle1...
10/5/2012 8:45:23 AM Checking citrus@ORACLE1...
10/5/2012 8:45:23 AM Checking plvision@ORACLE1...
10/5/2012 8:45:23 AM Checking sys@oracle1...
10/5/2012 8:45:23 AM Checking epmv3@HPCRS...
10/5/2012 8:45:23 AM Checking epmv2d@HPCRS...
10/5/2012 8:45:23 AM Checking citrus@apollo...
10/5/2012 8:45:23 AM Checking citrus@hpcrs...
10/5/2012 8:45:23 AM Checking claims@zeus...
10/5/2012 8:45:23 AM Checking x12@apollo...
10/5/2012 8:45:23 AM Checking sys@apollox...
10/5/2012 8:45:23 AM Checking citrus@apollox...
10/5/2012 8:45:23 AM Checking sys@ZEUS...
10/5/2012 8:45:23 AM Checking vim@apOLLO...
10/5/2012 8:45:23 AM Checking vim@ODEN...
10/5/2012 8:45:23 AM Checking vim@hPCRS...
10/5/2012 8:45:23 AM Checking vim@zEUS...
10/5/2012 8:45:23 AM Checking claims@APOLLOX...
10/5/2012 8:45:23 AM Checking epmv2d@apollox...
10/5/2012 8:45:23 AM Checking system@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv2d@orACLE1...
10/5/2012 8:45:23 AM Check connection definitions...
10/5/2012 8:45:23 AM FindPassword ends for epmv3@HPCRS, no result
10/5/2012 8:45:23 AM FindPassword starts for epmv2d@HPCRS
10/5/2012 8:45:23 AM Check current connections...
10/5/2012 8:45:23 AM Checking epmv3@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:45:23 AM Checking claims@oracle1...
10/5/2012 8:45:23 AM Checking x12@oracle1...
10/5/2012 8:45:23 AM Checking sys@HPCRS...
10/5/2012 8:45:23 AM Checking vim@oracle1...
10/5/2012 8:45:23 AM Checking citrus@ORACLE1...
10/5/2012 8:45:23 AM Checking plvision@ORACLE1...
10/5/2012 8:45:23 AM Checking sys@oracle1...
10/5/2012 8:45:23 AM Checking epmv3@HPCRS...
10/5/2012 8:45:23 AM Checking epmv2d@HPCRS...
10/5/2012 8:45:23 AM Checking citrus@apollo...
10/5/2012 8:45:23 AM Checking citrus@hpcrs...
10/5/2012 8:45:23 AM Checking claims@zeus...
10/5/2012 8:45:23 AM Checking x12@apollo...
10/5/2012 8:45:23 AM Checking sys@apollox...
10/5/2012 8:45:23 AM Checking citrus@apollox...
10/5/2012 8:45:23 AM Checking sys@ZEUS...
10/5/2012 8:45:23 AM Checking vim@apOLLO...
10/5/2012 8:45:23 AM Checking vim@ODEN...
10/5/2012 8:45:23 AM Checking vim@hPCRS...
10/5/2012 8:45:23 AM Checking vim@zEUS...
10/5/2012 8:45:23 AM Checking claims@APOLLOX...
10/5/2012 8:45:23 AM Checking epmv2d@apollox...
10/5/2012 8:45:23 AM Checking system@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv2d@orACLE1...
10/5/2012 8:45:23 AM Check connection definitions...
10/5/2012 8:45:23 AM FindPassword ends for epmv2d@HPCRS, no result
10/5/2012 8:45:23 AM FindPassword starts for citrus@apollo
10/5/2012 8:45:23 AM Check current connections...
10/5/2012 8:45:23 AM Checking epmv3@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:45:23 AM Checking claims@oracle1...
10/5/2012 8:45:23 AM Checking x12@oracle1...
10/5/2012 8:45:23 AM Checking sys@HPCRS...
10/5/2012 8:45:23 AM Checking vim@oracle1...
10/5/2012 8:45:23 AM Checking citrus@ORACLE1...
10/5/2012 8:45:23 AM Checking plvision@ORACLE1...
10/5/2012 8:45:23 AM Checking sys@oracle1...
10/5/2012 8:45:23 AM Checking epmv3@HPCRS...
10/5/2012 8:45:23 AM Checking epmv2d@HPCRS...
10/5/2012 8:45:23 AM Checking citrus@apollo...
10/5/2012 8:45:23 AM Checking citrus@hpcrs...
10/5/2012 8:45:23 AM Checking claims@zeus...
10/5/2012 8:45:23 AM Checking x12@apollo...
10/5/2012 8:45:23 AM Checking sys@apollox...
10/5/2012 8:45:23 AM Checking citrus@apollox...
10/5/2012 8:45:23 AM Checking sys@ZEUS...
10/5/2012 8:45:23 AM Checking vim@apOLLO...
10/5/2012 8:45:23 AM Checking vim@ODEN...
10/5/2012 8:45:23 AM Checking vim@hPCRS...
10/5/2012 8:45:23 AM Checking vim@zEUS...
10/5/2012 8:45:23 AM Checking claims@APOLLOX...
10/5/2012 8:45:23 AM Checking epmv2d@apollox...
10/5/2012 8:45:23 AM Checking system@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv2d@orACLE1...
10/5/2012 8:45:23 AM Check connection definitions...
10/5/2012 8:45:23 AM FindPassword ends for citrus@apollo, no result
10/5/2012 8:45:23 AM FindPassword starts for citrus@hpcrs
10/5/2012 8:45:23 AM Check current connections...
10/5/2012 8:45:23 AM Checking epmv3@ORACLE1...
10/5/2012 8:45:23 AM Checking epmv3pro@ORACLE1...
10/5/2012 8:45:23 AM Checking claims@oracle1...
10/5/2012 8:45:23 AM Checking x12@oracle1...
10/5/2012 8:45:23 AM Checking sys@HPCRS...
10/5/2012 8:45:23 AM Checking vim@oracle1...
10/5/2012 8:45:23 AM Checking citrus@ORACLE1...
10/5/2012 8:45:23 AM Checking plvision@ORACLE1...
10/5/2012 8:45:23 AM Checking sys@oracle1...
10/5/2012 8:45:23 AM Checking epmv3@H

 

[chucks]

Here is where things start to go wrong:
SQL = select * from nls_database_parameters where parameter like 'NLS%CHARACTERSET'
10/5/2012 9:47:33 AM TOracleQuery $05D4B580 End (2 records processed)
Duration = 0.203
10/5/2012 9:55:07 AM TCommandForm.FileSave starts
10/5/2012 9:55:07 AM TCommandForm.FileSave.SaveMemo
10/5/2012 9:55:07 AM TCommandForm.FileSave.SetFilename
10/5/2012 9:55:07 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 9:55:07 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 9:55:07 AM TCommandForm.FileSave ends
10/5/2012 10:05:07 AM TCommandForm.FileSave starts
10/5/2012 10:05:07 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:05:07 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:05:07 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:05:07 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:05:07 AM TCommandForm.FileSave ends
10/5/2012 10:15:08 AM TCommandForm.FileSave starts
10/5/2012 10:15:08 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:15:08 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:15:08 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:15:08 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:15:08 AM TCommandForm.FileSave ends
10/5/2012 10:25:08 AM TCommandForm.FileSave starts
10/5/2012 10:25:08 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:25:08 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:25:08 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:25:08 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:25:08 AM TCommandForm.FileSave ends
10/5/2012 10:35:09 AM TCommandForm.FileSave starts
10/5/2012 10:35:09 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:35:09 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:35:09 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:35:09 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:35:09 AM TCommandForm.FileSave ends
10/5/2012 10:45:09 AM TCommandForm.FileSave starts
10/5/2012 10:45:09 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:45:09 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:45:09 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:45:09 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:45:09 AM TCommandForm.FileSave ends
10/5/2012 10:55:10 AM TCommandForm.FileSave starts
10/5/2012 10:55:10 AM TCommandForm.FileSave.SaveMemo
10/5/2012 10:55:10 AM TCommandForm.FileSave.SetFilename
10/5/2012 10:55:10 AM TCommandForm.FileSave.SaveRecovery
10/5/2012 10:55:10 AM TCommandForm.FileSave.PlugInFileSaved
10/5/2012 10:55:10 AM TCommandForm.FileSave ends
10/5/2012 10:58:32 AM CheckFileDate WindowFileDate = 5:53:44 AM
10/5/2012 10:58:32 AM FileAge: C:\Users\csauer\Documents\epmdevWork\sql\copy_menu_to_production.sql = 5:53:44 AM
10/5/2012 10:58:32 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 10:58:32 AM NavigationBookmarks: Backward=1, Forward=0
10/5/2012 10:58:45 AM AddNavigationBookmark starts
10/5/2012 10:58:45 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 10:58:45 AM NavigationBookmarks: Backward=1, Forward=0
10/5/2012 10:58:45 AM AddNavigationBookmark ends
10/5/2012 10:58:45 AM FormActivate start
10/5/2012 10:58:45 AM FormActivate done
10/5/2012 10:58:47 AM Lock
10/5/2012 10:58:47 AM Lock
10/5/2012 10:58:47 AM UnLock
10/5/2012 10:58:47 AM Lock
10/5/2012 10:58:47 AM UnLock
10/5/2012 10:58:47 AM Lock
10/5/2012 10:58:47 AM UnLock
10/5/2012 10:58:47 AM UnLock
10/5/2012 10:58:47 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/5/2012 10:59:20 AM TOracleQuery Query End
Result = ORA-03113: end-of-file on communication channel
Process ID: 3240
Session ID: 145 Serial number: 24043
Duration = 32.433
10/5/2012 10:59:20 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 10:59:20 AM NavigationBookmarks: Backward=1, Forward=0
10/5/2012 10:59:20 AM UpdateChildList [timer]
10/5/2012 10:59:20 AM DoUpdateChildList
10/5/2012 10:59:20 AM Lock
10/5/2012 10:59:20 AM Lock
10/5/2012 10:59:20 AM UnLock
10/5/2012 10:59:20 AM UnLock
10/5/2012 10:59:22 AM CheckFileDate WindowFileDate = 5:53:44 AM
10/5/2012 10:59:22 AM FileAge: C:\Users\csauer\Documents\epmdevWork\sql\copy_menu_to_production.sql = 5:53:44 AM
10/5/2012 10:59:22 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/5/2012 10:59:22 AM TOracleQuery Query End
Result = ORA-03114: not connected to ORACLE
Duration = 0
10/5/2012 10:59:22 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 10:59:22 AM NavigationBookmarks: Backward=1, Forward=0
10/5/2012 10:59:25 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select 'x' from dual
10/5/2012 10:59:49 AM TOracleQuery $05D4B580 End
Result = ORA-03113: end-of-file on communication channel
Process ID: 3316
Session ID: 198 Serial number: 15841
Duration = 23.837
10/5/2012 10:59:49 AM TOracleSession $08C85830 Start Session.LogOff
10/5/2012 10:59:49 AM TOracleSession $08C85830 End
Duration = 0
10/5/2012 10:59:49 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select 'x' from dual
10/5/2012 10:59:49 AM TOracleQuery $05D4B580 End
Result = ORA-03114: not connected to ORACLE
Duration = 0.015
10/5/2012 10:59:49 AM TOracleSession $05D8D640 Start Session.LogOff
10/5/2012 10:59:49 AM TOracleSession $05D8D640 End
Duration = 0
10/5/2012 10:59:49 AM TOracleSession $092E3080 Start Session.LogOn as epmv3@ORACLE1
10/5/2012 10:59:50 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/5/2012 10:59:50 AM TOracleQuery Query End (1 record processed)
Duration = 0.202
10/5/2012 10:59:50 AM TOracleSession $092E3080 End
Duration = 1.295
10/5/2012 10:59:50 AM TOracleSession $092E3080 Start Session.LogOff
10/5/2012 10:59:50 AM TOracleSession $092E3080 End
Duration = 0.109
10/5/2012 10:59:50 AM TOracleQuery $05D4B580 Start Query.Execute
SQL = select 'x' from dual
10/5/2012 11:00:19 AM TOracleQuery $05D4B580 End
Result = ORA-03113: end-of-file on communication channel
Process ID: 5064
Session ID: 72 Serial number: 43289
Duration = 28.829
10/5/2012 11:00:19 AM TOracleSession $05D8C140 Start Session.LogOff
10/5/2012 11:00:19 AM TOracleSession $05D8C140 End
Duration = 0
10/5/2012 11:00:19 AM TOracleSession $05D8C140 Start Session.LogOn as epmv3@ORACLE1
10/5/2012 11:00:20 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/5/2012 11:00:20 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 11:00:20 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
10/5/2012 11:00:21 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.203
10/5/2012 11:00:21 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/5/2012 11:00:21 AM TOracleQuery Query End (1 record processed)
Duration = 0.202
10/5/2012 11:00:21 AM TOracleSession $05D8C140 End
Duration = 1.716
10/5/2012 11:00:21 AM LogonHistorySave start
10/5/2012 11:00:21 AM ChangeUserPref LogonHistory,
10/5/2012 11:00:21 AM ChangeUserPref DSA,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref ColumnAssociations,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref ImportAssociations,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref BrowserFilters,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref FileBrowserFolders,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref Connections,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref BrowserFolders,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref SessionQueries,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref ExternalTools,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref Documents,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref Reports,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM ChangeUserPref CurrentConnections,
10/5/2012 11:00:21 AM ChangeUserPref end
10/5/2012 11:00:21 AM PreferenceSet.Save
10/5/2012 11:00:21 AM PreferenceSet Filename = C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\user.prefs
10/5/2012 11:00:21 AM PreferenceSet AltFile = user.prefs
10/5/2012 11:00:21 AM PreferenceSet.Save end
10/5/2012 11:00:21 AM LogonHistorySave end
10/5/2012 11:00:21 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
10/5/2012 11:00:21 AM TOracleQuery Query End (5 records processed)
Duration = 0.203
10/5/2012 11:00:21 AM SessionChanged SetDBAViews
10/5/2012 11:00:21 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
10/5/2012 11:00:21 AM TOracleQuery $05D4C1E0 End (0 records processed)
Duration = 0.203
10/5/2012 11:00:21 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
10/5/2012 11:00:21 AM TOracleQuery $05D4C1E0 End (0 records processed)
Duration = 0.203
10/5/2012 11:00:22 AM SessionChanged Authorizations.Load
10/5/2012 11:00:22 AM SessionChanged ApplyPreferences
10/5/2012 11:00:22 AM SortPreferenceSets
10/5/2012 11:00:22 AM - Default csauer
10/5/2012 11:00:22 AM - System Default
10/5/2012 11:00:22 AM SessionChanged EnableAuthorizedMenus
10/5/2012 11:00:22 AM WindowAllowed(1)
10/5/2012 11:00:22 AM WindowAllowed done
10/5/2012 11:00:22 AM WindowAllowed(1)
10/5/2012 11:00:22 AM WindowAllowed done
10/5/2012 11:00:22 AM ExecuteConnectScript starts
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 End
Duration = 0.093
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plsql_code_type = native
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 End
Duration = 0.109
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 End
Duration = 0.109
10/5/2012 11:00:22 AM ExecuteConnectScript ends
10/5/2012 11:00:22 AM SetSessionAction starts: Primary Session
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = select null from dual
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 End (1 record processed)
Duration = 0.218
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
10/5/2012 11:00:22 AM TOracleQuery $05D4C1E0 End
Duration = 0.11
10/5/2012 11:00:22 AM SetSessionAction ends
10/5/2012 11:00:22 AM SessionChanged LoadRecentObjects
10/5/2012 11:00:22 AM SessionChanged Notify children
10/5/2012 11:00:22 AM SessionChanged Logoff secondary sessions
10/5/2012 11:00:22 AM SessionChanged EnableChildFunctions
10/5/2012 11:00:22 AM NavigationBookmarks.EnableButtons(Rebuild)
10/5/2012 11:00:22 AM NavigationBookmarks: Backward=1, Forward=0
10/5/2012 11:00:22 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: D:\app\product\11.2.0\client_1
Found: oci.dll
Using: D:\app\product\11.2.0\client_1\bin\oci.dll
10/5/2012 11:00:22 AM WindowAllowed(3)
10/5/2012 11:00:22 AM WindowAllowed done
10/5/2012 11:00:22 AM WindowAllowed(1)
10/5/2012 11:00:22 AM WindowAllowed done
10/5/2012 11:00:22 AM WindowAllowed(4)
10/5/2012 11:00:22 AM WindowAllowed done
10/5/2012 11:00:22 AM Lock
10/5/2012 11:00:22 AM Lock
10/5/2012 11:00:22 AM UnLock
10/5/2012 11:00:22 AM Lock
10/5/2012 11:00:23 AM UnLock
10/5/2012 11:00:23 AM Lock
10/5/2012 11:00:23 AM UnLock
10/5/2012 11:00:23 AM UnLock
10/5/2012 11:00:23 AM LogonHistorySave start
10/5/2012 11:00:23 AM ChangeUserPref LogonHistory,
10/5/2012 11:00:23 AM ChangeUserPref DSA,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref ColumnAssociations,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref ImportAssociations,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref BrowserFilters,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref FileBrowserFolders,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref Connections,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref BrowserFolders,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref SessionQueries,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref ExternalTools,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref Documents,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref Reports,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM ChangeUserPref CurrentConnections,
10/5/2012 11:00:23 AM ChangeUserPref end
10/5/2012 11:00:23 AM PreferenceSet.Save
10/5/2012 11:00:23 AM PreferenceSet Filename = C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\user.prefs
10/5/2012 11:00:23 AM PreferenceSet AltFile = user.prefs
10/5/2012 11:00:23 AM PreferenceSet.Save end
10/5/2012 11:00:23 AM LogonHistorySave end
10/5/2012 11:00:30 AM WindowAllowed(3)
10/5/2012 11:00:30 AM WindowAllowed done
10/5/2012 11:00:30 AM WindowAllowed(1)
10/5/2012 11:00:30 AM WindowAllowed done
10/5/2012 11:00:30 AM WindowAllowed(4)
10/5/2012 11:00:30 AM WindowAllowed done
10/5/2012 11:00:30 AM MainForm Closing
10/5/2012 11:00:30 AM ChangeUserPref , PlanViewType
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Logon, Username
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Logon, Database
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Logon, ConnectAs
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref , LastNewsRead
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref , LastNewsItem
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref , LastUpdateItem
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM TOracleSession $05D8C140 Start Session.LogOff
10/5/2012 11:00:30 AM TOracleSession $05D8C140 End
Duration = 0.109
10/5/2012 11:00:30 AM MainForm Closed
10/5/2012 11:00:30 AM Destroying TSQLForm
10/5/2012 11:00:30 AM Destroyed TSQLForm
10/5/2012 11:00:30 AM Destroying TProcEditForm
10/5/2012 11:00:30 AM ContentsThread: Resume
10/5/2012 11:00:30 AM Destroyed TProcEditForm
10/5/2012 11:00:30 AM Destroying TCommandForm
10/5/2012 11:00:30 AM Destroyed TCommandForm
10/5/2012 11:00:30 AM ChangeUserPref LogonHistory,
10/5/2012 11:00:30 AM ChangeUserPref DSA,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref ColumnAssociations,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref ImportAssociations,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref BrowserFilters,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref FileBrowserFolders,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Connections,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref BrowserFolders,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref SessionQueries,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref ExternalTools,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Documents,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref Reports,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM ChangeUserPref CurrentConnections,
10/5/2012 11:00:30 AM ChangeUserPref end
10/5/2012 11:00:30 AM PreferenceSet.Save
10/5/2012 11:00:30 AM PreferenceSet Filename = C:\Users\csauer\AppData\Roaming\PLSQL Developer\Preferences\csauer\user.prefs
10/5/2012 11:00:30 AM PreferenceSet AltFile = user.prefs
10/5/2012 11:00:30 AM PreferenceSet.Save end
10/5/2012 11:00:30 AM Docking forms Destroying
10/5/2012 11:00:30 AM MainForm Destroying
10/5/2012 11:00:30 AM MainForm Destroyed
10/5/2012 11:00:30 AM Finalization HTMLUnit
10/5/2012 11:00:30 AM Finalization HTMLUnit done
10/5/2012 11:00:31 AM Finalization PLSCommon
10/5/2012 11:00:31 AM Finalization PLSCommon done
10/5/2012 11:00:31 AM Finalization HTMLUnit
10/5/2012 11:00:31 AM Finalization HTMLUnit done
10/5/2012 11:00:31 AM Finalization DBObjectUnit
10/5/2012 11:00:31 AM Finalization DBObjectUnit done
10/5/2012 11:00:31 AM Finalization PlanUnit
10/5/2012 11:00:31 AM Finalization PlanUnit done
10/5/2012 11:00:31 AM Finalization RepUnit
10/5/2012 11:00:31 AM Finalization RepUnit done
10/5/2012 11:00:31 AM Finalization ReportCommon
10/5/2012 11:00:31 AM Finalization ReportCommon done
10/5/2012 11:00:31 AM Finalization MacroUnit
10/5/2012 11:00:31 AM Finalization MacroUnit done
10/5/2012 11:00:31 AM Finalization StatUnit
10/5/2012 11:00:31 AM Finalization StatUnit done
10/5/2012 11:00:31 AM Finalization TotalRecallUnit
10/5/2012 11:00:31 AM Finalization TotalRecallUnit done
10/5/2012 11:00:31 AM Finalization RowExportUnit
10/5/2012 11:00:31 AM Finalization RowExportUnit done

 

[chucks]

Seems like it gets disconnected, and then takes 26 seconds or more to reconnect each open window?

 

[tsuChris]

I too ran into this today.
I have been a daily user of pl/sql Developer for 8 years and this is the first time it has happened.
It is happening to me on 2 different machines so I would guess it is something with oracle.
I have a session going from yesterday and it is alright. I tried to use it on a different machine and ran into the problem. Tried starting a new session on machine 1 and duplicated it over there.

 

[tsuChris]

To clarify, I can use PL/SQL developer on other machines logging in to the same instance that I am prevented from logging in to from the 2 desktops in my office.