Copy&Paste hangs when select for update on windows7

J

Joeeeee

Member
* Must be played on Windows7
Prerequisite script needed for replaying.

drop table T cascade constraints;

create table T (a varchar2(20), b number);

insert into T
select object_name, rownum from all_objects where rownum New>SQL window), then execute script as below.

select * from T for update;

Press the padlock to change context in the grid as you know. After that select a string, for example select a string in Cell A1. then paste A2 Cell or wherever. PLSQLDeveloper do not response and is terminated some time later.

Best Regards.

My Environment
==============
Windows7 Professional K version 6.1 (build 7600)

PL/SQL Developer
Version 7.1.5.1398
31.55911 - 10 user license
Windows Vista 6.1 Build 7600

Physical memory : 2,095,544 kB (878,732 available)
Paging file : 4,191,088 kB (2,112,956 available)
Virtual memory : 2,097,024 kB (1,924,284 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\Cho\default.ini

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)
OraHome92 (C:\oracle\ora92)

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

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

Using (and we tried 10.2.0)
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Character Sets
Character size: 2 byte(s)
CharSetID: 840
NCharSetID: 2000
Unicode Support: True
NLS_LANG: KOREAN_KOREA.KO16MSWIN949
NLS_CHARACTERSET: KO16KSC5601
NLS_NCHAR_CHARACTERSET: AL16UTF16

From B.H Cho
Onmedia, S.Korea.
 
Last edited:
I cannot reproduce this. 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 attached what you suggested and replayed but I couldn't find any "C:\Users\Cho\AppData\Roaming\PLSQL Developer\debug.txt".
Any other suggestion?

The problem which I asked is happening exactly same way on my PC and my colleague's. it must be done on windows7.
 
Last edited:
Can you run PL/SQL Developer as administrator and try again? The vcsdebug.txt file should now be located in the PL/SQL Developer installation directory.
 
I tried to run PLSQLDeveloper as Administrator(actually, the attribute to run it as administrator was ON for the shortcut) but I couldn't find any vcsDebug.txt in the installation directory.

However, I found "Debug.txt" in the installation directory.

I hope it helps you.
===================
PL/SQL Developer
Version 7.1.5.1398
Windows Vista 6.1 Build 7600

Physical memory : 2,095,544 kB (842,812 available)
Paging file : 4,191,088 kB (2,166,116 available)
Virtual memory : 2,097,024 kB (1,966,492 available)

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

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

Preference Files

Plug-Ins

2010-06-08 오전 10:22:43 Application started
2010-06-08 오전 10:22:43 InitPreferences
2010-06-08 오전 10:22:43 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
2010-06-08 오전 10:22:43 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
2010-06-08 오전 10:22:43 PreferenceSet.Load OK
2010-06-08 오전 10:22:43 Determine LocalPrefPath
2010-06-08 오전 10:22:43 [1]: C:\Program Files\PLSQL Developer\Preferences
2010-06-08 오전 10:22:43 LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\Cho
2010-06-08 오전 10:22:43 Load C:\Program Files\PLSQL Developer\Preferences\Cho = 0
2010-06-08 오전 10:22:43 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Cho\default.ini
2010-06-08 오전 10:22:43 PreferenceSet.Load OK
2010-06-08 오전 10:22:43 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Cho\user.prefs
2010-06-08 오전 10:22:43 PreferenceSet.Load OK
2010-06-08 오전 10:22:43 InitPreferences end
2010-06-08 오전 10:22:43 SortPreferenceSets
2010-06-08 오전 10:22:43 - Default Cho
2010-06-08 오전 10:22:43 - System Default
2010-06-08 오전 10:22:43 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
2010-06-08 오전 10:22:43 ReadString OK
2010-06-08 오전 10:22:43 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
2010-06-08 오전 10:22:43 LoadPreferences
2010-06-08 오전 10:22:43 LoadPreferences searching for default
2010-06-08 오전 10:22:43 C:\Program Files\PLSQL Developer\Preferences\Cho\default.ini
2010-06-08 오전 10:22:43 LoadPreferences NewPref := nil
2010-06-08 오전 10:22:43 LoadPreferences
2010-06-08 오전 10:22:43 LoadPreferences Reading preferences
2010-06-08 오전 10:22:43 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
2010-06-08 오전 10:22:43 ReadString OK
2010-06-08 오전 10:22:43 pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
2010-06-08 오전 10:22:43 LoadPreferences ReadPosition
2010-06-08 오전 10:22:43 LoadPreferences ToolsBrowserItemClick(nil)
2010-06-08 오전 10:22:43 LoadPreferences CreateBrowserFilters...
2010-06-08 오전 10:22:43 LoadPreferences Files
2010-06-08 오전 10:22:43 LoadPreferences Logon
2010-06-08 오전 10:22:43 LoadPreferences Buttons
2010-06-08 오전 10:22:43 LoadPreferences Printer
2010-06-08 오전 10:22:43 LoadPreferences BrowserFolders
2010-06-08 오전 10:22:43 LoadPreferences
2010-06-08 오전 10:22:43 LoadPreferences end
2010-06-08 오전 10:22:43 MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\Cho.emlib
2010-06-08 오전 10:22:47 TOracleSession PLSQLDevForm.Session Start Session.LogOn as onsms@SMSTEST
2010-06-08 오전 10:22:48 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2010-06-08 오전 10:22:48 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2010-06-08 오전 10:22:48 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2010-06-08 오전 10:22:48 TOracleQuery Query End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:22:48 TOracleSession PLSQLDevForm.Session End
Duration = 0.562
2010-06-08 오전 10:22:48 LogonHistorySave start
2010-06-08 오전 10:22:48 ChangeUserPref LogonHistory,
2010-06-08 오전 10:22:48 ChangeUserPref DSA,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref ColumnAssociations,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref ImportAssociations,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref BrowserFilters,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref BrowserFolders,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref SessionQueries,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref ExternalTools,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref Documents,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 ChangeUserPref Reports,
2010-06-08 오전 10:22:48 ChangeUserPref end
2010-06-08 오전 10:22:48 LogonHistorySave end
2010-06-08 오전 10:22:48 FormCreate Session.Connected
2010-06-08 오전 10:22:48 FormCreate Logon.Executed -1
2010-06-08 오전 10:22:48 FormCreate TDBNames.Make
2010-06-08 오전 10:22:48 FormCreate SessionChanged
2010-06-08 오전 10:22:48 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
2010-06-08 오전 10:22:48 TOracleQuery Query End (5 records processed)
Duration = 0.016
2010-06-08 오전 10:22:48 SessionChanged SetDBAViews
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Execute
SQL = select null from all_synonyms where 1=0
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End (0 records processed)
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End (0 records processed)
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.dba_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (50 records processed)
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 50 records
2010-06-08 오전 10:22:48 TOracleQuery PLSQLDevForm.DynamicQuery End (33 records processed)
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_objects where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_tab_columns where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_col_comments where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_triggers where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_constraints where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_indexes where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_cons_columns where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.047
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_ind_columns where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.078
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_dependencies where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_tab_comments where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 Start Query.Describe
SQL = select * from sys.dba_sequences where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB0710 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_errors where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_views where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_synonyms where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_users where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_object_tables where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_type_attrs where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_type_methods where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.015
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_method_params where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_method_results where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.031
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_tab_privs where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0.016
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_clusters where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_libraries where rownum < 1
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:48 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_directories where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_jobs where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_db_links where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_mviews where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_snapshots where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_queues where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_queue_tables where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 Start Query.Describe
SQL = select * from sys.dba_types where rownum < 1
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Duration = 0
2010-06-08 오전 10:22:49 SessionChanged Authorizations.Load
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 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)
2010-06-08 오전 10:22:49 TOracleQuery $03DB05B0 End
Result = ORA-00942: 테이블 또는 뷰가 존재하지 않습니다
Duration = 0.031
2010-06-08 오전 10:22:49 SessionChanged EnableAuthorizedMenus
2010-06-08 오전 10:22:49 TOracleSession $05BB4D20 Start Session.LogOn as onsms@SMSTEST
2010-06-08 오전 10:22:49 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2010-06-08 오전 10:22:49 TOracleQuery Query End (1 record processed)
Duration = 0.047
2010-06-08 오전 10:22:49 TOracleSession $05BB4D20 End
Duration = 0.374
2010-06-08 오전 10:22:49 SetSessionAction starts: Main session
2010-06-08 오전 10:22:49 TOracleQuery $03DB0450 Start Query.Execute
SQL = select null from dual
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
2010-06-08 오전 10:22:49 TOracleQuery $03DB0450 End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB0450 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
2010-06-08 오전 10:22:49 TOracleQuery $03DB0450 End
Duration = 0
2010-06-08 오전 10:22:49 SetSessionAction ends
2010-06-08 오전 10:22:49 ExecuteConnectScript starts
2010-06-08 오전 10:22:49 ExecuteConnectScript ends
2010-06-08 오전 10:22:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.031
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.031
2010-06-08 오전 10:22:49 SessionChanged LoadRecentObjects
2010-06-08 오전 10:22:49 SessionChanged Notify children
2010-06-08 오전 10:22:49 SessionChanged Logoff secondary sessions
2010-06-08 오전 10:22:49 SessionChanged SessionMode = smMulti
2010-06-08 오전 10:22:49 SessionChanged EnableChildFunctions
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.078
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:49 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: C:\oracle\ora92
Found: oci.dll
Using: C:\oracle\ora92\bin\oci.dll
2010-06-08 오전 10:22:49 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:49 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.25
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (16 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.375
2010-06-08 오전 10:22:50 SortPreferenceSets
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 - Default Cho
2010-06-08 오전 10:22:50 - System Default
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0710 Start Query.Execute
SQL = select null from all_synonyms where 1=0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0710 End (0 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0710 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0710 End (0 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 WMUpdatePopups starts
2010-06-08 오전 10:22:50 LoadDesktop starts
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.031
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 LoadDesktop ends
2010-06-08 오전 10:22:50 WMUpdatePopups ends
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:50 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.64
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.078
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.016
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.031
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (100 records processed)
Duration = 0.015
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 Start Query.Next for up to 100 records
2010-06-08 오전 10:22:51 TOracleQuery $03DB0870 End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:22:51 TOracleSession $05BB4D20 Start Session.LogOff
2010-06-08 오전 10:22:51 TOracleSession $05BB4D20 End
Duration = 0.047
2010-06-08 오전 10:22:55 Create TSQLForm Start
2010-06-08 오전 10:22:55 Create TSQLForm Inherited
2010-06-08 오전 10:22:55 TSQLForm.FormCreate Start
2010-06-08 오전 10:22:55 SQLForm
2010-06-08 오전 10:22:55 TSQLForm.FormCreate Finished
2010-06-08 오전 10:22:55 Create TSQLForm SetupMainFont
2010-06-08 오전 10:22:55 Create TSQLForm Activate
2010-06-08 오전 10:22:55 Create TSQLForm Activate done
2010-06-08 오전 10:22:55 Create TSQLForm UpdateWindowList
2010-06-08 오전 10:22:55 Create TSQLForm Positioning
2010-06-08 오전 10:22:55 Create TSQLForm Finished
2010-06-08 오전 10:22:55 NavigationBookmarks.EnableButtons(Rebuild)
2010-06-08 오전 10:22:55 NavigationBookmarks: Backward=0, Forward=0
2010-06-08 오전 10:23:03 SQLForm Initializing...
2010-06-08 오전 10:23:03 SetConnected starts
2010-06-08 오전 10:23:03 SetConnected: Connect starts
2010-06-08 오전 10:23:03 TOracleSession $05BB79C0 Start Session.LogOn as onsms@SMSTEST
2010-06-08 오전 10:23:03 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
2010-06-08 오전 10:23:03 TOracleQuery Query End (1 record processed)
Duration = 0.063
2010-06-08 오전 10:23:03 TOracleSession $05BB79C0 End
Duration = 0.375
2010-06-08 오전 10:23:03 SetConnected: (Dis)connect ends
2010-06-08 오전 10:23:03 SetSessionAction starts: SQL Window - New
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 Start Query.Execute
SQL = select null from dual
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:23:03 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
2010-06-08 오전 10:23:03 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.046
2010-06-08 오전 10:23:03 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
2010-06-08 오전 10:23:03 TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = SQL Window - New
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 End
Duration = 0.031
2010-06-08 오전 10:23:03 SetSessionAction ends
2010-06-08 오전 10:23:03 ExecuteConnectScript starts
2010-06-08 오전 10:23:03 ExecuteConnectScript ends
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
2010-06-08 오전 10:23:03 TOracleQuery $05BF3C20 End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:23:03 EnableOutput starts
2010-06-08 오전 10:23:03 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
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.EnableOutputQuery End
Duration = 0.031
2010-06-08 오전 10:23:03 EnableOutput done
2010-06-08 오전 10:23:03 InitStatistics starts
2010-06-08 오전 10:23:03 TStatistics.Init starts
2010-06-08 오전 10:23:03 InitStatNames starts
2010-06-08 오전 10:23:03 select name from v$statname order by statistic#
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select name from v$statname order by statistic#
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.015
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.015
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.015
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:03 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.DynamicQuery End (25 records processed)
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Next for up to 25 records
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.DynamicQuery End (21 records processed)
Duration = 0.015
2010-06-08 오전 10:23:04 InitStatNames ends
2010-06-08 오전 10:23:04 StatQuery.Describe starts
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.StatQuery Start Query.Describe
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = Null
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.StatQuery End
Duration = 0.047
2010-06-08 오전 10:23:04 StatQuery.Describe ends
2010-06-08 오전 10:23:04 TStatistics.Init ends
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 1017
2010-06-08 오전 10:23:04 TOracleQuery PLSQLDevForm.StatQuery End (371 records processed)
Duration = 0.031
2010-06-08 오전 10:23:04 InitStatistics ends
2010-06-08 오전 10:23:04 NavigationBookmarks.EnableButtons(Rebuild)
2010-06-08 오전 10:23:04 NavigationBookmarks: Backward=0, Forward=0
2010-06-08 오전 10:23:04 SQLForm Executing...
2010-06-08 오전 10:23:04 SQLForm Executing...
2010-06-08 오전 10:23:04 TSQLThread SQLThread.Execute
2010-06-08 오전 10:23:04 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2010-06-08 오전 10:23:04 TOracleQuery Query End
Duration = 0.078
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Execute
SQL = select * from T for update
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.078
2010-06-08 오전 10:23:04 TOracleQuery SQLForm.TestQuery Start Query.Describe
SQL = SELECT * FROM T
2010-06-08 오전 10:23:04 TOracleQuery SQLForm.TestQuery End
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.031
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.015
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.047
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.015
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 End (1 record processed)
Duration = 0.031
2010-06-08 오전 10:23:04 SQLForm Executing... (10)
2010-06-08 오전 10:23:04 TOracleQuery $05BF3EE0 Start Query.Next for up to 1 record
2010-06-08 오전 10:23:05 TOracleQuery $05BF3EE0 End (0 records processed)
Duration = 1.248
2010-06-08 오전 10:23:05 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
2010-06-08 오전 10:23:05 TOracleQuery Query End
Duration = 0
2010-06-08 오전 10:23:05 TSQLThread SQLThread Postmessage
2010-06-08 오전 10:23:05 TSQLThread SQLThread Suspend
2010-06-08 오전 10:23:05 TSQLForm.ThreadFinished
2010-06-08 오전 10:23:05 TSQLForm.ThreadFinished: SQLThread.Suspended
2010-06-08 오전 10:23:05 SQLForm 10 rows selected in 1.716 seconds
2010-06-08 오전 10:23:05 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 1017
2010-06-08 오전 10:23:06 TOracleQuery PLSQLDevForm.StatQuery End (371 records processed)
Duration = 0.016
2010-06-08 오전 10:23:06 NavigationBookmarks.EnableButtons(Rebuild)
2010-06-08 오전 10:23:06 NavigationBookmarks: Backward=0, Forward=0
2010-06-08 오전 10:23:06 TOracleQuery $05BF3D80 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
2010-06-08 오전 10:23:06 TOracleQuery $05BF3D80 End
Duration = 0
2010-06-08 오전 10:23:06 SQLForm 10 rows selected in 1.716 seconds
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 End (1 record processed)
Duration = 0.047
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ResolveSymbolQuery Start Query.Execute
SQL = declare

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

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

begin
:sub_object := null;
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;
:sub_object := :part2;
if (:part2 is null) or (:part1 != :cur_schema) then
begin
select object_type, :cur_schema, :part1
into :object_type, :object_owner, :object_name
from sys.dba_objects
where owner = :cur_schema
and object_name = :part1
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
if :object_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from dba_synonyms s
where s.synonym_name = :part1
and s.owner = :cur_schema
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
end if;
:sub_object := :part2;
if :part3 is not null then
:sub_object := :sub_object || '.' || :part3;
end if;
check_mview;
return;
exception
when no_data_found then null;
end;
end if;
begin
select s.table_owner, s.table_name
into t_owner, t_name
from dba_synonyms s
where s.synonym_name = :part1
and s.owner = 'PUBLIC'
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
:sub_object := :part3;
begin
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.dba_objects o
where o.owner = :part1
and o.object_name = :part2
and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
and rownum = 1;
check_mview;
return;
exception
when no_data_found then null;
end;
begin
if :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;
:object_owner := null;
:object_type := null;
:object_name := null;
:sub_object := null;
end;
:PART1 = T
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 =
:SUB_OBJECT = Null
:PART3 =
:DEEP = 0
:CUR_SCHEMA = ONSMS
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ResolveSymbolQuery End
Duration = 0.016
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Execute
SQL = select col.*, com.Comments
from sys.dba_tab_columns col,
sys.dba_col_comments com
where col.owner = 'ONSMS'
and col.table_name = 'T'
and com.Owner (+) = 'ONSMS'
and com.Table_Name (+) = 'T'
and com.Column_Name (+) = col.Column_Name
order by col.column_id
:TABLE_NAME = T
:OWNER = ONSMS
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0.016
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery End (1 record processed)
Duration = 0
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery Start Query.Next for up to 1 record
2010-06-08 오전 10:23:08 TOracleQuery PLSQLDevForm.ColumnQuery End (0 records processed)
Duration = 0.016
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 Start Query.Execute
SQL = select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used,
to_char(ini_trans) ini_trans, to_char(max_trans) max_trans,
to_char(initial_extent) initial_extent, to_char(next_extent) next_extent,
to_char(pct_increase) pct_increase,
to_char(min_extents) min_extents, to_char(max_extents) max_extents,
cluster_name
from sys.dba_tables
where owner = :object_owner
and table_name = :object_name
:OBJECT_OWNER = ONSMS
:OBJECT_NAME = T
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 End (1 record processed)
Duration = 0.032
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 Start Query.Execute
SQL = select *
from sys.dba_tables
where owner = :object_owner
and table_name = :object_name
:OBJECT_OWNER = ONSMS
:OBJECT_NAME = T
2010-06-08 오전 10:23:08 TOracleQuery $05BF3D80 End (1 recor
 
Last edited:
We need a vcsdebug.txt file. Can you retry with the Debug parameter instead of the DebugSQL parameter?

"C:\Program Files\PLSQL Developer\plsqldev.exe" Debug
 
I really couldn't make vcsDebug.txt.
I did everything you told me to but I just found "Debug.txt" in the installation folder and "C:\Users\\AppData\Roaming\PLSQL Developer".

I took several bottom lines of the "Debug.txt" file in the installation directory.

2010-06-14 오후 3:23:06 SQLForm 10 rows selected in 0.281 seconds
2010-06-14 오후 3:23:09 SQLForm a, varchar2(20), optional
2010-06-14 오후 3:23:09 SQLForm a, varchar2(20), optional
2010-06-14 오후 3:23:10 EditCopy
2010-06-14 오후 3:23:10 Screen.ActiveCustomForm EditCopy
2010-06-14 오후 3:23:10 ChildForm.EditCopy
2010-06-14 오후 3:23:10 EditCopy Grid
2010-06-14 오후 3:23:10 EditCopy No selection, wm_copy
2010-06-14 오후 3:23:10 SQLForm a, varchar2(20), optional
2010-06-14 오후 3:23:10 SQLForm a, varchar2(20), optional

Best Regards.
 
Hi, Marco

I have 5 men who uses plsqldeveloper.
I did what you told me to do on the 5 men's computer. there are 3 windows7 and 2 XP machines but I couldn't find vcsDebug.txt file(Debug.txt exists).

I really need to fix it.

Best Regards.
 
Last edited:
Hi Joeeeee , I am having the SAME exact issue as you~!

So, I've tried too. As Marco Kalter Told to Joeeeee.

add the debugsql parameter

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

and

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

But~!! Did not produce vcsdebug.txt file. Anywhere in My PC !

My Environment is Windows7 Professional K version.

How do make vcsdebug.txt file ??

Please, let me know in details
 
I have the same problem. We have 8 users and Everybody is having the crash after have pasted some records, but Nobody can get the vcsdebug.txt file.
All we have Win7 64 bits and PLSQL Developer ver 7.1.5.1398.

It's very frustrating because the function 'paste' has been well used for many years until now.

Karl
 
You must log in or register to reply here.

Similar threads

M
  • Discussion Discussion
"A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used" on query using Oracle 21c
Replies
1
Views
1K
Marco Kalter
Marco Kalter
A
  • Discussion Discussion
PL/SQL Developer Version 15 Hangs Often
Replies
1
Views
797
Marco Kalter
Marco Kalter
A
  • Discussion Discussion
ORA-01804 on version 15.0,1.2051
Replies
1
Views
902
Marco Kalter
Marco Kalter
T
  • Discussion Discussion
New PC Multiple Oracle Clients Bad Config
Replies
6
Views
2K
fabrice
F
D
  • Discussion Discussion
ORA-01804 on version 14.0.6.1998
Replies
1
Views
1K
Marco Kalter
Marco Kalter
Back
Top