intialization taking more time

[venrao08]

Hi,

Intialisation tiaking more time while executing any sql querry,

The same working fine in sqlplus and sql-developer.

 

[venrao08]

Hi,

Intialisation tiaking more time while executing any sql querry,

The same working fine in sqlplus and sql-developer.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 13\plsqldev.exe" DebugSQL

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

 

[venrao08]

Debug File:

PL/SQL Developer
Version 12.0.8.1840 (32 bit)
Windows 10 (64-bit) Build 16299

Physical memory : 4,100,248 kB (1,026,932 available)
Paging file : 9,080,984 kB (3,651,424 available)
Virtual memory : 2,097,024 kB (1,820,584 available)

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

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

Preference Files

Debug file
C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins

Process
Working Set = 84,787,200
Memory = 32,375,516
GDI Objects = 346
User Objects = 222
Handles = 289

Monitor
PixelsPerInch = 144

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

25-05-2019 07:10:31 Debug started

00:00:00.028 InitPreferences
00:00:00.052 Load C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\default = 0
00:00:00.053 PreferenceSet.Load C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
00:00:00.066 PreferenceSet.Load OK
00:00:00.067 Determine LocalPrefPath
00:00:00.068 [1]: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences
00:00:00.069 LocalPrefPath: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08
00:00:00.070 Load C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08 = 0
00:00:00.070 PreferenceSet.Load C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08\default.ini
00:00:00.075 PreferenceSet.Load OK
00:00:00.077 PreferenceSet.Load C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08\user.prefs
00:00:00.086 PreferenceSet.Load OK
00:00:00.086 InitPreferences end
00:00:00.088 SortPreferenceSets
00:00:00.088 - Default venrao08
00:00:00.089 - System Default
00:00:00.225 UpdateConnections
00:00:00.226 UpdateConnectionsChildList start
00:00:00.226 UpdateConnectionsChildList ConnectionFolders.Count = 1
00:00:00.226 UpdateConnectionsChildList CheckList.Count = 1
00:00:00.227 UpdateConnectionsChildList RemoveList.Count = 0
00:00:00.227 UpdateConnectionsChildList EndUpdate
00:00:00.227 UpdateConnectionsChildList end
00:00:00.228 DoUpdateChildList starts
00:00:00.260 Lock
00:00:00.260 UnLock
00:00:00.260
00:00:00.261 25-05-2019 07:10:32 Debug stopped
00:00:00.261
00:00:00.305 pfReadRegistry(PL/SQL Developer 12\Shell\Open\Command, )
00:00:00.305 ReadString Faled
00:00:00.306 pfReadRegistry:
00:00:00.306 CalculateToolbarGlyphs (DPI = 144)
00:00:00.685 CalculateToolbarGlyphs done
00:00:01.179 Splash: Starting PL/SQL Developer 12
00:00:01.181 Splash: Version 12.0.8.1840 (32 bit)
00:00:01.182 LoadPreferences
00:00:01.183 LoadPreferences searching for default
00:00:01.183 C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08\default.ini
00:00:01.183 LoadPreferences NewPref := nil
00:00:01.184 LoadPreferences
00:00:01.184 LoadPreferences Reading preferences
00:00:01.186 Splash: Reading preferences
00:00:01.211 FormResize
00:00:01.241 FormResize
00:00:01.247 LoadPreferences ReadPosition
00:00:01.309 FormResize
00:00:01.448 LoadPreferences ToolsBrowserItemClick(nil)
00:00:01.449 LoadPreferences CreateBrowserFilters...
00:00:01.450 LoadPreferences Files
00:00:01.450 LoadPreferences Printer
00:00:01.451 LoadPreferences FileBrowserFolders
00:00:01.451 LoadPreferences Connections
00:00:01.452 LoadPreferences BrowserFolders
00:00:01.453 LoadPreferences
00:00:01.453 LoadPreferences end
00:00:01.644 MacroLibFilename: C:\Program Files (x86)\PLSQL Developer 12\Macro\venrao08.emlib
00:00:01.698 Splash: Reading keywords
00:00:01.700 GetRootFile: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\default.kwf
00:00:01.709 Logging on..
00:00:01.722 Creating new session
00:00:01.723 Initializing new session
00:00:01.723 Setting new session parameters
00:00:01.724 Setting logon session
00:00:01.725 OCI Initialization starts
00:00:01.800 OCI Initialization done
00:00:01.801 OCIDLL forced to D:\app\mf\product\11.2.0\client_1\bin\oci.dll
00:00:01.801 Logon2 starting
00:00:01.802 Logon2.Execute starts
00:00:15.518 TOracleSession $0A398130 Start Session.LogOn as mana0809@PROD
00:00:17.074 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
00:00:17.077 TOracleQuery Query End (1 record processed)
Duration = 0
00:00:17.078 TOracleSession $0A398130 End
Duration = 1.547
00:00:17.083 Logon2.Execute done
00:00:17.083 Logon2 done
00:00:17.084 TOracleQuery $094E0EC0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
00:00:17.085 TOracleQuery $094E0EC0 End (1 record processed)
Duration = 0
00:00:17.086 TOracleSession $0A397E50 Start Session.LogOn as mana0809@PROD
00:00:17.193 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
00:00:17.197 TOracleQuery Query End (1 record processed)
Duration = 0
00:00:17.198 TOracleSession $0A397E50 End
Duration = 0.11
00:00:17.202 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
00:00:17.203 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
00:00:17.204 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
00:00:17.205 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
00:00:17.206 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
00:00:17.206 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
00:00:17.208 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
00:00:17.209 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
00:00:17.209 TOracleQuery $094E1020 Start Query.Execute
SQL = begin :n := user; end;
:N = Null
00:00:17.210 TOracleQuery $094E0940 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = MANA0809
00:00:17.213 TOracleQuery $094E1020 End
Duration = 0
00:00:17.213 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
00:00:17.265 TOracleQuery Query End (5 records processed)
Duration = 0.047
00:00:17.266 LogonHistorySave start
00:00:17.266 ChangeUserPref LogonHistory,
00:00:17.267 ChangeUserPref end
00:00:17.268 ChangeUserPref DSA,
00:00:17.268 ChangeUserPref end
00:00:17.269 ChangeUserPref ColumnAssociations,
00:00:17.269 ChangeUserPref end
00:00:17.269 ChangeUserPref ImportAssociations,
00:00:17.270 ChangeUserPref end
00:00:17.270 ChangeUserPref BrowserFilters,
00:00:17.271 ChangeUserPref end
00:00:17.272 ChangeUserPref FileBrowserFolders,
00:00:17.272 ChangeUserPref end
00:00:17.272 ChangeUserPref Connections,
00:00:17.273 ChangeUserPref end
00:00:17.273 ChangeUserPref BrowserFolders,
00:00:17.274 ChangeUserPref end
00:00:17.274 ChangeUserPref SessionQueries,
00:00:17.274 ChangeUserPref end
00:00:17.275 ChangeUserPref ExternalTools,
00:00:17.275 ChangeUserPref end
00:00:17.275 ChangeUserPref Documents,
00:00:17.276 ChangeUserPref end
00:00:17.276 ChangeUserPref WebSearches,
00:00:17.277 ChangeUserPref end
00:00:17.277 ChangeUserPref Reports,
00:00:17.277 ChangeUserPref end
00:00:17.278 ChangeUserPref CurrentConnections,
00:00:17.278 ChangeUserPref end
00:00:17.278 PreferenceSet.Save
00:00:17.279 PreferenceSet Filename = C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Preferences\venrao08\user.prefs
00:00:17.279 PreferenceSet AltFile = user.prefs
00:00:17.281 PreferenceSet.Save end
00:00:17.281 LogonHistorySave end
00:00:17.283 Splash: connected
00:00:17.284 FormCreate Logon.Executed -1
00:00:17.285 FormCreate SessionChanged
00:00:17.297 TOracleQuery $094E1020 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
00:00:17.301 TOracleQuery $094E1020 End (1 record processed)
Duration = 0.016
00:00:17.301 SessionChanged SetDBAViews
00:00:17.302 TOracleQuery $094E1020 Start Query.Execute
SQL = select null from all_synonyms where 1=0
00:00:17.306 TOracleQuery $094E1020 End (0 records processed)
Duration = 0
00:00:17.307 TOracleQuery $094E1020 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
00:00:17.343 TOracleQuery $094E1020 End (0 records processed)
Duration = 0.031
00:00:17.346 SessionChanged Authorizations.Load
00:00:17.347 SessionChanged EnableAuthorizedMenus
00:00:17.347 WindowAllowed(1)
00:00:17.347 WindowAllowed done
00:00:17.348 WindowAllowed(1)
00:00:17.348 WindowAllowed done
00:00:17.348 ExecuteConnectScript starts
00:00:17.349 GetRootFile: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\AfterConnect.sql
00:00:17.349 TOracleQuery $094E1020 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
00:00:17.351 TOracleQuery $094E1020 End (1 record processed)
Duration = 0
00:00:17.352 TOracleQuery $094E1020 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
00:00:17.353 TOracleQuery $094E1020 End
Duration = 0
00:00:17.353 TOracleQuery $094E1020 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
00:00:17.354 TOracleQuery $094E1020 End
Duration = 0
00:00:17.354 TOracleQuery $094E1020 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
00:00:17.356 TOracleQuery $094E1020 End
Duration = 0
00:00:17.356 ExecuteConnectScript ends
00:00:17.386 SetSessionAction starts: Primary Session
00:00:17.386 TOracleQuery $094E1020 Start Query.Execute
SQL = select null from dual
00:00:17.430 TOracleQuery $094E1020 End (1 record processed)
Duration = 0.047
00:00:17.431 TOracleQuery $094E1020 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
00:00:17.436 TOracleQuery $094E1020 End
Duration = 0
00:00:17.436 SetSessionAction ends
00:00:17.505 SessionChanged LoadRecentObjects
00:00:17.520 SessionChanged Logoff secondary sessions
00:00:17.523 SessionChanged
OCIDLL forced to D:\app\mf\product\11.2.0\client_1\bin\oci.dll
00:00:17.524 SessionChanged Notify children
00:00:17.524 SessionChanged EnableChildFunctions
00:00:17.530 Lock
00:00:17.530 UnLock
00:00:17.531 UpdateChildList starts
00:00:17.766 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.547
00:00:17.769 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:17.881 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.109
00:00:17.882 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.001 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.11
00:00:18.002 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.015 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.016 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.019 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.020 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.027 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.028 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.033 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:18.034 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.049 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.050 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.061 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.062 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.066 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.068 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.071 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.072 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.076 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.077 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.078 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.079 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.081 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.082 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.083 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.084 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.086 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.087 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.089 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.090 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.107 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.108 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.133 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:18.134 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.139 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.140 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.161 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:18.162 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.165 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.166 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.169 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.170 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.175 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.176 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.181 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.182 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.208 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:18.209 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.217 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.218 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.234 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.235 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.240 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.241 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.286 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.046
00:00:18.287 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.307 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.308 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.322 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.323 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.325 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.326 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.337 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:18.338 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.343 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.344 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.376 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.032
00:00:18.378 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.472 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.094
00:00:18.475 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.531 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:18.535 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.564 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.568 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.570 Splash: .
00:00:18.606 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:18.607 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.626 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.627 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.657 FormResize
00:00:18.667 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:18.668 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.676 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.677 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.694 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.695 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.766 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.062
00:00:18.767 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.772 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.773 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.783 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:18.784 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.795 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.797 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.809 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.810 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.848 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:18.849 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.859 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.860 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.860 ReadTemplateFiles C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Template
00:00:18.912 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.062
00:00:18.913 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.920 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.921 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.929 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.930 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.937 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.938 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.949 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:18.949 ReadTemplateFiles Done
00:00:18.950 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.954 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.955 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.963 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.964 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.968 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:18.969 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:18.969 SortPreferenceSets
00:00:18.970 - Default venrao08
00:00:18.970 - System Default
00:00:18.978 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.002 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.009 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.010 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.018 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.019 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.027 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.030 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.031 TOracleQuery $094E0C00 Start Query.Execute
SQL = select null from all_synonyms where 1=0
00:00:19.034 TOracleQuery $094E0C00 End (0 records processed)
Duration = 0.015
00:00:19.035 TOracleQuery $094E0C00 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
00:00:19.037 TOracleQuery $094E0C00 End (0 records processed)
Duration = 0
00:00:19.038 Lock
00:00:19.039 UnLock
00:00:19.043 UpdateConnections
00:00:19.074 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.076 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.078 Adding new connection
00:00:19.079 Username = mana0809
00:00:19.079 Database = PROD
00:00:19.080 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.080 Adding new connection
00:00:19.080 Username = sme
00:00:19.081 Database = PROD
00:00:19.081 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.081 Adding new connection
00:00:19.082 Username = skydb
00:00:19.082 Database = HISTDB
00:00:19.083 Adding new connection
00:00:19.083 Username = backup2
00:00:19.083 Database = HISTDB
00:00:19.084 Adding new connection
00:00:19.084 Username = lms_cl
00:00:19.084 Database = PROD
00:00:19.085 Adding new connection
00:00:19.085 Username = mafiljobs
00:00:19.085 Database = PROD
00:00:19.086 Adding new connection
00:00:19.086 Username = apps
00:00:19.087 Database = APPLPROD
00:00:19.087 Adding new connection
00:00:19.087 Username = kpmg
00:00:19.088 Database = PROD
00:00:19.088 Adding new connection
00:00:19.089 Username = mana2018
00:00:19.089 Database = PROD
00:00:19.089 Adding new connection
00:00:19.090 Username = apps
00:00:19.090 Database = APPLDEV
00:00:19.091 Adding new connection
00:00:19.091 Username = mana0809
00:00:19.091 Database = UATDBNW
00:00:19.092 Adding new connection
00:00:19.092 Username = kpmg
00:00:19.092 Database = MBISDBDR
00:00:19.093 Adding new connection
00:00:19.093 Username = mafiljobs
00:00:19.094 Database = MBISDBDR
00:00:19.094 Adding new connection
00:00:19.095 Username = mana2014
00:00:19.095 Database = PROD
00:00:19.096 Adding new connection
00:00:19.096 Username = temp_table
00:00:19.096 Database = PROD
00:00:19.097 Adding new connection
00:00:19.098 Username = mana2017
00:00:19.098 Database = PROD
00:00:19.099 Adding new connection
00:00:19.099 Username = mana2016
00:00:19.099 Database = PROD
00:00:19.100 Adding new connection
00:00:19.100 Username = mana2015
00:00:19.101 Database = PROD
00:00:19.101 Adding new connection
00:00:19.102 Username = MIS
00:00:19.102 Database = PROD
00:00:19.103 Adding new connection
00:00:19.103 Username = mana0809
00:00:19.103 Database = MBISDBDR
00:00:19.104 Adding new connection
00:00:19.105 Username = apps
00:00:19.105 Database = APPLDR
00:00:19.106 Adding new connection
00:00:19.106 Username = apps
00:00:19.106 Database = APPLPRODR
00:00:19.107 Adding new connection
00:00:19.107 Username = XXMA
00:00:19.108 Database = APPLPROD
00:00:19.109 Adding new connection
00:00:19.109 Username = mana0708
00:00:19.109 Database = HISTDB
00:00:19.110 Adding new connection
00:00:19.111 Username = apps
00:00:19.111 Database = APPSIT
00:00:19.112 Adding new connection
00:00:19.112 Username = mana2015
00:00:19.113 Database = MBISDBDR
00:00:19.114 Adding new connection
00:00:19.114 Username = mana2014
00:00:19.114 Database = MBISDBDR
00:00:19.115 Adding new connection
00:00:19.116 Username = mana2012
00:00:19.116 Database = HISTDB
00:00:19.117 Adding new connection
00:00:19.117 Username = mana2011
00:00:19.118 Database = HISTDB
00:00:19.119 Adding new connection
00:00:19.119 Username = mana0809
00:00:19.119 Database = HISTDB
00:00:19.120 Adding new connection
00:00:19.121 Username = biaproddb
00:00:19.121 Database = BITESTDB
00:00:19.121 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.032
00:00:19.122 Adding new connection
00:00:19.122 Username = mana0809
00:00:19.123 Database = PROD1
00:00:19.123 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.123 UpdateConnectionsChildList start
00:00:19.125 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:19.125 UpdateConnectionsChildList CheckList.Count = 35
00:00:19.130 UpdateConnectionsChildList RemoveList.Count = 0
00:00:19.130 UpdateConnectionsChildList EndUpdate
00:00:19.131 UpdateConnectionsChildList end
00:00:19.133 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.135 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.174 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.178 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.192 DoUpdateChildList starts
00:00:19.193 Lock
00:00:19.193 UnLock
00:00:19.193
00:00:19.194 25-05-2019 07:10:51 Debug stopped
00:00:19.194
00:00:19.198 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.199 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.209 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.211 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.244 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.032
00:00:19.245 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.256 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.257 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.264 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.265 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.270 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.271 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.278 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.279 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.320 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.322 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.331 FormShow Starts
00:00:19.331 GetCrashList
00:00:19.331 C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\PLS-Recovery
00:00:19.332 GetCrashList: 131804.cfg
00:00:19.332 GetCrashList: 2884592.cfg
00:00:19.332 GetCrashList: 590870.cfg
00:00:19.333 GetCrashList: 135578.cfg
00:00:19.334 Splash: Loading Desktop
00:00:19.335 LoadDesktop starts
00:00:19.335 LoadDesktop Window = -1
00:00:19.378 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.062
00:00:19.380 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.415 LoadDesktop DoUpdateChildList starts
00:00:19.416 DoUpdateChildList starts
00:00:19.416 LoadDesktop DoUpdateChildList ends
00:00:19.416 LoadDesktop ends
00:00:19.418 Splash: Finished
00:00:19.419 FormActivate start
00:00:19.428 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.431 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.515 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.078
00:00:19.517 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.549 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:19.551 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.563 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.565 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.595 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.596 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.608 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.609 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.650 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.651 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.673 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.674 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.715 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:19.716 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.726 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.727 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.736 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.737 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.757 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.763 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.771 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.773 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.797 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:19.800 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.806 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:19.807 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.817 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.818 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.851 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:19.853 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.890 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:19.891 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.911 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:19.915 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.955 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:19.956 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.980 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.983 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:19.997 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:19.998 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.146 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.156
00:00:20.147 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.166 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:20.167 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.191 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.032
00:00:20.193 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.285 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.093
00:00:20.287 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.297 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:20.299 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.307 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:20.308 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.315 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:20.317 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.328 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:20.330 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.337 FormResize
00:00:20.340 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:20.341 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.349 FormActivate end
00:00:20.349 FormShow Ends
00:00:20.385 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:20.386 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.388 WMUpdatePopups starts
00:00:20.411 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:20.413 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.420 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:20.423 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.438 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:20.442 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.480 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:20.481 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.505 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:20.506 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.527 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:20.529 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.552 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:20.553 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.574 Initialize Clipboard History starts
00:00:20.613 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.063
00:00:20.614 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.632 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:20.633 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.652 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:20.654 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:20.681 TOracleQuery $094E0940 End (50 records processed)
Duration = 0.031
00:00:20.706 TOracleQuery $094E0940 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = MANA0809
00:00:21.780 Initialize Clipboard History done
00:00:21.836 DoUpdateChildList starts
00:00:21.837 DoUpdateChildList Lock
00:00:21.837 Lock
00:00:21.838 UnLock
00:00:21.838 UpdateConnectionsChildList start
00:00:21.839 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:21.840 UpdateConnectionsChildList CheckList.Count = 35
00:00:21.841 UpdateConnectionsChildList RemoveList.Count = 0
00:00:21.842 UpdateConnectionsChildList EndUpdate
00:00:21.847 UpdateConnectionsChildList end
00:00:21.847 DoUpdateChildList UnLock
00:00:21.848 DoUpdateChildList ends
00:00:21.865 UpdateConnections
00:00:21.867 Adding new connection
00:00:21.867 Username = mana0809
00:00:21.868 Database = PROD
00:00:21.868 Adding new connection
00:00:21.868 Username = sme
00:00:21.869 Database = PROD
00:00:21.869 Adding new connection
00:00:21.869 Username = skydb
00:00:21.870 Database = HISTDB
00:00:21.870 Adding new connection
00:00:21.871 Username = backup2
00:00:21.871 Database = HISTDB
00:00:21.871 Adding new connection
00:00:21.872 Username = lms_cl
00:00:21.872 Database = PROD
00:00:21.872 Adding new connection
00:00:21.873 Username = mafiljobs
00:00:21.873 Database = PROD
00:00:21.873 Adding new connection
00:00:21.874 Username = apps
00:00:21.874 Database = APPLPROD
00:00:21.875 Adding new connection
00:00:21.875 Username = kpmg
00:00:21.875 Database = PROD
00:00:21.876 Adding new connection
00:00:21.876 Username = mana2018
00:00:21.876 Database = PROD
00:00:21.878 Adding new connection
00:00:21.878 Username = apps
00:00:21.879 Database = APPLDEV
00:00:21.879 Adding new connection
00:00:21.879 Username = mana0809
00:00:21.880 Database = UATDBNW
00:00:21.880 Adding new connection
00:00:21.881 Username = kpmg
00:00:21.881 Database = MBISDBDR
00:00:21.882 Adding new connection
00:00:21.882 Username = mafiljobs
00:00:21.882 Database = MBISDBDR
00:00:21.883 Adding new connection
00:00:21.883 Username = mana2014
00:00:21.884 Database = PROD
00:00:21.885 Adding new connection
00:00:21.885 Username = temp_table
00:00:21.885 Database = PROD
00:00:21.886 Adding new connection
00:00:21.886 Username = mana2017
00:00:21.886 Database = PROD
00:00:21.887 Adding new connection
00:00:21.888 Username = mana2016
00:00:21.888 Database = PROD
00:00:21.889 Adding new connection
00:00:21.889 Username = mana2015
00:00:21.889 Database = PROD
00:00:21.890 Adding new connection
00:00:21.890 Username = MIS
00:00:21.891 Database = PROD
00:00:21.891 Adding new connection
00:00:21.892 Username = mana0809
00:00:21.892 Database = MBISDBDR
00:00:21.896 Adding new connection
00:00:21.896 Username = apps
00:00:21.896 Database = APPLDR
00:00:21.897 Adding new connection
00:00:21.898 Username = apps
00:00:21.898 Database = APPLPRODR
00:00:21.899 Adding new connection
00:00:21.899 Username = XXMA
00:00:21.900 Database = APPLPROD
00:00:21.901 Adding new connection
00:00:21.901 Username = mana0708
00:00:21.901 Database = HISTDB
00:00:21.902 Adding new connection
00:00:21.903 Username = apps
00:00:21.903 Database = APPSIT
00:00:21.904 Adding new connection
00:00:21.904 Username = mana2015
00:00:21.905 Database = MBISDBDR
00:00:21.906 Adding new connection
00:00:21.906 Username = mana2014
00:00:21.906 Database = MBISDBDR
00:00:21.907 Adding new connection
00:00:21.908 Username = mana2012
00:00:21.908 Database = HISTDB
00:00:21.909 Adding new connection
00:00:21.910 Username = mana2011
00:00:21.910 Database = HISTDB
00:00:21.911 Adding new connection
00:00:21.911 Username = mana0809
00:00:21.912 Database = HISTDB
00:00:21.913 Adding new connection
00:00:21.913 Username = biaproddb
00:00:21.913 Database = BITESTDB
00:00:21.915 Adding new connection
00:00:21.915 Username = mana0809
00:00:21.915 Database = PROD1
00:00:21.916 UpdateConnectionsChildList start
00:00:21.917 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:21.917 UpdateConnectionsChildList CheckList.Count = 35
00:00:21.919 UpdateConnectionsChildList RemoveList.Count = 0
00:00:21.919 UpdateConnectionsChildList EndUpdate
00:00:21.920 UpdateConnectionsChildList end
00:00:21.930 WMUpdatePopups ends
00:00:24.430 ThreadedDownload forhttps://www.allroundautomations.com/update/pls.updates starts
00:00:24.437 ThreadedDownload done
00:00:24.438 WebUpdate.DownloadTextFile: URL=https://www.allroundautomations.com/update/pls.updates
00:00:24.439 WebUpdate.DownloadTextFile: DST=C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Update
00:00:24.439 WebUpdate.DownloadTextFile: FILE=C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Update\pls.updates
00:00:24.441 WebUpdate.URLDownload starts
00:00:25.615 TOracleQuery $094E0940 End (100 records processed)
Duration = 4.907
00:00:25.618 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.620 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.621 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.623 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.624 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.626 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.628 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.630 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.632 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.634 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.636 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.638 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.639 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.641 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.643 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.645 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.647 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.656 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:25.657 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.659 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.015
00:00:25.661 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.677 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:25.678 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.724 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:25.725 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.841 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.109
00:00:25.843 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.881 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:25.883 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.893 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:25.895 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:25.960 WebUpdate.URLDownload ends: True
00:00:25.961 WebUpdate.DownloadTextFile done
00:00:25.971 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.062
00:00:25.974 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.020 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.047
00:00:26.021 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.091 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.062
00:00:26.093 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.097 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:26.100 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.135 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:26.138 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.161 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:26.163 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:26.178 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:26.180 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:28.378 TOracleQuery $094E0940 End (100 records processed)
Duration = 2.203
00:00:28.381 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:28.685 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.297
00:00:28.686 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:28.708 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:28.710 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:28.724 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:28.725 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:28.877 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.141
00:00:28.878 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:30.974 ThreadedDownload forhttps://www.allroundautomations.com/update/pls.news starts
00:00:30.979 ThreadedDownload done
00:00:30.979 WebUpdate.DownloadTextFile: URL=https://www.allroundautomations.com/update/pls.news
00:00:30.980 WebUpdate.DownloadTextFile: DST=C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Update
00:00:30.980 WebUpdate.DownloadTextFile: FILE=C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Update\pls.news
00:00:30.980 WebUpdate.URLDownload starts
00:00:31.006 TOracleQuery $094E0940 End (100 records processed)
Duration = 2.125
00:00:31.007 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.103 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.094
00:00:31.106 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.111 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:31.112 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.116 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:31.117 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.121 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:31.122 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.152 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:31.154 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.187 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.031
00:00:31.189 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.199 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:31.201 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.204 TOracleQuery $094E0940 End (100 records processed)
Duration = 0
00:00:31.206 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.223 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.016
00:00:31.225 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:31.270 WebUpdate.URLDownload ends: True
00:00:31.272 WebUpdate.DownloadTextFile done
00:00:31.300 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.078
00:00:31.302 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:32.189 TOracleQuery $094E0940 End (100 records processed)
Duration = 0.875
00:00:32.193 TOracleQuery $094E0940 Start Query.Next for up to 100 records
00:00:33.477 TOracleQuery $094E0940 End (22 records processed)
Duration = 1.281
00:00:33.478 TOracleQuery $094E0940 Start Query.Execute
SQL =
select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema
or o.owner = 'PUBLIC'
:SCHEMA = MANA0809
00:00:33.580 TOracleQuery $094E0940 End (3 records processed)
Duration = 0.094
00:00:33.582 TOracleSession $0A397E50 Start Session.LogOff
00:00:33.586 TOracleSession $0A397E50 End
Duration = 0
00:00:43.885 Lock
00:00:43.886 UnLock
00:00:43.887 UpdateConnectionsChildList start
00:00:43.890 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:43.891 UpdateConnectionsChildList CheckList.Count = 35
00:00:43.893 UpdateConnectionsChildList RemoveList.Count = 0
00:00:43.893 UpdateConnectionsChildList EndUpdate
00:00:43.899 UpdateConnectionsChildList end
00:00:47.914 Create TSQLForm Start
00:00:47.939 Create TSQLForm Inherited
00:00:48.264 TSQLForm.FormCreate Start
00:00:48.337 SQLForm
00:00:48.348 TSQLForm.FormCreate Finished
00:00:48.474 Create TSQLForm SetupMainFont
00:00:48.479 Create TSQLForm Activate
00:00:48.480 UpdateChildList starts
00:00:48.481 UpdateChildList [timer]
00:00:48.481 UpdateChildList ends
00:00:48.481 Create TSQLForm Activate done
00:00:48.482 Create TSQLForm UpdateWindowList
00:00:48.482 UpdateChildList starts
00:00:48.482 UpdateChildList [timer]
00:00:48.482 UpdateChildList ends
00:00:48.483 Create TSQLForm Positioning
00:00:48.556 Create TSQLForm Finished
00:00:48.557 ExecuteTemplateByName: Default\SQL Window
00:00:48.567 ExecuteTemplate: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Template\Default\SQL Window.tpl
00:00:48.568 Path: C:\Users\venrao08\AppData\Roaming\PLSQL Developer 12\Template\Default\SQL Window.tpl
00:00:48.581 Lock
00:00:48.582 UnLock
00:00:48.585 Lock
00:00:48.586 UnLock
00:00:48.600 Lock
00:00:48.601 UnLock
00:00:48.607 Lock
00:00:48.608 UnLock
00:00:48.609 UpdateConnectionsChildList start
00:00:48.612 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:48.612 UpdateConnectionsChildList CheckList.Count = 35
00:00:48.615 UpdateConnectionsChildList RemoveList.Count = 0
00:00:48.616 UpdateConnectionsChildList EndUpdate
00:00:48.622 UpdateConnectionsChildList end
00:00:48.623 NavigationBookmarks.EnableButtons(Rebuild)
00:00:48.623 NavigationBookmarks: Backward=0, Forward=0
00:00:48.624 WindowAllowed(3)
00:00:48.624 WindowAllowed done
00:00:48.624 WindowAllowed(2)
00:00:48.624 WindowAllowed done
00:00:48.625 WindowAllowed(6)
00:00:48.625 WindowAllowed done
00:00:48.625 WindowAllowed(4)
00:00:48.626 WindowAllowed done
00:00:48.626 WindowAllowed(5)
00:00:48.626 WindowAllowed done
00:00:48.689 DoUpdateChildList starts
00:00:48.689 DoUpdateChildList Lock
00:00:48.706 Lock
00:00:48.709 UnLock
00:00:48.709 UpdateConnectionsChildList start
00:00:48.711 UpdateConnectionsChildList ConnectionFolders.Count = 35
00:00:48.712 UpdateConnectionsChildList CheckList.Count = 35
00:00:48.714 UpdateConnectionsChildList RemoveList.Count = 0
00:00:48.715 UpdateConnectionsChildList EndUpdate
00:00:48.721 UpdateConnectionsChildList end
00:00:48.721 DoUpdateChildList UnLock
00:00:48.732 DoUpdateChildList ends
00:00:50.063 Lock
00:00:50.065 UnLock
00:00:50.117 CurrentStatement:
select inst_id,
count(*)
from gv$session t
where t.USERNAME is not null
group by inst_id;
00:00:51.629 SQLForm Initializing...
00:00:51.632 SetConnected starts
00:00:51.633 SetConnected: Connect starts
00:00:51.634 TOracleSession $0D24CDA0 Start Session.LogOn as mana0809@PROD
00:00:51.775 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
00:00:51.781 TOracleQuery Query End (1 record processed)
Duration = 0
00:00:51.782 TOracleSession $0D24CDA0 End
Duration = 0.141
00:00:51.783 SetConnected: (Dis)connect ends
00:00:51.785 SetSessionAction starts: SQL Window
00:00:51.786 TOracleQuery $094E0520 Start Query.Execute
SQL = select null from dual
00:00:51.790 TOracleQuery $094E0520 End (1 record processed)
Duration = 0
00:00:51.791 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
00:00:51.803 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
00:00:51.804 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
00:00:51.806 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
00:00:51.807 TOracleQuery $094E0520 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window
00:00:51.810 TOracleQuery $094E0520 End
Duration = 0
00:00:51.810 SetSessionAction ends
00:00:51.811 ExecuteConnectScript starts
00:00:51.819 TOracleQuery $094E0520 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
00:00:51.821 TOracleQuery $094E0520 End
Duration = 0
00:00:51.823 TOracleQuery $094E0520 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
00:00:51.824 TOracleQuery $094E0520 End
Duration = 0
00:00:51.826 TOracleQuery $094E0520 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
00:00:51.828 TOracleQuery $094E0520 End
Duration = 0
00:00:51.828 ExecuteConnectScript ends
00:00:51.828 TOracleQuery $094E0520 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
00:00:51.835 TOracleQuery $094E0520 End (1 record processed)
Duration = 0.015
00:00:51.835 EnableOutput starts
00:00:51.835 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enablesize);
end if;
end;
:ENABLE = 1
:SIZE = 10000
00:00:51.837 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
00:00:51.837 EnableOutput done
00:00:51.837 InitStatistics starts
00:00:51.838 TStatistics.Init starts
00:00:51.840 InitStatNames starts
00:00:51.841 select name from v$statname order by statistic#
00:00:51.841 TOracleQuery $09430130 Start Query.Execute
SQL = select name from v$statname order by statistic#
00:00:51.858 TOracleQuery $09430130 End (501 records processed)
Duration = 0.016
00:00:51.859 TOracleQuery $09430130 Start Query.Next for up to 501 records
00:00:51.861 TOracleQuery $09430130 End (137 records processed)
Duration = 0
00:00:51.861 638 statistics found
00:00:51.861 StatQuery.ReadBuffer = 639
00:00:51.862 InitStatNames ends
00:00:51.862 StatQuery.Describe starts
00:00:51.862 TOracleQuery $094E0520 Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
00:00:51.865 TOracleQuery $094E0520 End
Duration = 0.016
00:00:51.865 StatQuery.Describe ends
00:00:51.866 TStatistics.Init ends
00:00:51.866 StartValues: StatQuery.ReadBuffer = 639
00:00:51.866 StartValues: StatQuery.ReadBuffer set to 639
00:00:51.866 TOracleQuery $094E0520 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 634
00:00:51.870 TOracleQuery $094E0520 End (638 records processed)
Duration = 0
00:00:51.875 InitStatistics ends
00:00:51.876 CreateQueryTabs starts
00:00:51.941 SQL Window Height = 766
00:00:51.941 SQL Grid Height = 565
00:00:51.942 SQL Panel Height = 201
00:00:51.946 GotoQueryTab 0
00:00:51.946 GotoQueryTab: QueryTabControlChanging
00:00:51.946 GotoQueryTab: QueryTabControlChange
00:00:51.946 QueryTabControlChange: Grid
00:00:51.947 QueryTabControlChange: Show EditPanel 1
00:00:51.949 QueryTabControlChange: Hide Grids 1
00:00:51.950 QueryTabControlChange: Hide Grids 2
00:00:51.950 QueryTabControlChange: GetTableName
00:00:51.950 QueryTabControlChange: SQLMessage =
00:00:51.951 GotoQueryTab done
00:00:51.951 CreateQueryTabs ends
00:00:51.954 NavigationBookmarks.EnableButtons(Rebuild)
00:00:51.955 NavigationBookmarks: Backward=0, Forward=0
00:00:51.955 WindowAllowed(3)
00:00:51.955 WindowAllowed done
00:00:51.956 WindowAllowed(2)
00:00:51.956 WindowAllowed done
00:00:51.956 WindowAllowed(6)
00:00:51.956 WindowAllowed done
00:00:51.957 WindowAllowed(4)
00:00:51.957 WindowAllowed done
00:00:51.957 WindowAllowed(5)
00:00:51.957 WindowAllowed done
00:00:51.963 Lock
00:00:51.964 UnLock
00:00:51.964 SQLForm Executing...
00:00:52.003 GotoQueryTab 0
00:00:52.003 GotoQueryTab: QueryTabControlChanging
00:00:52.004 GotoQueryTab: QueryTabControlChange
00:00:52.004 QueryTabControlChange: Grid
00:00:52.004 QueryTabControlChange: Show EditPanel 1
00:00:52.005 QueryTabControlChange: Hide Grids 1
00:00:52.005 QueryTabControlChange: Hide Grids 2
00:00:52.006 QueryTabControlChange: GetTableName
00:00:52.006 QueryTabControlChange: SQLMessage =
00:00:52.007 GotoQueryTab done
00:00:52.010 SQLForm Executing...
00:00:52.052 Lock
00:00:52.053 TSQLThread SQLThread.Execute
00:00:52.053 TSQLThread SQLThread runs
00:00:52.054 TSQLThread SQLThread loop start
00:00:52.054 UnLock
00:00:52.054 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
00:00:52.055 UpdateConnectionsChildList start
00:00:52.057 UpdateConnectionsChildList ConnectionFolders.Count = 36
00:00:52.057 UpdateConnectionsChildList CheckList.Count = 36
00:00:52.059 UpdateConnectionsChildList RemoveList.Count = 0
00:00:52.060 UpdateConnectionsChildList EndUpdate
00:00:52.065 UpdateConnectionsChildList end
00:00:52.097 TOracleQuery Query End
Duration = 0.031
00:00:52.097 TOracleQuery $09430290 Start Query.Execute
SQL = select inst_id,
count(*)
from gv$session t
where t.USERNAME is not null
group by inst_id
00:00:52.152 TOracleQuery $09430290 End (2 records processed)
Duration = 0.063
00:00:52.158 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM gv$session
00:00:52.170 TOracleQuery SQLForm.TestQuery End
Duration = 0.015
00:00:52.188 TOracleQuery $09430130 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
00:00:52.190 TOracleQuery $09430130 End (1 record processed)
Duration = 0
00:00:52.190 TOracleQuery $094303F0 Start Query.Execute
SQL = declare
c integer := 0;
p1 varchar2(500);
p2 varchar2(500);
expr varchar2(500);
dblink varchar2(500);
part1_type integer;
object_number integer;
dp integer;
guard_error exception;
pragma exception_init(guard_error, -16224);
begin
bject_type := null;
bject_owner := null;
bject_name := null;
:sub_object := null;
expr := art1;
if art2 is not null then expr := expr || '.' || art2; end if;
if art3 is not null then expr := expr || '.' || art3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => bject_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then bject_type := 'INDEX'; end if;
if part1_type = 2 then bject_type := 'TABLE'; end if;
if part1_type = 4 then bject_type := 'VIEW'; end if;
if part1_type = 5 then bject_type := 'SYNONYM'; end if;
if part1_type = 6 then bject_type := 'SEQUENCE'; end if;
if part1_type = 7 then bject_type := 'PROCEDURE'; end if;
if part1_type = 8 then bject_type := 'FUNCTION'; end if;
if part1_type = 9 then bject_type := 'PACKAGE'; end if;
if part1_type = 12 then bject_type := 'TRIGGER'; end if;
if part1_type = 13 then bject_type := 'TYPE'; end if;
if part1_type = 28 then bject_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then bject_type := 'JAVA CLASS'; end if;
if bject_type is null then
select object_type into bject_type
from sys.all_objects
where object_id = object_number;
end if;
exception
when guard_error then
raise;
when others then
null;
end;
c := c + 1;
if c > 9 then
dp := instr(expr, '.', -1);
if dp > 0 then
if :sub_object is not null then
:sub_object := '.' || :sub_object;
end if;
:sub_object := upper(substr(expr, dp + 1)) || :sub_object;
expr := substr(expr, 1, dp - 1);
c := 0;
end if;
end if;
exit when object_type is not null) or (c > 9);
end loop;
if bject_type is not null then
if p1 is null then
bject_name := p2;
elsif p2 is null then
bject_name := p

 

[Marco Kalter]

Can you send the file as e-mail attachment to support@allroundautomations.com? It seems to be truncated here.

 

[venrao08]

Hi Marco,

Attachment sent in mail. Please check.

Regards,
Venkataramana
9642393303

 

[venrao08]

Hi Marco,

Attachment sent in mail. Please check.

Regards,
Venkataramana
9642393303

 

[Marco Kalter]

The attachment seems to be removed from the e-mail. Can you resend?