Query Builder extremely slow to open

C

Curtis

Member
Having performance issues when trying to open the standard query builder. Can take 10 plus minutes to open...Any suggestion?

using a vpn connection to access the database. Previously used the active query builder and did not experience any performance issues. Just prefer the standard query builder function more than the active query builder
 
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.
 
Marco:

Here is the debug message. did not see where I could send an attachment so I did the cut/paste. Thanks

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

Physical memory : 2,054,336 kB (1,056,740 available)
Paging file : 4,194,304 kB (4,119,764 available)
Virtual memory : 2,097,024 kB (2,020,328 available)

Parameters
C:\Program Files\plsql developer\plsqldev.exe
debugsql

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

Preference Files

Plug-Ins

1/7/2009 8:36:41 PM Application started
1/7/2009 8:36:41 PM InitPreferences
1/7/2009 8:36:41 PM Load C:\Program Files\plsql developer\Preferences\Default = 0
1/7/2009 8:36:41 PM PreferenceSet.Load C:\Program Files\plsql developer\Preferences\Default\Default.ini
1/7/2009 8:36:41 PM PreferenceSet.Load OK
1/7/2009 8:36:41 PM Determine LocalPrefPath
1/7/2009 8:36:41 PM [1]: C:\Program Files\plsql developer\Preferences
1/7/2009 8:36:41 PM LocalPrefPath: C:\Program Files\plsql developer\Preferences\cshelton2
1/7/2009 8:36:41 PM Load C:\Program Files\plsql developer\Preferences\cshelton2 = 0
1/7/2009 8:36:41 PM PreferenceSet.Load C:\Program Files\plsql developer\Preferences\cshelton2\default.ini
1/7/2009 8:36:41 PM PreferenceSet.Load OK
1/7/2009 8:36:41 PM PreferenceSet.Load C:\Program Files\plsql developer\Preferences\cshelton2\user.prefs
1/7/2009 8:36:41 PM PreferenceSet.Load OK
1/7/2009 8:36:41 PM InitPreferences end
1/7/2009 8:36:41 PM SortPreferenceSets
1/7/2009 8:36:41 PM - Default cshelton2
1/7/2009 8:36:41 PM - System Default
1/7/2009 8:36:41 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
1/7/2009 8:36:41 PM ReadString OK
1/7/2009 8:36:41 PM pfReadRegistry: "C:\Program Files\plsql developer\plsqldev.exe" "%1"
1/7/2009 8:36:41 PM LoadPreferences
1/7/2009 8:36:41 PM LoadPreferences searching for default
1/7/2009 8:36:41 PM C:\Program Files\plsql developer\Preferences\cshelton2\default.ini
1/7/2009 8:36:41 PM LoadPreferences NewPref := nil
1/7/2009 8:36:41 PM LoadPreferences
1/7/2009 8:36:41 PM LoadPreferences Reading preferences
1/7/2009 8:36:41 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
1/7/2009 8:36:41 PM ReadString OK
1/7/2009 8:36:41 PM pfReadRegistry: "C:\Program Files\plsql developer\plsqldev.exe" "%1"
1/7/2009 8:36:41 PM LoadPreferences ReadPosition
1/7/2009 8:36:41 PM LoadPreferences ToolsBrowserItemClick(nil)
1/7/2009 8:36:41 PM LoadPreferences CreateBrowserFilters...
1/7/2009 8:36:41 PM LoadPreferences Files
1/7/2009 8:36:41 PM LoadPreferences Logon
1/7/2009 8:36:41 PM LoadPreferences Buttons
1/7/2009 8:36:41 PM LoadPreferences Printer
1/7/2009 8:36:41 PM LoadPreferences BrowserFolders
1/7/2009 8:36:41 PM LoadPreferences
1/7/2009 8:36:41 PM LoadPreferences end
1/7/2009 8:36:41 PM MacroLibFilename: C:\Program Files\plsql developer\Macro\cshelton2.lib
1/7/2009 8:36:52 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as RITPO_CSHELTON@prod
1/7/2009 8:36:53 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
1/7/2009 8:36:53 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.141
1/7/2009 8:36:53 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
1/7/2009 8:36:54 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.109
1/7/2009 8:36:54 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
1/7/2009 8:36:54 PM TOracleQuery Query End (1 record processed)
Duration = 0.125
1/7/2009 8:36:54 PM TOracleSession PLSQLDevForm.Session End
Duration = 1.406
1/7/2009 8:36:54 PM LogonHistorySave start
1/7/2009 8:36:54 PM ChangeUserPref LogonHistory,
1/7/2009 8:36:54 PM ChangeUserPref DSA,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref ColumnAssociations,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref ImportAssociations,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref BrowserFilters,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref BrowserFolders,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref SessionQueries,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref ExternalTools,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref Documents,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM ChangeUserPref Reports,
1/7/2009 8:36:54 PM ChangeUserPref end
1/7/2009 8:36:54 PM LogonHistorySave end
1/7/2009 8:36:54 PM FormCreate Session.Connected
1/7/2009 8:36:54 PM FormCreate Logon.Executed -1
1/7/2009 8:36:54 PM FormCreate TDBNames.Make
1/7/2009 8:36:54 PM FormCreate SessionChanged
1/7/2009 8:36:54 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
1/7/2009 8:36:54 PM TOracleQuery Query End (5 records processed)
Duration = 0.157
1/7/2009 8:36:54 PM SessionChanged SetDBAViews
1/7/2009 8:36:54 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
1/7/2009 8:36:54 PM TOracleQuery $02B0E8C0 End (0 records processed)
Duration = 0.36
1/7/2009 8:36:54 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
1/7/2009 8:36:54 PM TOracleQuery $02B0E8C0 End
Result = ORA-00942: table or view does not exist
Duration = 0.156
1/7/2009 8:36:54 PM 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%'
1/7/2009 8:36:55 PM TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-00942: table or view does not exist
Duration = 0.187
1/7/2009 8:36:55 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select object_name from sys.all_objects where owner = 'SYS' and object_type = 'VIEW' and object_name like 'DBA%'
1/7/2009 8:36:55 PM TOracleQuery PLSQLDevForm.DynamicQuery End (5 records processed)
Duration = 0.531
1/7/2009 8:36:55 PM TOracleQuery $02B0E8C0 Start Query.Describe
SQL = select * from sys.dba_tables where rownum < 1
1/7/2009 8:36:55 PM TOracleQuery $02B0E8C0 End
Duration = 0.266
1/7/2009 8:36:55 PM SessionChanged Authorizations.Load
1/7/2009 8:36:55 PM TOracleQuery $02B0E760 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)
1/7/2009 8:36:56 PM TOracleQuery $02B0E760 End
Result = ORA-00942: table or view does not exist
Duration = 0.141
1/7/2009 8:36:56 PM SessionChanged EnableAuthorizedMenus
1/7/2009 8:36:56 PM TOracleSession $03430EA0 Start Session.LogOn as RITPO_CSHELTON@prod
1/7/2009 8:36:56 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
1/7/2009 8:36:57 PM TOracleQuery Query End (1 record processed)
Duration = 0.125
1/7/2009 8:36:57 PM TOracleSession $03430EA0 End
Duration = 1.015
1/7/2009 8:36:57 PM SetSessionAction starts: Main session
1/7/2009 8:36:57 PM TOracleQuery $02B0EA20 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')
1/7/2009 8:36:57 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = select null from dual
1/7/2009 8:36:57 PM TOracleQuery $02B0E8C0 End (1 record processed)
Duration = 0.125
1/7/2009 8:36:57 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
1/7/2009 8:36:57 PM TOracleQuery $02B0E8C0 End
Duration = 0.094
1/7/2009 8:36:57 PM SetSessionAction ends
1/7/2009 8:36:57 PM ExecuteConnectScript starts
1/7/2009 8:36:57 PM ExecuteConnectScript ends
1/7/2009 8:36:57 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
1/7/2009 8:36:57 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.125
1/7/2009 8:36:57 PM SessionChanged LoadRecentObjects
1/7/2009 8:36:57 PM SessionChanged Notify children
1/7/2009 8:36:57 PM SessionChanged Logoff secondary sessions
1/7/2009 8:36:57 PM SessionChanged SessionMode = smMulti
07-Jan-09 8:36:57 PM SessionChanged EnableChildFunctions
07-Jan-09 8:36:57 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\oracle\product\10.2.0\client_1
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_1\bin\oci.dll
07-Jan-09 8:36:57 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
07-Jan-09 8:36:57 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.125
07-Jan-09 8:36:58 PM SortPreferenceSets
07-Jan-09 8:36:58 PM - Default cshelton2
07-Jan-09 8:36:58 PM - System Default
07-Jan-09 8:36:59 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
07-Jan-09 8:36:59 PM TOracleQuery $02B0E8C0 End (0 records processed)
Duration = 0.109
07-Jan-09 8:36:59 PM TOracleQuery $02B0E8C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
07-Jan-09 8:36:59 PM TOracleQuery $02B0E8C0 End
Result = ORA-00942: table or view does not exist
Duration = 0.141
07-Jan-09 8:36:59 PM WMUpdatePopups starts
07-Jan-09 8:36:59 PM LoadDesktop starts
07-Jan-09 8:36:59 PM LoadDesktop ends
07-Jan-09 8:36:59 PM WMUpdatePopups ends
07-Jan-09 8:37:11 PM TOracleQuery $02B0EA20 End (0 records processed)
Duration = 14.609
07-Jan-09 8:37:11 PM TOracleQuery $02B0EA20 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')
07-Jan-09 8:37:15 PM Create TSQLForm Start
07-Jan-09 8:37:15 PM Create TSQLForm Inherited
07-Jan-09 8:37:16 PM TSQLForm.FormCreate Start
07-Jan-09 8:37:16 PM SQLForm
07-Jan-09 8:37:16 PM TSQLForm.FormCreate Finished
07-Jan-09 8:37:16 PM Create TSQLForm SetupMainFont
07-Jan-09 8:37:16 PM Create TSQLForm Activate
07-Jan-09 8:37:16 PM Create TSQLForm Activate done
07-Jan-09 8:37:16 PM Create TSQLForm UpdateWindowList
07-Jan-09 8:37:16 PM Create TSQLForm Positioning
07-Jan-09 8:37:16 PM Create TSQLForm Finished
07-Jan-09 8:37:16 PM FileAge: C:\Documents and Settings\cshelton2.CSHELTON2-1\My Documents\sql scripts\archive scripts\workflow error idenification-test(4).sql = 10:59:54 PM
07-Jan-09 8:37:16 PM SQLForm
07-Jan-09 8:37:16 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:37:16 PM NavigationBookmarks: Backward=0, Forward=0
07-Jan-09 8:37:16 PM CheckFileDate WindowFileDate = 10:59:54 PM
07-Jan-09 8:37:16 PM FileAge: C:\Documents and Settings\cshelton2.CSHELTON2-1\My Documents\sql scripts\archive scripts\workflow error idenification-test(4).sql = 10:59:54 PM
07-Jan-09 8:37:21 PM CurrentStatement:
Select Distinct wf_items.item_key,

wf_items.item_type,

wf_item_activity_statuses.activity_status,

wf_item_attribute_values.name,

wf_items.PARENT_ITEM_TYPE,

wf_items.PARENT_ITEM_KEY,

wf_item_activity_statuses.ASSIGNED_USER,

wf_item_activity_statuses.ERROR_NAME,

wf_item_activity_statuses.ERROR_MESSAGE,

wf_item_attribute_values.NUMBER_VALUE,

per_all_people_f.FULL_NAME,

per_all_people_f.EMPLOYEE_NUMBER,

per_all_people_f.ATTRIBUTE1,

hrfv_person_assignment_history.ASSIGNMENT_ORGANIZATION_NAME,

hrfv_person_assignment_history.PEOPLE_GROUP,

hrfv_person_assignment_history.EMPLOYEE_PERSON_TYPE,

hxc_timecard_summary.START_TIME,

hxc_timecard_summary.STOP_TIME,

hxc_timecard_summary.approval_status,

hxc_timecard_summary.RECORDED_HOURS,

fnd_user.USER_NAME,

fnd_user.END_DATE

From wf_items

Inner Join wf_item_activity_statuses On wf_items.ITEM_TYPE =

wf_item_activity_statuses.ITEM_TYPE

And wf_items.ITEM_KEY =

wf_item_activity_statuses.ITEM_KEY

Inner Join wf_item_attribute_values On wf_item_activity_statuses.ITEM_TYPE =

wf_item_attribute_values.ITEM_TYPE

And wf_item_activity_statuses.ITEM_KEY =

wf_item_attribute_values.ITEM_KEY

Inner Join per_all_people_f On wf_item_attribute_values.NUMBER_VALUE =

per_all_people_f.PERSON_ID

Inner Join hrfv_person_assignment_history On per_all_people_f.PERSON_ID =

hrfv_person_assignment_history.PERSON_ID

Inner Join hxc_timecard_summary On per_all_people_f.PERSON_ID =

hxc_timecard_summary.RESOURCE_ID

And wf_item_attribute_values.DATE_VALUE =

hxc_timecard_summary.STOP_TIME

Inner Join fnd_user On per_all_people_f.PERSON_ID = fnd_user.EMPLOYEE_ID

Where wf_items.item_key = '2426089'

And wf_items.item_type = 'CUHXCSAW'

And wf_item_activity_statuses.activity_status = 'ERROR'

And wf_item_attribute_values.name = 'RESOURCE_ID'

or wf_item_attribute_values.name = 'TC_STOP'

And hxc_timecard_summary.approval_status = 'SUBMITTED'

And (((sysdate Between per_all_people_f.effective_start_date And

per_all_people_f.effective_end_date) And

(sysdate Between

hrfv_person_assignment_history.assignment_start_date And

hrfv_person_assignment_history.assignment_end_date) And

(sysdate Between hrfv_person_assignment_history.person_start_date And

hrfv_person_assignment_history.person_end_date And

sysdate Between hrfv_person_assignment_history.record_start_date And

hrfv_person_assignment_history.record_end_date)) And

hrfv_person_assignment_history.primary_flag = 'Yes')
07-Jan-09 8:37:21 PM TOracleQuery QBDM.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
begin
:sub_object := :part2;
if (:part2 is null) or (:part1 != user) then
begin
select object_type, user, :part1
into :object_type, :object_owner, :object_name
from sys.all_objects
where owner = user
and object_name = :part1
and object_type in ('TABLE', 'VIEW', 'SYNONYM')
and rownum = 1;
if :object_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = :part1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
end if;
:sub_object := :part2;
if :part3 is not null then
:sub_object := :sub_object || '.' || :part3;
end if;
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 sys.all_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.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
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.all_objects o
where o.owner = :part1
and o.object_name = :part2
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
return;
exception
when no_data_found then null;
end;
:object_owner := null;
:object_type := null;
:object_name := null;
:sub_object := null;
end;
:PART1 = WF_ITEMS
INNER JOIN WF_ITEM_ACTIVITY_STATUSES ON WF_ITEMS
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 = ITEM_TYPE =
WF_ITEM_ACTIVITY_STATUSES
:SUB_OBJECT = Null
:PART3 = ITEM_TYPE
AND WF_ITEMS.ITEM_KEY =
WF_ITEM_ACTIVITY_STATUSES.ITEM_KEY
INNER JOIN WF_ITEM_ATTRIBUTE_VALUES ON WF_ITEM_ACTIVITY_STATUSES.ITEM_TYPE =
WF_ITEM_ATTRIBUTE_VALUES.ITEM_TYPE
AND WF_ITEM_ACTIVITY_STATUSES.ITEM_KEY =
WF_ITEM_ATTRIBUTE_VALUES.ITEM_KEY
INNER JOIN PER_ALL_PEOPLE_F ON WF_ITEM_ATTRIBUTE_VALUES.NUMBER_VALUE =
PER_ALL_PEOPLE_F.PERSON_ID
INNER JOIN HRFV_PERSON_ASSIGNMENT_HISTORY ON PER_ALL_PEOPLE_F.PERSON_ID =
HRFV_PERSON_ASSIGNMENT_HISTORY.PERSON_ID
INNER JOIN HXC_TIMECARD_SUMMARY ON PER_ALL_PEOPLE_F.PERSON_ID =
HXC_TIMECARD_SUMMARY.RESOURCE_ID
AND WF_ITEM_ATTRIBUTE_VALUES.DATE_VALUE =
HXC_TIMECARD_SUMMARY.STOP_TIME
INNER JOIN FND_USER ON PER_ALL_PEOPLE_F.PERSON_ID =
07-Jan-09 8:37:22 PM TOracleQuery QBDM.ResolveSymbolQuery End
Duration = 0.312
07-Jan-09 8:37:59 PM CheckFileDate WindowFileDate = 10:59:54 PM
07-Jan-09 8:37:59 PM FileAge: C:\Documents and Settings\cshelton2.CSHELTON2-1\My Documents\sql scripts\archive scripts\workflow error idenification-test(4).sql = 10:59:54 PM
07-Jan-09 8:38:13 PM CheckFileDate WindowFileDate = 10:59:54 PM
07-Jan-09 8:38:13 PM FileAge: C:\Documents and Settings\cshelton2.CSHELTON2-1\My Documents\sql scripts\archive scripts\workflow error idenification-test(4).sql = 10:59:54 PM
07-Jan-09 8:38:28 PM Create TSQLForm Start
07-Jan-09 8:38:28 PM Create TSQLForm Inherited
07-Jan-09 8:38:28 PM TSQLForm.FormCreate Start
07-Jan-09 8:38:28 PM SQLForm
07-Jan-09 8:38:28 PM TSQLForm.FormCreate Finished
07-Jan-09 8:38:28 PM AddNavigationBookmark starts
07-Jan-09 8:38:28 PM AddNavigationBookmark GNV00001
07-Jan-09 8:38:28 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:28 PM NavigationBookmarks: Backward=1, Forward=0
07-Jan-09 8:38:28 PM AddNavigationBookmark ends
07-Jan-09 8:38:28 PM Create TSQLForm SetupMainFont
07-Jan-09 8:38:28 PM Create TSQLForm Activate
07-Jan-09 8:38:28 PM Create TSQLForm Activate done
07-Jan-09 8:38:28 PM Create TSQLForm UpdateWindowList
07-Jan-09 8:38:28 PM Create TSQLForm Positioning
07-Jan-09 8:38:28 PM Create TSQLForm Finished
07-Jan-09 8:38:28 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:28 PM NavigationBookmarks: Backward=1, Forward=0
07-Jan-09 8:38:33 PM AddNavigationBookmark starts
07-Jan-09 8:38:33 PM AddNavigationBookmark GNV00002
07-Jan-09 8:38:33 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:33 PM NavigationBookmarks: Backward=2, Forward=0
07-Jan-09 8:38:33 PM AddNavigationBookmark ends
07-Jan-09 8:38:33 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:33 PM NavigationBookmarks: Backward=2, Forward=0
07-Jan-09 8:38:33 PM CheckFileDate WindowFileDate = 10:59:54 PM
07-Jan-09 8:38:33 PM FileAge: C:\Documents and Settings\cshelton2.CSHELTON2-1\My Documents\sql scripts\archive scripts\workflow error idenification-test(4).sql = 10:59:54 PM
07-Jan-09 8:38:49 PM EditCopy
07-Jan-09 8:38:49 PM Screen.ActiveCustomForm EditCopy
07-Jan-09 8:38:49 PM ChildForm.EditCopy
07-Jan-09 8:38:52 PM AddNavigationBookmark starts
07-Jan-09 8:38:52 PM AddNavigationBookmark GNV00003
07-Jan-09 8:38:52 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:52 PM NavigationBookmarks: Backward=3, Forward=0
07-Jan-09 8:38:52 PM AddNavigationBookmark ends
07-Jan-09 8:38:52 PM NavigationBookmarks.EnableButtons(Rebuild)
07-Jan-09 8:38:52 PM NavigationBookmarks: Backward=3, Forward=0
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 205.578
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.25
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.156
07-Jan-09 8:40:37 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.25
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.093
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.079
07-Jan-09 8:40:38 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:39 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:40 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.093
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.125
07-Jan-09 8:40:41 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM CurrentStatement:
select *

From

wf_items

wf_item_activity_statuses

wf_item_attribute_values

per_all_people_f

hrfv_person_assignment_history

hxc_timecard_summary

fnd_user
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery QBDM.ResolveSymbolQuery Start Query.Execute
SQL = declare
t_owner varchar2(30);
t_name varchar2(30);
begin
:sub_object := :part2;
if (:part2 is null) or (:part1 != user) then
begin
select object_type, user, :part1
into :object_type, :object_owner, :object_name
from sys.all_objects
where owner = user
and object_name = :part1
and object_type in ('TABLE', 'VIEW', 'SYNONYM')
and rownum = 1;
if :object_type = 'SYNONYM' then
select s.table_owner, s.table_name
into t_owner, t_name
from sys.all_synonyms s
where s.synonym_name = :part1
and s.owner = user
and rownum = 1;
select o.object_type, o.owner, o.object_name
into :object_type, :object_owner, :object_name
from sys.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
end if;
:sub_object := :part2;
if :part3 is not null then
:sub_object := :sub_object || '.' || :part3;
end if;
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 sys.all_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.all_objects o
where o.owner = t_owner
and o.object_name = t_name
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
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.all_objects o
where o.owner = :part1
and o.object_name = :part2
and object_type in ('TABLE', 'VIEW')
and rownum = 1;
return;
exception
when no_data_found then null;
end;
:object_owner := null;
:object_type := null;
:object_name := null;
:sub_object := null;
end;
:PART1 = WF_ITEMS
WF_ITEM_ACTIVITY_STATUSES
WF_ITEM_ATTRIBUTE_VALUES
PER_ALL_PEOPLE_F
HRFV_PERSON_ASSIGNMENT_HISTORY
HXC_TIMECARD_SUMMARY
:OBJECT_TYPE = Null
:OBJECT_OWNER = Null
:OBJECT_NAME = Null
:PART2 =
:SUB_OBJECT = Null
:PART3 =
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery QBDM.ResolveSymbolQuery End
Duration = 0.078
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:42 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.125
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.11
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:43 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.125
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.141
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:44 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.109
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:45 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:46 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.047
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:47 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:48 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.094
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:49 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.062
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.063
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 Start Query.Next for up to 100 records
07-Jan-09 8:40:50 PM TOracleQuery $02B0EA20 End (100 records processed)
Duration = 0.078
07-Jan-09
 
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
F
  • Discussion Discussion
destructive behavior on workset.
Replies
2
Views
748
Gore
G
jlcox
  • Discussion Discussion
Standard query doesn't set focus to new tab
Replies
1
Views
290
Marco Kalter
Marco Kalter
C
  • Discussion Discussion
Linked query button still unusable in big databases
Replies
3
Views
1K
Marco Kalter
Marco Kalter
Back
Top