Unable to break queries after execution

I

iamtrombone

Member
I am running PL/SQL v9 and whenever I run a query, regardless of its length, I lose the ability to break the query. It says Initializing... then Executing... then PL/SQL fades to opaque white and says (Not Responding) at in the title bar (I have Windows 7). The query still runs because if I leave it sit (depending on the complexity of the query) it will return with data, no data, or exceed call limit as I have a resource limit for the DB I am on.

I did not have this issue when I have version 8. I just downloaded version 10 (beta) and tried it and I still have the same issue. I've seen other posts about this before but they were of little help to me.

Can anyone help me out here? Does it have anything to do with the version of Oracle I am running on my computer? Other people don't seem to have this problem. I currently have Oracle 11g Release 2.
 
Can you check if your "Session Mode" preference is set to "Single Session" (Tools > Preferences > Oracle / Connection). If so, set it to "Dual Session" or "Multi Session", restart PL/SQL Developer, and try again.
 
I changed it to Dual Mode. The screen doesn't initially freeze when I execute a query. The timer does start ticking. But the moment I click anywhere inside the PL/SQL software, it freezes, goes white, says Not Responding, and will not become active again until the query finishes or timeout occurs. Any ideas?
 
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).
 
I can't seem to re-create this phenomenon all of a sudden. The log I sent to you was of an instance when the screen did freeze and not unfreeze until the query finished. Since then I am able to run a query and click anywhere and kill the query at any point...very strange.
 
Hello, I can recreate this issue, because is happening to me all the time. some times I can break the query doing close window and when the message box comes up I say yes, until I got a message box with buttons but empty names. But some times I need to kill all process and start over again.

I did your suggestion about DEBUGSQL, but nothing happened
 
Sorry, this is the debug file. I found it inside PL/SQL directory:

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

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,962,216 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

3/1/2013 11:45:23 AM Application started
3/1/2013 11:45:23 AM InitPreferences
3/1/2013 11:45:23 AM Load C:\Program Files (x86)\PLSQL Developer\Preferences\Default = 0
3/1/2013 11:45:23 AM PreferenceSet.Load C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
3/1/2013 11:45:23 AM PreferenceSet.Load OK
3/1/2013 11:45:23 AM Determine LocalPrefPath
3/1/2013 11:45:23 AM [1]: C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences
3/1/2013 11:45:23 AM LocalPrefPath: C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210
3/1/2013 11:45:23 AM Load C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210 = 0
3/1/2013 11:45:23 AM PreferenceSet.Load C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210\default.ini
3/1/2013 11:45:23 AM PreferenceSet.Load OK
3/1/2013 11:45:23 AM PreferenceSet.Load C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210\user.prefs
3/1/2013 11:45:23 AM PreferenceSet.Load OK
3/1/2013 11:45:23 AM InitPreferences end
3/1/2013 11:45:23 AM SortPreferenceSets
3/1/2013 11:45:23 AM - Default E498210
3/1/2013 11:45:23 AM - System Default
3/1/2013 11:45:23 AM DoUpdateChildList
3/1/2013 11:45:23 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
3/1/2013 11:45:23 AM ReadString OK
3/1/2013 11:45:23 AM pfReadRegistry: "C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe" "%1"
3/1/2013 11:45:23 AM LoadPreferences
3/1/2013 11:45:23 AM LoadPreferences searching for default
3/1/2013 11:45:23 AM C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210\default.ini
3/1/2013 11:45:23 AM LoadPreferences NewPref := nil
3/1/2013 11:45:23 AM LoadPreferences
3/1/2013 11:45:23 AM LoadPreferences Reading preferences
3/1/2013 11:45:23 AM LoadPreferences ReadPosition
3/1/2013 11:45:23 AM LoadPreferences ToolsBrowserItemClick(nil)
3/1/2013 11:45:23 AM LoadPreferences CreateBrowserFilters...
3/1/2013 11:45:23 AM LoadPreferences Files
3/1/2013 11:45:23 AM LoadPreferences Buttons
3/1/2013 11:45:23 AM LoadPreferences Printer
3/1/2013 11:45:23 AM LoadPreferences FileBrowserFolders
3/1/2013 11:45:23 AM LoadPreferences Connections
3/1/2013 11:45:23 AM LoadPreferences BrowserFolders
3/1/2013 11:45:23 AM LoadPreferences
3/1/2013 11:45:23 AM LoadPreferences end
3/1/2013 11:45:23 AM MacroLibFilename: C:\Program Files (x86)\PLSQL Developer\Macro\E498210.emlib
3/1/2013 11:45:31 AM TOracleSession $059C0990 Start Session.LogOn as rdbmx_site@YPFDEMO
3/1/2013 11:45:41 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/1/2013 11:45:41 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleSession $059C0990 End
Duration = 10.218
3/1/2013 11:45:41 AM TOracleQuery $059693C0 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
3/1/2013 11:45:41 AM TOracleQuery $059693C0 End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleSession $059C0C30 Start Session.LogOn as rdbmx_site@YPFDEMO
3/1/2013 11:45:41 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/1/2013 11:45:41 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleSession $059C0C30 End
Duration = 0.032
3/1/2013 11:45:41 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/1/2013 11:45:41 AM TOracleQuery Query End (5 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 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 = RDBMX_SITE
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Result = ORA-00942: table or view does not exist
Duration = 0
3/1/2013 11:45:41 AM LogonHistorySave start
3/1/2013 11:45:41 AM ChangeUserPref LogonHistory,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM ChangeUserPref DSA,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref ColumnAssociations,
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref ImportAssociations,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref BrowserFilters,
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref FileBrowserFolders,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM ChangeUserPref Connections,
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM ChangeUserPref BrowserFolders,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref SessionQueries,
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref ExternalTools,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref Documents,
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM ChangeUserPref Reports,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM ChangeUserPref CurrentConnections,
3/1/2013 11:45:41 AM ChangeUserPref end
3/1/2013 11:45:41 AM PreferenceSet.Save
3/1/2013 11:45:41 AM PreferenceSet Filename = C:\Users\e498210\AppData\Roaming\PLSQL Developer\Preferences\E498210\user.prefs
3/1/2013 11:45:41 AM PreferenceSet AltFile = user.prefs
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM PreferenceSet.Save end
3/1/2013 11:45:41 AM LogonHistorySave end
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM FormCreate Logon.Executed -1
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM FormCreate SessionChanged
3/1/2013 11:45:41 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery Query End (5 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM SessionChanged SetDBAViews
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 End (54 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969520 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 = RDBMX_SITE
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (25 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Next for up to 25 records
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (5 records processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969260 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969260 End
Duration = 0.015
3/1/2013 11:45:41 AM TOracleQuery $05969260 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969260 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969260 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969260 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_scheduler_jobs where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_scheduler_program_args where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_scheduler_job_args where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_scheduler_wingroup_members where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Describe
SQL = select * from sys.dba_scheduler_windows where rownum < 1
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM SessionChanged Authorizations.Load
3/1/2013 11:45:41 AM SessionChanged EnableAuthorizedMenus
3/1/2013 11:45:41 AM WindowAllowed(1)
3/1/2013 11:45:41 AM WindowAllowed done
3/1/2013 11:45:41 AM WindowAllowed(1)
3/1/2013 11:45:41 AM WindowAllowed done
3/1/2013 11:45:41 AM ExecuteConnectScript starts
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM ExecuteConnectScript ends
3/1/2013 11:45:41 AM SetSessionAction starts: Primary Session
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from dual
3/1/2013 11:45:41 AM TOracleQuery $05969100 End (1 record processed)
Duration = 0
3/1/2013 11:45:41 AM TOracleQuery $05969100 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
3/1/2013 11:45:41 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:41 AM SetSessionAction ends
3/1/2013 11:45:41 AM SessionChanged LoadRecentObjects
3/1/2013 11:45:41 AM SessionChanged Notify children
3/1/2013 11:45:41 AM SessionChanged Logoff secondary sessions
3/1/2013 11:45:41 AM SessionChanged EnableChildFunctions
3/1/2013 11:45:41 AM SessionChanged
OCIDLL forced to C:\app\e498210\product\11.2.0\client_1\bin\oci.dll
3/1/2013 11:45:41 AM Lock
3/1/2013 11:45:41 AM UnLock
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0.546
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (100 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 Start Query.Next for up to 100 records
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (91 records processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleQuery $05969520 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 = RDBMX_SITE
3/1/2013 11:45:42 AM TOracleQuery $05969520 End (1 record processed)
Duration = 0
3/1/2013 11:45:42 AM TOracleSession $059C0C30 Start Session.LogOff
3/1/2013 11:45:43 AM TOracleSession $059C0C30 End
Duration = 1.061
3/1/2013 11:45:44 AM SortPreferenceSets
3/1/2013 11:45:44 AM - Default E498210
3/1/2013 11:45:44 AM - System Default
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/1/2013 11:45:44 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/1/2013 11:45:44 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:44 AM Lock
3/1/2013 11:45:44 AM UnLock
3/1/2013 11:45:44 AM DoUpdateChildList
3/1/2013 11:45:44 AM FormActivate start
3/1/2013 11:45:44 AM FormActivate end
3/1/2013 11:45:44 AM WMUpdatePopups starts
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = rdbmx_site
3/1/2013 11:45:44 AM Database = YPFDEMO
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = RDBMX_SITE
3/1/2013 11:45:44 AM Database = PLUSPETROLVM
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = RDBMX
3/1/2013 11:45:44 AM Database = pluspetrolVM
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = sys
3/1/2013 11:45:44 AM Database = PluSPETROLVM
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = System
3/1/2013 11:45:44 AM Database = PluSPETROLVM
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = rdbmx_site
3/1/2013 11:45:44 AM Database = CGY-PM-VM4
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = rdbmx
3/1/2013 11:45:44 AM Database = YPFDEMO
3/1/2013 11:45:44 AM Adding new connection
3/1/2013 11:45:44 AM Username = rdbmx
3/1/2013 11:45:44 AM Database = CGY-PM-VM4
3/1/2013 11:45:44 AM LoadDesktop starts
3/1/2013 11:45:44 AM DoUpdateChildList
3/1/2013 11:45:44 AM Lock
3/1/2013 11:45:44 AM Lock
3/1/2013 11:45:44 AM UnLock
3/1/2013 11:45:44 AM UnLock
3/1/2013 11:45:44 AM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
3/1/2013 11:45:44 AM TOracleQuery Query End (5 records processed)
Duration = 0
3/1/2013 11:45:44 AM SessionChanged SetDBAViews
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from all_synonyms where 1=0
3/1/2013 11:45:44 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
3/1/2013 11:45:44 AM TOracleQuery $05969100 End (0 records processed)
Duration = 0
3/1/2013 11:45:44 AM SessionChanged Authorizations.Load
3/1/2013 11:45:44 AM SessionChanged ApplyPreferences
3/1/2013 11:45:44 AM SortPreferenceSets
3/1/2013 11:45:44 AM - Default E498210
3/1/2013 11:45:44 AM - System Default
3/1/2013 11:45:44 AM SessionChanged EnableAuthorizedMenus
3/1/2013 11:45:44 AM WindowAllowed(1)
3/1/2013 11:45:44 AM WindowAllowed done
3/1/2013 11:45:44 AM WindowAllowed(1)
3/1/2013 11:45:44 AM WindowAllowed done
3/1/2013 11:45:44 AM ExecuteConnectScript starts
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/1/2013 11:45:44 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/1/2013 11:45:44 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:44 AM ExecuteConnectScript ends
3/1/2013 11:45:44 AM SetSessionAction starts: Primary Session
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = select null from dual
3/1/2013 11:45:44 AM TOracleQuery $05969100 End (1 record processed)
Duration = 0
3/1/2013 11:45:44 AM TOracleQuery $05969100 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Primary Session
3/1/2013 11:45:44 AM TOracleQuery $05969100 End
Duration = 0
3/1/2013 11:45:44 AM SetSessionAction ends
3/1/2013 11:45:44 AM SessionChanged LoadRecentObjects
3/1/2013 11:45:44 AM SessionChanged Notify children
3/1/2013 11:45:44 AM SessionChanged Logoff secondary sessions
3/1/2013 11:45:44 AM SessionChanged EnableChildFunctions
3/1/2013 11:45:44 AM SessionChanged
OCIDLL forced to C:\app\e498210\product\11.2.0\client_1\bin\oci.dll
3/1/2013 11:45:44 AM Lock
3/1/2013 11:45:44 AM UnLock
3/1/2013 11:45:44 AM LoadDesktop ends
3/1/2013 11:45:44 AM WMUpdatePopups ends
3/1/2013 11:47:17 AM Create TSQLForm Start
3/1/2013 11:47:17 AM Create TSQLForm Inherited
3/1/2013 11:47:17 AM TSQLForm.FormCreate Start
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM SQLForm
3/1/2013 11:47:17 AM TSQLForm.FormCreate Finished
3/1/2013 11:47:17 AM Create TSQLForm SetupMainFont
3/1/2013 11:47:17 AM Create TSQLForm Activate
3/1/2013 11:47:17 AM UpdateChildList [timer]
3/1/2013 11:47:17 AM Create TSQLForm Activate done
3/1/2013 11:47:17 AM Create TSQLForm UpdateWindowList
3/1/2013 11:47:17 AM UpdateChildList [timer]
3/1/2013 11:47:17 AM Create TSQLForm Positioning
3/1/2013 11:47:17 AM Create TSQLForm Finished
3/1/2013 11:47:17 AM ExecuteTemplateByName: Default\SQL Window
3/1/2013 11:47:17 AM ExecuteTemplate: C:\Program Files (x86)\PLSQL Developer\Template\Default\SQL Window.tpl
3/1/2013 11:47:17 AM Path: C:\Program Files (x86)\PLSQL Developer\Template\Default\SQL Window.tpl
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:17 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:17 AM DoUpdateChildList
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM Lock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:17 AM UnLock
3/1/2013 11:47:18 AM Lock
3/1/2013 11:47:18 AM UnLock
3/1/2013 11:47:23 AM TOracleQuery $05968CE0 Start Query.Execute
SQL = select 'x' from dual
3/1/2013 11:47:23 AM TOracleQuery $05968CE0 End (1 record processed)
Duration = 0
3/1/2013 11:47:26 AM TOracleQuery $05968CE0 Start Query.Execute
SQL = select 'x' from dual
3/1/2013 11:47:26 AM TOracleQuery $05968CE0 End (1 record processed)
Duration = 0
3/1/2013 11:47:38 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:38 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:40 AM SQLForm Initializing...
3/1/2013 11:47:40 AM SetConnected starts
3/1/2013 11:47:40 AM SetConnected: Connect starts
3/1/2013 11:47:40 AM TOracleSession $059C3630 Start Session.LogOn as rdbmx_site@YPFDEMO
3/1/2013 11:47:40 AM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
3/1/2013 11:47:40 AM TOracleQuery Query End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM TOracleSession $059C3630 End
Duration = 0.125
3/1/2013 11:47:40 AM SetConnected: (Dis)connect ends
3/1/2013 11:47:40 AM SetSessionAction starts: SQL Window - New
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select null from dual
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
3/1/2013 11:47:40 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
3/1/2013 11:47:40 AM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End
Duration = 0
3/1/2013 11:47:40 AM SetSessionAction ends
3/1/2013 11:47:40 AM ExecuteConnectScript starts
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End
Duration = 0
3/1/2013 11:47:40 AM ExecuteConnectScript ends
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM EnableOutput starts
3/1/2013 11:47:40 AM TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
:ENABLE = 1
:SIZE = 10000
3/1/2013 11:47:40 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
3/1/2013 11:47:40 AM EnableOutput done
3/1/2013 11:47:40 AM InitStatistics starts
3/1/2013 11:47:40 AM TStatistics.Init starts
3/1/2013 11:47:40 AM InitStatNames starts
3/1/2013 11:47:40 AM select name from v$statname order by statistic#
3/1/2013 11:47:40 AM TOracleQuery $03EFF1F0 Start Query.Execute
SQL = select name from v$statname order by statistic#
3/1/2013 11:47:40 AM TOracleQuery $03EFF1F0 End (347 records processed)
Duration = 0
3/1/2013 11:47:40 AM 347 statistics found
3/1/2013 11:47:40 AM StatQuery.ReadBuffer = 348
3/1/2013 11:47:40 AM InitStatNames ends
3/1/2013 11:47:40 AM StatQuery.Describe starts
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End
Duration = 0
3/1/2013 11:47:40 AM StatQuery.Describe ends
3/1/2013 11:47:40 AM TStatistics.Init ends
3/1/2013 11:47:40 AM StartValues: StatQuery.ReadBuffer = 348
3/1/2013 11:47:40 AM StartValues: StatQuery.ReadBuffer set to 348
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 137
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End (347 records processed)
Duration = 0
3/1/2013 11:47:40 AM InitStatistics ends
3/1/2013 11:47:40 AM CreateQueryTabs starts
3/1/2013 11:47:40 AM SQL Window Height = 638
3/1/2013 11:47:40 AM SQL Grid Height = 559
3/1/2013 11:47:40 AM SQL Panel Height = 79
3/1/2013 11:47:40 AM GotoQueryTab 0
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:40 AM GotoQueryTab done
3/1/2013 11:47:40 AM CreateQueryTabs ends
3/1/2013 11:47:40 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:40 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:40 AM Lock
3/1/2013 11:47:40 AM UnLock
3/1/2013 11:47:40 AM SQLForm Executing...
3/1/2013 11:47:40 AM Lock
3/1/2013 11:47:40 AM UnLock
3/1/2013 11:47:40 AM GotoQueryTab 0
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:40 AM GotoQueryTab done
3/1/2013 11:47:40 AM SQLForm Executing...
3/1/2013 11:47:40 AM TSQLThread SQLThread.Execute
3/1/2013 11:47:40 AM TSQLThread SQLThread runs
3/1/2013 11:47:40 AM TSQLThread SQLThread loop start
3/1/2013 11:47:40 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
3/1/2013 11:47:40 AM TOracleQuery Query End
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery $03EFF090 Start Query.Execute
SQL = select * from rdbmx.resources_vt where resource_id = 18716
3/1/2013 11:47:40 AM TOracleQuery $03EFF090 End (1 record processed)
Duration = 0
3/1/2013 11:47:40 AM TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM rdbmx.resources_vt
3/1/2013 11:47:40 AM TOracleQuery SQLForm.TestQuery End
Duration = 0
3/1/2013 11:47:40 AM TSQLThread SQLThread loop end
3/1/2013 11:47:40 AM TSQLThread SQLThread loop done
3/1/2013 11:47:40 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
3/1/2013 11:47:40 AM TOracleQuery Query End
Duration = 0
3/1/2013 11:47:40 AM TSQLThread SQLThread transaction management done
3/1/2013 11:47:40 AM TSQLThread SQLThread Postmessage
3/1/2013 11:47:40 AM TSQLThread SQLThread Suspend
3/1/2013 11:47:40 AM TSQLForm.ThreadFinished
3/1/2013 11:47:40 AM TSQLForm.ThreadFinished: SQLThread.Suspended
3/1/2013 11:47:40 AM SQLForm 1 row selected in 0.016 seconds
3/1/2013 11:47:40 AM Lock
3/1/2013 11:47:40 AM UnLock
3/1/2013 11:47:40 AM EndValues: StatQuery.ReadBuffer = 348
3/1/2013 11:47:40 AM EndValues: StatQuery.ReadBuffer set to 348
3/1/2013 11:47:40 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 137
3/1/2013 11:47:40 AM TOracleQuery $05968E40 End (347 records processed)
Duration = 0
3/1/2013 11:47:40 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:40 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:40 AM TOracleQuery $03EFF350 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
3/1/2013 11:47:40 AM TOracleQuery $03EFF350 End
Duration = 0
3/1/2013 11:47:40 AM GotoQueryTab -1
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:40 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:40 AM SQLForm 1 row selected in 0.016 seconds
3/1/2013 11:47:40 AM GotoQueryTab done
3/1/2013 11:47:57 AM TOracleQuery $03EFF350 Start Query.Execute
SQL = select 'x' from dual
3/1/2013 11:47:57 AM TOracleQuery $03EFF350 End (1 record processed)
Duration = 0
3/1/2013 11:47:59 AM SQLForm Initializing...
3/1/2013 11:47:59 AM SetConnected starts
3/1/2013 11:47:59 AM Already connected: check connection
3/1/2013 11:47:59 AM TOracleQuery $03EFF350 Start Query.Execute
SQL = select 'x' from dual
3/1/2013 11:47:59 AM TOracleQuery $03EFF350 End (1 record processed)
Duration = 0.016
3/1/2013 11:47:59 AM Using existing connection
3/1/2013 11:47:59 AM EnableOutput starts
3/1/2013 11:47:59 AM TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute
SQL = begin
if :enable = 0 then
sys.dbms_output.disable;
else
sys.dbms_output.enable(:size);
end if;
end;
:ENABLE = 1
:SIZE = 10000
3/1/2013 11:47:59 AM TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0
3/1/2013 11:47:59 AM EnableOutput done
3/1/2013 11:47:59 AM InitStatistics starts
3/1/2013 11:47:59 AM TOracleQuery $03EFF350 Start Query.Execute
SQL = select 'x' from dual
3/1/2013 11:47:59 AM TOracleQuery $03EFF350 End (1 record processed)
Duration = 0
3/1/2013 11:47:59 AM StartValues: StatQuery.ReadBuffer = 348
3/1/2013 11:47:59 AM StartValues: StatQuery.ReadBuffer set to 348
3/1/2013 11:47:59 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 137
3/1/2013 11:47:59 AM TOracleQuery $05968E40 End (347 records processed)
Duration = 0
3/1/2013 11:47:59 AM InitStatistics ends
3/1/2013 11:47:59 AM CreateQueryTabs starts
3/1/2013 11:47:59 AM GotoQueryTab 0
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:59 AM GotoQueryTab done
3/1/2013 11:47:59 AM CreateQueryTabs ends
3/1/2013 11:47:59 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:59 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:59 AM Lock
3/1/2013 11:47:59 AM UnLock
3/1/2013 11:47:59 AM SQLForm Executing...
3/1/2013 11:47:59 AM Lock
3/1/2013 11:47:59 AM UnLock
3/1/2013 11:47:59 AM GotoQueryTab 0
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:59 AM GotoQueryTab done
3/1/2013 11:47:59 AM SQLForm Executing...
3/1/2013 11:47:59 AM TSQLThread SQLThread Suspend ended
3/1/2013 11:47:59 AM TSQLThread SQLThread runs
3/1/2013 11:47:59 AM TSQLThread SQLThread loop start
3/1/2013 11:47:59 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
3/1/2013 11:47:59 AM TOracleQuery Query End
Duration = 0
3/1/2013 11:47:59 AM TOracleQuery $03EFF090 Start Query.Execute
SQL = select * from rdbmx.rsrc_case_qpmcsi_vt where resource_id = 18716 and case_id = 3871
3/1/2013 11:47:59 AM TOracleQuery $03EFF090 End (6 records processed)
Duration = 0
3/1/2013 11:47:59 AM TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM rdbmx.rsrc_case_qpmcsi_vt
3/1/2013 11:47:59 AM TOracleQuery SQLForm.TestQuery End
Duration = 0
3/1/2013 11:47:59 AM TSQLThread SQLThread loop end
3/1/2013 11:47:59 AM TSQLThread SQLThread loop done
3/1/2013 11:47:59 AM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
3/1/2013 11:47:59 AM TOracleQuery Query End
Duration = 0
3/1/2013 11:47:59 AM TSQLThread SQLThread transaction management done
3/1/2013 11:47:59 AM TSQLThread SQLThread Postmessage
3/1/2013 11:47:59 AM TSQLThread SQLThread Suspend
3/1/2013 11:47:59 AM TSQLForm.ThreadFinished
3/1/2013 11:47:59 AM TSQLForm.ThreadFinished: SQLThread.Suspended
3/1/2013 11:47:59 AM SQLForm 6 rows selected in 0.047 seconds
3/1/2013 11:47:59 AM Lock
3/1/2013 11:47:59 AM UnLock
3/1/2013 11:47:59 AM EndValues: StatQuery.ReadBuffer = 348
3/1/2013 11:47:59 AM EndValues: StatQuery.ReadBuffer set to 348
3/1/2013 11:47:59 AM TOracleQuery $05968E40 Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 137
3/1/2013 11:47:59 AM TOracleQuery $05968E40 End (347 records processed)
Duration = 0
3/1/2013 11:47:59 AM NavigationBookmarks.EnableButtons(Rebuild)
3/1/2013 11:47:59 AM NavigationBookmarks: Backward=0, Forward=0
3/1/2013 11:47:59 AM TOracleQuery $03EFF1F0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
3/1/2013 11:47:59 AM TOracleQuery $03EFF1F0 End
Duration = 0
3/1/2013 11:47:59 AM GotoQueryTab -1
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChanging
3/1/2013 11:47:59 AM GotoQueryTab: QueryTabControlChange
3/1/2013 11:47:59 AM SQLForm 6 rows selected in 0.047 seconds
3/1/2013 11:47:59 AM GotoQueryTab done
3/1/2013 11:48:04 AM TOracleQuery $03EFF350 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
3/1/2013 11:48:04 AM TOracleQuery $03EFF350 End (1 record processed)
Duration = 0
3/1/2013 11:48:04 AM TOracleQuery $03EFF1F0 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
:object_type := null;
:object_owner := null;
:object_name := null;
:sub_object := null;
expr := :part1;
if :part2 is not null then expr := expr || '.' || :part2; end if;
if :part3 is not null then expr := expr || '.' || :part3; end if;
loop
begin
sys.dbms_utility.name_resolve(name => expr,
context => c,
schema => :object_owner,
part1 => p1,
part2 => p2,
dblink => dblink,
part1_type => part1_type,
object_number => object_number);
if part1_type = 1 then :object_type := 'INDEX'; end if;
if part1_type = 2 then :object_type := 'TABLE'; end if;
if part1_type = 4 then :object_type := 'VIEW'; end if;
if part1_type = 5 then :object_type := 'SYNONYM'; end if;
if part1_type = 6 then :object_type := 'SEQUENCE'; end if;
if part1_type = 7 then :object_type := 'PROCEDURE'; end if;
if part1_type = 8 then :object_type := 'FUNCTION'; end if;
if part1_type = 9 then :object_type := 'PACKAGE'; end if;
if part1_type = 12 then :object_type := 'TRIGGER'; end if;
if part1_type = 13 then :object_type := 'TYPE'; end if;
if part1_type = 28 then :object_type := 'JAVA SOURCE'; end if;
if part1_type = 29 then :object_type := 'JAVA CLASS'; end if;
if :object_type is null then
select object_type into :object_type
from sys.dba_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 :object_type is not null then
if p1 is null then
:object_name := p2;
elsif p2 is null then
:object_name := p1;
if :object_name = :part1 and :part2 is not null then
:sub_object := :part2;
end if;
if :object_name = :part2 and :part3 is not null then
:sub_object := :part3;
end if;
else
:object_name := p1;
:sub_object := p2;
end if;
return;
end if;
begin
if :part2 is null and :part3 is null then
select 'USER', null, :part1
into :object_type, :object_owner, :object_name
from sys.dba_users u
where u.username = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
begin
if :part2 is null and :part3 is null and :deep != 0 then
select 'ROLE', null, :part1
into :object_type, :object_owner, :object_name
from sys.session_roles r
where r.role = :part1
and rownum = 1;
return;
end if;
exception
when no_data_found then
null;
end;
if :deep != 0 then
begin
if :part2 is null then
select constraint_type, owner, constraint_name
into :object_type, :object_owner, :object_name
from sys.dba_constraints c
where c.constraint_name = :part1
and c.owner = :cur_schema
and rownum = 1;
else
select constraint_type, owner, constraint_name, :part3
into :object_type, :object_owner, :object_name, :sub_object
from sys.dba_constraints c
where c.constraint_name = :part2
and c.owner = :part1
and rownum = 1;
end if;
if :object_type = 'P' then
:object_type := 'PRIMARY KEY';
end if;
if :object_type = 'U' then
:object_type := 'UNIQUE KEY';
end if;
if :object_type = 'R' then
:object_type := 'FOREIGN KEY';
end if;
if :object_type = 'C' then
:object_type := 'CHECK CONSTRAINT';
end if;
return;
exception
when no_data_found then
null;
end;
end if;
end;
:PART1 = RDBMX
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 = RSRC_CASE_QPMCSI_VT
:SUB_OBJECT = Null
:PART3 =
:DEEP = 0
:CUR_SCHEMA = RDBMX_SITE
3/1/2013 11:48:04 AM TOracleQuery $03EFF1F0 End
Duration = 0
3/1/2013 11:48:04 AM TOracleQuery $03EFF1F0 Start Query.Execute
SQL = select col.*, com.Comments
from sys.dba_tab_columns col,
sys.dba_col
 
If the GUI doesn't work to stop a query, I do the following to get a list of processes:

SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.osuser,
s.username,
s.program,
s.action
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND';

Then I use:
ALTER SYSTEM KILL SESSION 'sid,serial#';
e.g. ALTER SYSTEM KILL SESSION '2795,3859';
 
You must log in or register to reply here.

Similar threads

koja
  • Discussion Discussion
Large data editor displays CRLF independent of setting read LF as CR/LF from the database
Replies
1
Views
106
Marco Kalter
Marco Kalter
M
  • Discussion Discussion
How to close a Command Window automatically after execution?
Replies
1
Views
283
Marco Kalter
Marco Kalter
Z
  • Discussion Discussion
Enhancement : Query By Example at multiple tabs at the same time
Replies
3
Views
438
Marco Kalter
Marco Kalter
W
  • Discussion Discussion
Test Window shows old procedure / function Code after recompiling
Replies
9
Views
1K
William Robertson
William Robertson
V
PL/SQL Dev 16 UI is much slower than 15
Replies
7
Views
366
valentl
V
Back
Top