fetching objects slow

E

Erwin Vrielink

Member
Fetching of objects is very slow on large data dictionary.
On opening the tables the IDE hangs and after a couple of minutes I killed it. In our database we have about 3000 tables in the current schema.
 
The IDE should not hang when opening Object List folders. Can you reproduce this issue and send me the debug.txt file from the /Plyxon/Log directory?
 
Hi Marco,

I let it run for a while now and finally after 20 minutes came results.
Contents of debug.txt:

Plyxon Version 0.9.2.520 (64 bit)
License: Alpha, Expiration Date: 01/03/2024 (99 days left)

Running Time: 0:00:00

ExePath: /Applications/plyxon.app/Contents/MacOS
Documents: /Users/evrielink/Documents/Plyxon
Resources: /Applications/plyxon.app/Contents/Resources
Settings: /Users/evrielink/Library/Plyxon

Application: /Applications/plyxon.app/Contents/MacOS/Plyxon

23/11/2023 13:17:04 Debug started

000,003 Loading Preferences
000,003 Settings Preferences/Shortcuts
000,003 /Users/evrielink/Library/Plyxon/Preferences/Shortcuts.ini
000,005 Settings Preferences/Oracle.x64
000,005 /Users/evrielink/Library/Plyxon/Preferences/Oracle.x64.ini
000,006 Settings Application/Paths
000,006 /Users/evrielink/Library/Plyxon/Application/Paths.ini
000,007 Settings Preferences/General
000,007 /Users/evrielink/Library/Plyxon/Preferences/General.ini
000,008 Settings Preferences/Editor
000,008 /Users/evrielink/Library/Plyxon/Preferences/Editor.ini
000,009 Settings Preferences/CodeAssistant
000,009 /Users/evrielink/Library/Plyxon/Preferences/CodeAssistant.ini
000,010 Settings Preferences/Files
000,010 /Users/evrielink/Library/Plyxon/Preferences/Files.ini
000,011 Settings Preferences/SQLDocument
000,011 /Users/evrielink/Library/Plyxon/Preferences/SQLDocument.ini
000,012 Settings Application/Application
000,012 /Users/evrielink/Library/Plyxon/Application/Application.ini
000,012 Loading Preferences Done
001,116 Application starts
001,116 Run
001,218 TMainForm.FormCreate
001,219 Settings Configuration/Accounts
001,219 /Users/evrielink/Library/Plyxon/Configuration/Accounts.ini
001,219 Settings Application/RecentAccounts
001,219 /Users/evrielink/Library/Plyxon/Application/RecentAccounts.ini
001,220 ContinueApplication
001,220 ContinueApplication -1
001,220 Terminated: False
001,220 ApplyOraclePreferences
002,686 ApplyPrefColors
002,689 Style: MirageLight
002,689 Starting plyxon ...
002,689 Settings Application/Forms/MainForm
002,690 /Users/evrielink/Library/Plyxon/Application/Forms/MainForm.ini
002,691 Desktop = 0, -320, 1120, 4352
002,691 WorkArea = 0, 25, 1120, 1792
002,691 CheckCrashRecovery
002,691 PID = 13127
002,692 CheckCrashRecovery Done
002,692 Connecting:
002,719 Settings Application/Forms/OracleLogonForm
002,719 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
007,936 Settings Application/Forms/OracleLogonForm
007,936 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
007,949 Connecting: impulse@onieuw
007,963 LOGON impulse@onieuw
007,963 TOracleSession $C6865E00 Start Session.LogOn as impulse@onieuw
007,964 LOGON Done
007,964 Settings Configuration/FileLocations
007,964 /Users/evrielink/Library/Plyxon/Configuration/FileLocations.ini
007,965 Settings Configuration/Macros
007,965 /Users/evrielink/Library/Plyxon/Configuration/Macros.ini
007,965 Settings Application/RecentFiles
007,965 /Users/evrielink/Library/Plyxon/Application/RecentFiles.ini
007,967 Settings Application/CodeAssistant
007,967 /Users/evrielink/Library/Plyxon/Application/CodeAssistant.ini
007,967 InitTotalRecall
007,967 Settings Application/
007,968 /Users/evrielink/Library/Plyxon/Application/.ini
007,969 InitTotalRecall 200
007,969 TMainForm.FormCreate Done
007,974 ListFiles Start
007,974 /Users/evrielink/Documents/Plyxon/Code Snippets/
007,975 Loading Desktop...
007,975 Settings Application/Desktop/desktop
007,976 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
007,984 Settings Application/Forms/OracleLogonForm
007,984 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
007,985 ListFiles Done (153)
007,994 Settings Application/Desktop/desktop
007,994 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
007,994 LoadDesktop: /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
007,995 LoadDesktop Done
007,995 Done.
008,173 ListFiles OnTerminate
008,932 TOracleQuery Query ($C6865E00) Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
008,937 TOracleQuery Query ($C6865E00) End (1 record processed)
Duration = 0,006
008,937 TOracleSession $C6865E00 End
Duration = 0,974
008,937 TOracleQuery Query ($C6865E00) Start Query.Execute
SQL = select * from v$version
008,942 TOracleQuery Query ($C6865E00) End (5 records processed)
Duration = 0,005
008,943 TOracleQuery $46C72830 ($C6865E00) Start Query.Execute
SQL = select value from nls_session_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
008,952 TOracleQuery $46C72830 ($C6865E00) End (1 record processed)
Duration = 0,009
008,952 TOracleQuery $C60705E0 ($C6865E00) Start Query.Execute
SQL = select user from dual
008,957 TOracleQuery $C60705E0 ($C6865E00) End (1 record processed)
Duration = 0,005
008,957 TOracleQuery BytesPerCharacterQuery ($C6865E00) Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
008,962 TOracleQuery BytesPerCharacterQuery ($C6865E00) End (1 record processed)
Duration = 0,005
008,962 TOracleQuery BytesPerCharacterQuery ($C6865E00) Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
008,967 TOracleQuery BytesPerCharacterQuery ($C6865E00) End (1 record processed)
Duration = 0,004
008,967 SetSessionModule starts: Main
008,967 TOracleSession $662C6400 Start Session.LogOn as impulse@onieuw
008,968 TOracleQuery $C6443D80 ($C6865E00) Start Query.Execute
SQL = select null from dual
008,975 TOracleQuery $C6443D80 ($C6865E00) End (1 record processed)
Duration = 0,006
008,975 TOracleQuery $C6443D80 ($C6865E00) Start Query.Execute
SQL = /* no transaction */
begin sys.dbms_application_info.set_module(:module, ''); end;
:MODULE = Main
008,979 TOracleQuery $C6443D80 ($C6865E00) End
Duration = 0,004
008,979 SetSessionModule ends
008,979 TOracleQuery $50521A40 ($C6865E00) Start Query.Execute
SQL = alter session set plsql_debug=true
008,983 TOracleQuery $50521A40 ($C6865E00) End
Duration = 0,003
008,983 Settings Application/RecentAccounts
008,983 /Users/evrielink/Library/Plyxon/Application/RecentAccounts.ini
009,904 TOracleQuery Query ($662C6400) Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
009,917 TOracleQuery Query ($662C6400) End (1 record processed)
Duration = 0,013
009,917 TOracleSession $662C6400 End
Duration = 0,95
009,917 TOracleQuery BytesPerCharacterQuery ($662C6400) Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
009,943 TOracleQuery BytesPerCharacterQuery ($662C6400) End (1 record processed)
Duration = 0,026
009,943 TOracleQuery BytesPerCharacterQuery ($662C6400) Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
009,949 TOracleQuery BytesPerCharacterQuery ($662C6400) End (1 record processed)
Duration = 0,006
009,949 TOracleQuery $C6443B70 ($662C6400) Start Query.Execute
SQL = select object_name, object_type
from sys.all_objects o
where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = IMPULSE
009,990 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,041
010,022 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,032 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,01
010,060 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,080 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,02
010,112 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,128 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,015
010,158 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,200 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,042
010,234 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,252 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,018
010,288 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,309 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,021
010,341 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,355 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,014
010,389 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,413 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,024
010,451 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,470 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,02
010,509 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
010,518 TOracleQuery $C6443B70 ($662C6400) End (34 records processed)
Duration = 0,009
010,520 TOracleQuery $C6443B70 ($662C6400) 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', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = IMPULSE
015,965 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 5,445
016,009 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
016,050 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,042
016,099 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
016,230 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,131
016,278 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,385 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 3,106
019,432 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,519 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,087
019,571 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,737 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,166
019,774 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,797 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,022
019,819 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,828 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,009
019,851 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
019,999 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,149
020,033 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
020,195 TOracleQuery $A570B3C0 ($C6865E00) Start Query.Execute
SQL = select o.object_type, o.owner, o.object_name, o.status
from sys.all_objects o
where o.owner = :object_owner
and o.object_type = :object_type
/* WHERE CLAUSE HERE */
order by o.object_name
:OBJECT_OWNER = IMPULSE
:OBJECT_TYPE = TABLE
020,336 TOracleQuery $A570B3C0 ($C6865E00) End (3191 records processed)
Duration = 0,142
021,080 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 1,048
021,113 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
021,301 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,188
021,327 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
021,596 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,269
021,618 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
022,043 TOracleQuery $C6443B70 ($662C6400) End (1000 records processed)
Duration = 0,425
022,075 TOracleQuery $C6443B70 ($662C6400) Start Query.Next for up to 1000 records
022,398 TOracleQuery $C6443B70 ($662C6400) End (466 records processed)
Duration = 0,324
022,409 TOracleQuery $C6443B70 ($662C6400) Start Query.Execute
SQL = select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema or o.owner = 'PUBLIC'
:SCHEMA = IMPULSE
022,415 TOracleQuery $C6443B70 ($662C6400) End (2 records processed)
Duration = 0,006
022,415 TOracleSession $662C6400 Start Session.LogOff
022,419 TOracleSession $662C6400 End
Duration = 0,004
1307,900 Settings Application/Desktop/desktop
1307,900 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
1307,900 SaveDesktop: /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
1307,900 Settings Application/Desktop/desktop
1307,900 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
1307,900 Settings Application/Forms/MainForm
1307,900 /Users/evrielink/Library/Plyxon/Application/Forms/MainForm.ini
1307,900 Settings Application/RecentFiles
1307,900 /Users/evrielink/Library/Plyxon/Application/RecentFiles.ini
1307,900 ClearRecoverFiles /Users/evrielink/Documents/Plyxon/Recover/13127
1307,900 ClearRecoverFiles Done

Kind regards,
Erwin
 
Thanks. It's not quite clear from the log file where all this time is lost. What action are you performing exactly when this delay occurs?
 
Hi Marco,

Unfortunately, this did not help. Opening the tables still takes a very long time. See also the log:

Plyxon Version 0.9.3.530 (64 bit)
License: Alpha, Expiration Date: 01/03/2024 (91 days left)

Running Time: 0:00:00

ExePath: /Applications/plyxon.app/Contents/MacOS
Documents: /Users/evrielink/Documents/Plyxon
Resources: /Applications/plyxon.app/Contents/Resources
Settings: /Users/evrielink/Library/Plyxon

Application: /Applications/plyxon.app/Contents/MacOS/Plyxon

01/12/2023 08:49:45 Debug started

000,004 Loading Preferences
000,004 Settings Preferences/Shortcuts
000,004 /Users/evrielink/Library/Plyxon/Preferences/Shortcuts.ini
000,007 Settings Preferences/Oracle.x64
000,007 /Users/evrielink/Library/Plyxon/Preferences/Oracle.x64.ini
000,009 Settings Application/Paths
000,009 /Users/evrielink/Library/Plyxon/Application/Paths.ini
000,009 Settings Preferences/General
000,009 /Users/evrielink/Library/Plyxon/Preferences/General.ini
000,011 Settings Preferences/Editor
000,011 /Users/evrielink/Library/Plyxon/Preferences/Editor.ini
000,012 Settings Preferences/CodeAssistant
000,012 /Users/evrielink/Library/Plyxon/Preferences/CodeAssistant.ini
000,013 Settings Preferences/Files
000,013 /Users/evrielink/Library/Plyxon/Preferences/Files.ini
000,014 Settings Preferences/SQLDocument
000,014 /Users/evrielink/Library/Plyxon/Preferences/SQLDocument.ini
000,014 Settings Application/Application
000,014 /Users/evrielink/Library/Plyxon/Application/Application.ini
000,015 Loading Preferences Done
001,163 Application starts
001,163 Run
001,277 TMainForm.FormCreate
001,283 Settings Configuration/Accounts
001,284 /Users/evrielink/Library/Plyxon/Configuration/Accounts.ini
001,285 Settings Application/RecentAccounts
001,285 /Users/evrielink/Library/Plyxon/Application/RecentAccounts.ini
001,286 ContinueApplication
001,286 ContinueApplication -1
001,286 Terminated: False
001,286 ApplyOraclePreferences
002,849 ApplyPrefColors
002,851 Style: MirageLight
002,852 Starting plyxon ...
002,861 Settings Application/Forms/MainForm
002,861 /Users/evrielink/Library/Plyxon/Application/Forms/MainForm.ini
002,863 Desktop = 0, -320, 1120, 4352
002,863 WorkArea = 0, 25, 1120, 1792
002,863 CheckCrashRecovery
002,863 PID = 55070
002,865 CheckCrashRecovery Done
002,865 Connecting:
002,893 Settings Application/Forms/OracleLogonForm
002,893 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
008,443 Settings Application/Forms/OracleLogonForm
008,443 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
008,456 Connecting: impulse@onieuw
008,456 LOGON impulse@onieuw
008,456 TOracleSession $79880E00 Start Session.LogOn as impulse@onieuw
008,457 LOGON Done
008,457 Settings Configuration/FileLocations
008,457 /Users/evrielink/Library/Plyxon/Configuration/FileLocations.ini
008,458 Settings Configuration/Macros
008,458 /Users/evrielink/Library/Plyxon/Configuration/Macros.ini
008,458 Settings Application/RecentFiles
008,458 /Users/evrielink/Library/Plyxon/Application/RecentFiles.ini
008,459 Settings Application/CodeAssistant
008,459 /Users/evrielink/Library/Plyxon/Application/CodeAssistant.ini
008,460 InitTotalRecall
008,460 Settings Application/
008,460 /Users/evrielink/Library/Plyxon/Application/.ini
008,463 InitTotalRecall 200
008,463 TMainForm.FormCreate Done
008,469 ListFiles Start
008,469 /Users/evrielink/Documents/Plyxon/Code Snippets/
008,470 Loading Desktop...
008,470 Settings Application/Desktop/desktop
008,470 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
008,480 ListFiles Done (153)
008,556 Settings Application/Forms/OracleLogonForm
008,556 /Users/evrielink/Library/Plyxon/Application/Forms/OracleLogonForm.ini
008,566 Settings Application/Desktop/desktop
008,566 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
008,566 LoadDesktop: /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
008,566 LoadDesktop Done
008,567 Done.
008,731 ListFiles OnTerminate
010,007 TOracleQuery Query ($79880E00) Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
010,021 TOracleQuery Query ($79880E00) End (1 record processed)
Duration = 0,014
010,022 TOracleSession $79880E00 End
Duration = 1,566
010,022 TOracleQuery Query ($79880E00) Start Query.Execute
SQL = select * from v$version
010,028 TOracleQuery Query ($79880E00) End (5 records processed)
Duration = 0,006
010,028 TOracleQuery $8A821DB0 ($79880E00) Start Query.Execute
SQL = select value from nls_session_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
010,034 TOracleQuery $8A821DB0 ($79880E00) End (1 record processed)
Duration = 0,006
010,034 TOracleQuery $29E1ECF0 ($79880E00) Start Query.Execute
SQL = select user from dual
010,042 TOracleQuery $29E1ECF0 ($79880E00) End (1 record processed)
Duration = 0,008
010,042 TOracleQuery BytesPerCharacterQuery ($79880E00) Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
010,047 TOracleQuery BytesPerCharacterQuery ($79880E00) End (1 record processed)
Duration = 0,005
010,047 TOracleQuery BytesPerCharacterQuery ($79880E00) Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
010,053 TOracleQuery BytesPerCharacterQuery ($79880E00) End (1 record processed)
Duration = 0,006
010,053 SetSessionModule starts: Main
010,053 TOracleSession $5D808800 Start Session.LogOn as impulse@onieuw
010,053 TOracleQuery $5A4F5F10 ($79880E00) Start Query.Execute
SQL = select null from dual
010,058 TOracleQuery $5A4F5F10 ($79880E00) End (1 record processed)
Duration = 0,005
010,058 TOracleQuery $5A4F5F10 ($79880E00) Start Query.Execute
SQL = /* no transaction */
begin sys.dbms_application_info.set_module(:module, ''); end;
:MODULE = Main
010,062 TOracleQuery $5A4F5F10 ($79880E00) End
Duration = 0,004
010,062 SetSessionModule ends
010,062 TOracleQuery $89773E50 ($79880E00) Start Query.Execute
SQL = alter session set plsql_debug=true
010,071 TOracleQuery $89773E50 ($79880E00) End
Duration = 0,009
010,071 Settings Application/RecentAccounts
010,071 /Users/evrielink/Library/Plyxon/Application/RecentAccounts.ini
011,071 TOracleQuery Query ($5D808800) Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
011,077 TOracleQuery Query ($5D808800) End (1 record processed)
Duration = 0,006
011,077 TOracleSession $5D808800 End
Duration = 1,024
011,077 TOracleQuery BytesPerCharacterQuery ($5D808800) Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
011,082 TOracleQuery BytesPerCharacterQuery ($5D808800) End (1 record processed)
Duration = 0,005
011,082 TOracleQuery BytesPerCharacterQuery ($5D808800) Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
011,087 TOracleQuery BytesPerCharacterQuery ($5D808800) End (1 record processed)
Duration = 0,005
011,087 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Execute
SQL = select object_name, object_type
from sys.all_objects o
where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = IMPULSE
011,498 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,411
011,528 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,535 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,007
011,562 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,584 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,022
011,619 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,633 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,014
011,664 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,687 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,018
011,725 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,742 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,017
011,776 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,857 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,081
011,899 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
011,982 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,083
012,021 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
012,034 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,013
012,078 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
012,094 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,016
012,135 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
012,139 TOracleQuery $5A4E64B0 ($5D808800) End (44 records processed)
Duration = 0,004
012,141 TOracleQuery $5A4E64B0 ($5D808800) 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', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = IMPULSE
012,654 TOracleQuery $298C36A0 ($79880E00) Start Query.Execute
SQL = select o.object_type, o.owner, o.object_name, o.status
from sys.all_objects o
where o.owner = :object_owner
and o.object_type = :object_type
/* WHERE CLAUSE HERE */
order by o.object_name
:OBJECT_OWNER = IMPULSE
:OBJECT_TYPE = TABLE
013,165 TOracleQuery $298C36A0 ($79880E00) End (3196 records processed)
Duration = 0,511
017,841 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 5,7
017,876 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
017,924 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,048
017,959 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
018,264 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,305
018,303 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
020,442 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 2,139
020,480 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
020,549 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,069
020,592 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
020,755 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,163
020,780 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
020,882 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,102
020,903 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
020,916 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,013
020,937 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
021,065 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,128
021,096 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
022,121 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 1,026
022,148 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
022,324 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,176
022,350 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
022,618 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,268
022,642 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
023,062 TOracleQuery $5A4E64B0 ($5D808800) End (1000 records processed)
Duration = 0,42
023,093 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Next for up to 1000 records
023,386 TOracleQuery $5A4E64B0 ($5D808800) End (474 records processed)
Duration = 0,293
023,396 TOracleQuery $5A4E64B0 ($5D808800) Start Query.Execute
SQL = select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema or o.owner = 'PUBLIC'
:SCHEMA = IMPULSE
023,506 TOracleQuery $5A4E64B0 ($5D808800) End (2 records processed)
Duration = 0,11
023,506 TOracleSession $5D808800 Start Session.LogOff
023,510 TOracleSession $5D808800 End
Duration = 0,004
2415,100 Settings Application/Desktop/desktop
2415,100 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
2415,100 SaveDesktop: /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
2415,100 Settings Application/Desktop/desktop
2415,100 /Users/evrielink/Library/Plyxon/Application/Desktop/desktop.ini
2415,100 Settings Application/Forms/MainForm
2415,100 /Users/evrielink/Library/Plyxon/Application/Forms/MainForm.ini
2415,100 Settings Application/RecentFiles
2415,100 /Users/evrielink/Library/Plyxon/Application/RecentFiles.ini
2415,100 ClearRecoverFiles /Users/evrielink/Documents/Plyxon/Recover/55070
2415,100 ClearRecoverFiles Done
 
You must log in or register to reply here.

Similar threads

E
  • Discussion Discussion
Connectios window open/close is slow
Replies
1
Views
295
Marco Kalter
Marco Kalter
L
  • Discussion Discussion
Bug: Plyxon hangs when long list of objects is fetched
Replies
1
Views
381
Marco Kalter
Marco Kalter
L
  • Discussion Discussion
Problems with compilation of a large view
Replies
2
Views
347
CoffeeK1d
CoffeeK1d
G
  • Discussion Discussion
Object browser still slow
Replies
12
Views
4K
Marco Kalter
Marco Kalter
G
  • Discussion Discussion
dbms_output?
Replies
1
Views
515
Marco Kalter
Marco Kalter
Back
Top