RE: Re: TOAD hangs when viewing Script of certain Views

Dick,

I’m happy to try to improve this query, but it is not executed when Toad is creating view scripts.  This query comes from generating user scripts.  There is, however, a similar query that is executed when generating view scripts.  So if we can find an improvement to this one, I may be able to apply it to the other.

Try these queries and let me know if either is significantly better.

This one is rewritten using a WITH.

with privs as
( Select p.grantee, p.owner, p.table_name, null column_name, p.privilege, p.grantable
   from   dba_tab_privs p, dba_users u
   where  p.grantee = u.username
   and   p.grantee = :OneObjectName
   UNION ALL
   Select p.grantee, p.owner, p.table_name, p.column_name, p.privilege, p.grantable
   from   dba_col_privs p, dba_users u
   where  p.grantee = u.username
   and   p.grantee = :OneObjectName)
Select o.object_type, pp.*
from   dba_objects o, privs pp
where o.OWNER = pp.owner
and   o.object_name = pp.table_name
and   o.object_type in ('TABLE', 'VIEW', 'SEQUENCE', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'SNAPSHOT', 'MATERIALIZED VIEW', 'DIRECTORY', 'LIBRARY', 'TYPE', 'OPERATOR', 'INDEXTYPE', 'EDITION', 'JOB', 'PROGRAM', 'SCHEDULE')
order by pp.grantee, pp.owner, pp.table_name, pp.column_name

This one adds a USE_HASH hint.  It seems others have run across this query being a problem.  If you add this line in the SETTINGS section of Toad.ini, the query will use this hint.

HashHintforPrivsQuery=1

Select /*+ USE_HASH(PP,O) */ o.object_type, pp.*
from   dba_objects o,
       (Select p.grantee, p.owner, p.table_name, null column_name, p.privilege, p.grantable
        from   dba_tab_privs p, dba_users u
        where  p.grantee = u.username
        and p.grantee = :OneObjectName
        UNION ALL
        Select p.grantee, p.owner, p.table_name, p.column_name, p.privilege, p.grantable
        from   dba_col_privs p, dba_users u
        where  p.grantee = u.username
        and p.grantee = :OneObjectName
        ) pp
where o.OWNER = pp.owner
and   o.object_name = pp.table_name
and   o.object_type in ('TABLE', 'VIEW', 'SEQUENCE', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'SNAPSHOT', 'MATERIALIZED VIEW', 'DIRECTORY', 'LIBRARY', 'TYPE', 'OPERATOR', 'INDEXTYPE', 'EDITION', 'JOB', 'PROGRAM', 'SCHEDULE')
order by pp.grantee, pp.owner, pp.table_name, pp.column_name





From: [email protected] [mailto:[email protected]] On Behalf Of Bert Scalzo
Sent: Friday, December 30, 2011 6:24 AM
To: [email protected]
Subject: RE: [toad] Re: TOAD hangs when viewing Script of certain Views


I’ll work with John on tuning this query. We’ve found some statements like these in the past where using more modern SQL constructs (e.g. WITH clause) can make huge differences ☺

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Pluim, Dick
Sent: Friday, December 30, 2011 6:02 AM
To: [email protected]<mailto:[email protected]>
Subject: RE: [toad] Re: TOAD hangs when viewing Script of certain Views


Bert,

Thanx, that did it for one of the databases. The production seems not to work and stays slow. We’ll dig into this further. Involved query (from the 2nd Toad-session) is:

/* Formatted on 30-12-2011 10:47:14 (QP5 v5.194.11349.34592) */
SELECT   o.object_type, pp.*
    FROM dba_objects o,
         (SELECT p.grantee,
                 p.owner,
                 p.table_name,
                 NULL column_name,
                 p.privilege,
                 p.grantable
            FROM dba_tab_privs p, dba_users u
           WHERE p.grantee = u.username
          UNION ALL
          SELECT p.grantee,
                 p.owner,
                 p.table_name,
                 p.column_name,
                 p.privilege,
                 p.grantable
            FROM dba_col_privs p, dba_users u
           WHERE p.grantee = u.username) pp
   WHERE     o.OWNER = pp.owner
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
         AND o.object_name = pp.table_name
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
         AND o.object_type IN
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
                ('TABLE',
                 'VIEW',
                 'SEQUENCE',
                 'PACKAGE',
                 'PROCEDURE',
                 'FUNCTION',
                 'SNAPSHOT',
                 'MATERIALIZED VIEW',
                 'DIRECTORY',
                 'LIBRARY',
                 'TYPE',
                 'OPERATOR',
                 'INDEXTYPE',
                 'EDITION',
                 'JOB',
                 'PROGRAM',
                 'SCHEDULE')
         AND pp.grantee = :OneObjectName
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
ORDER BY pp.grantee,
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
         pp.owner,
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
         pp.table_name,
/* ADVICE: [131]  This item has not been declared, or it refers to a label */
         pp.column_name
/* ADVICE: [131]  This item has not been declared, or it refers to a label */

/* ADVICE:
ADVICE SUMMARY

Count  Recommendation
-----  --------------
   11  [131]  This item has not been declared, or it refers to a label
                  The Oracle equivalent error messages are  PLS-00320 and
                  PLS-0321.
*/

Kind regards,
[Description: cid:480124009@19092011-263E]
Dick Pluim
ATS NL Oracle
atos.net
[Description: cid:480124009@19092011-2645]

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Bert Scalzo
Sent: donderdag 29 december 2011 16:12
To: [email protected]<mailto:[email protected]>
Subject: RE: [toad] Re: TOAD hangs when viewing Script of certain Views


Suggest reading this and testing the suggested fix – it’s easy to do and 80% of the time this is the culprit.

http://www.toadworld.com/Blogs/tabid/67/EntryId/135/Toad-Sometimes-Slow-on-Oracle-10g.aspx

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of DikkieDick
Sent: Thursday, December 29, 2011 3:16 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Re: TOAD hangs when viewing Script of certain Views



John,

Old thread.
I hadn't noticed it, but my colleague mentioned it this morning. He had this with Toad 10.6 on a 10.2.0.5-database. I checked it with my 11.1b and encountered the same. Didn't matter which user you want to view the script of. I then took another arbitrary 10.2.0.5-database and had no problems. As this was one of another customer and another platform we gave it another try with a database on the same platform for the same customer and had the same problem. The used platform is Solaris[tm] OE (64-bit).

Should try to find another customer using this platform (or another db-version on the same platform). Well, a bit later: with 10.2.0.3 on the same platform no issues.

Greetings, Dick

--- In [email protected]<mailto:toad%40yahoogroups.com>, John Dorlon <john.dorlon@...<mailto:john.dorlon@...>> wrote:
>
> It sounds like it is waiting for a query to execute. The last statement shown in spool SQL is the last statement executed, not the one currently executing. I can't tell you what the next statement is because there are a lot of possibilities.
>
> Try this:
>
> 1) start up 2 toads.
>
> 2) In the 1st Toad, go to get your view script so it hangs
>
> 3) In the 2nd Toad, go to the session browser, find the session for the 1st Toad and see what the current statement is.
>
>
>
>
> From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of kergegeek
> Sent: Friday, August 12, 2011 10:57 AM
> To: [email protected]<mailto:toad%40yahoogroups.com>
> Subject: [toad] TOAD hangs when viewing Script of certain Views
>
>
>
> Toad 10.6.1.3
> Connected to 11.2.0.2 database.
>
> I've encountered a weird case at a client of mine. They have some views (I've identified 2 so far), that when I describe (F4) the view, and then try to look at the script (via the Script tab), it freezes TOAD. I have to manually kill it from Windows. Other views show up fine.
>
> No Toad.elf information is written.
>
> If I look at the database, the frozen TOAD's database connection is idle and the last command executed is:
>
> SELECT *
> FROM SYS.DBA_SEC_RELEVANT_COLS
> WHERE object_owner = :own
> AND object_name = :OneObjectName;
>
> When I spool the SQL to a file, that is also the last statement shown in the spool file and I can run the statement just fine manually.
>
> I've included a support bundle that I generated right before clicking the Script tab. The exception listed in the bundle is from an earlier non-related AVI
>
> =-=-=-=-=-=-=-
> ************************************************************************
> APPLICATION INFORMATION - FULL VERSION
> ************************************************************************
> Support Bundle for Toad for Oracle 10.6.1.3
> This copy of Toad for Oracle registered to Quest
> Bundle: Toad for Oracle Xpert Add-Ons: DB Admin Module, SQL Optimizer
> Local Installation (non-network installation)
> Toad for Oracle Executable Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.exe
> User Profile Directory : C:\Users\Wayne XXXXXX\AppData\Roaming\Quest Software\Toad for Oracle\10.6\
> Knowledge Xpert DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Revbase.dll
> Knowledge Xpert Version : 5.6.0.6
> Formatter Plus DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\FmtPlus.dll
> Formatter Plus Version : 4.8.8.7
> QSEServer DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\qse.dll
> QSEServer Version : 10.6.0.44
> QP5 DLL Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\QP5.dll
> QP5 Version : 5.163.1008.3004
> TOAD Policy Location : C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6\Toad.pdl
>
> ************************************************************************
> TEAM CODING
> ************************************************************************
> TEAM CODING STATUS FOR CONNECTION DEV_COGDEV3_YUCHI
> No Team Coding session.
> Message log :
> 11:44:20 AM: Team Coding Objects not found on database
> Team Coding Support was not detected on this database. To install Team Coding Support, run the Server Side Objects Wizard. This task should be performed by a database administrator.
>
> ************************************************************************
> MANAGED ITEMS
> ************************************************************************
> Not a managed environment.
>
> ************************************************************************
> ORACLE CLIENT INFORMATION
> ************************************************************************
> Oracle Client Version : 11.1.0.6.0
> Oracle Client DLL : c:\oracle\client_111\BIN\oci.dll
> TNSNAMES.ora Location : c:\oracle\tnsnames.ora
> NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252
> SQLPATH : c:\oracle\client_111\dbs
> LOCAL :
>
> ************************************************************************
> ORACLE SERVER INFORMATION
> ************************************************************************
> Connection 1 : BO@DEV_COGDEV3_YUCHI ** Active Session **
> Oracle Server Version : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
> Oracle Server NLS_CHARACTERSET : WE8ISO8859P1
> Oracle Server NLS_NCHAR_CHARACTERSET : AL16UTF16
> Oracle Session User : BO (Normal)
>
> ************************************************************************
> SYSTEM INFORMATION
> ************************************************************************
> Operating System : Windows 7 (64 bit) (Build 7601) Service Pack 1
> Is Terminal Server: No
> Using XP Theme: Yes
>
> Physical Memory Load : 61.41 %
> Physical Memory (Total) : 8121 MB
> Physical Memory (Free) : 3134 MB
> Virtual Memory (Total) : 2047 MB
> Virtual Memory (Free) : 1667 MB
> Swap Space (Total) : 16241 MB
> Swap Space (Free) : 9879 MB
> Toad Page File Usage (Virtual Memory) : 129 MB
> Toad Working Set Usage (RAM) : 149 MB
>
> Environment Variable (PATH) :
> C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common
> c:\oracle\client_111\bin
> C:\Windows\system32
> C:\Windows
> C:\Windows\System32\Wbem
> C:\Windows\System32\WindowsPowerShell\v1.0\
> C:\Program Files\WIDCOMM\Bluetooth Software\
> C:\Program Files\WIDCOMM\Bluetooth Software\syswow64
> C:\Windows\SUA\bin
> C:\Windows\SUA\common\
> C:\Windows\SUA\usr\lib\
> C:\Program Files (x86)\Common Files\Intuit\QBPOSSDKRuntime
> c:\Program Files (x86)\Putty
> C:\Program Files (x86)\QuickTime\QTSystem\
> C:\Program Files\Microsoft Windows Performance Toolkit\
> C:\Program Files\Intel\WiFi\bin\
> C:\Program Files\Common Files\Intel\WirelessCommon\
> C:\Program Files\Intel\WiFi\bin\
> C:\Program Files\Common Files\Intel\WirelessCommon\
>
> Environment Variable (TNS_ADMIN) : c:\oracle
>
> ************************************************************************
> ORACLE HOMES DATA
> ************************************************************************
> (Oracle Root)
> inst_loc = C:\Program Files (x86)\Oracle\Inventory
> KEY_client_111 ***** This is the home currently used by Toad *****
> ORACLE_HOME = c:\oracle\client_111
> ORACLE_HOME_NAME = client_111
> ORACLE_GROUP_NAME = Oracle - client_111
> NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
> ORACLE_BUNDLE_NAME = Enterprise
> ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_client_111
> SQLPATH = c:\oracle\client_111\dbs
> MSHELP_TOOLS = c:\oracle\client_111\MSHELP
>
> ************************************************************************
> Most Recent Error Detail
> ************************************************************************
> EurekaLog 6.0.24
>
> Application:
> --------------------------------------------------------
> 1.1 Start Date : Thu, 11 Aug 2011 19:45:04 -0400
> 1.2 Name/Description: Toad.exe - (Toad for Oracle)
> 1.3 Version Number : 10.6.1.3
> 1.4 Parameters :
> 1.5 Compilation Date: Tue, 26 Oct 2010 09:54:37 -0400
> 1.6 Up Time : 13 hours, 11 minutes, 13 seconds
>
> Exception:
> ----------------------------------------------------------
> 2.1 Date : Fri, 12 Aug 2011 08:56:17 -0400
> 2.2 Address : 102E2995
> 2.3 Module Name : OraClient11.Dll - (Oracle RDBMS Client Library)
> 2.4 Module Version: 11.1.0.6
> 2.5 Type : EAccessViolation
> 2.6 Message : Access violation at address 102E2995 in module 'OraClient11.Dll'. Read of address 0000000C.
> 2.7 ID : AB0F
> 2.8 Count : 1
> 2.9 Status : New
> 2.10 Note :
>
> User:
> -------------------------------------------------------
> 3.1 ID : Wayne XXXXXX
> 3.2 Name :
> 3.3 Email :
> 3.4 Company :
> 3.5 Privileges: SeShutdownPrivilege - OFF
> SeChangeNotifyPrivilege - ON
> SeUndockPrivilege - OFF
> SeIncreaseWorkingSetPrivilege - OFF
> SeTimeZonePrivilege - OFF
>
> Active Controls:
> ---------------------------------------
> 4.1 Form Class : TfrmMain
> 4.2 Form Text : Toad for Oracle
> 4.3 Control Class: TAdvToadSyntaxMemo
> 4.4 Control Text :
>
> Computer:
> ----------------------------------------------------------
> 5.1 Name : WAC-HP
> 5.2 Total Memory : 8121 Mb
> 5.3 Free Memory : 2799 Mb
> 5.4 Total Disk : 234.37 Gb
> 5.5 Free Disk : 15.91 Gb
> 5.6 System Up Time: 10 days, 11 hours, 50 minutes, 10 seconds
> 5.7 Processor : Intel(R) Core(TM) i7 CPU Q 820 @ 1.73GHz
> 5.8 Display Mode : 1920 x 1080, 32 bit
> 5.9 Display DPI : 96
> 5.10 Video Card : NVIDIA Quadro FX 1800M (driver 8.17.12.6155 - RAM 1024 MB)
> 5.11 Printer : Brother HL-2170W (driver 6.1.7601.17514)
>
> Operating System:
> --------------------------------------------
> 6.1 Type : Microsoft Windows 7 (64 bit)
> 6.2 Build # : 7601
> 6.3 Update : Service Pack 1
> 6.4 Language: English
> 6.5 Charset : 0
>
> Network:
> ----------------------------------------------------------
> 7.1 IP Address: 000.000.000.000 - 192.168.008.106 - 000.000.000.000 - 000.000.000.000 - 192.168.179.001 - 192.168.145.001 - 000.000.000.000
> 7.2 Submask : 000.000.000.000 - 255.255.255.000 - 000.000.000.000 - 000.000.000.000 - 255.255.255.000 - 255.255.255.000 - 000.000.000.000
> 7.3 Gateway : 000.000.000.000 - 192.168.008.001 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000
> 7.4 DNS 1 : 000.000.000.000 - 010.008.001.017 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000
> 7.5 DNS 2 : 000.000.000.000 - 010.002.001.127 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 000.000.000.000
> 7.6 DHCP : OFF - ON - ON - ON - OFF - OFF - ON
>
> Call Stack Information:
> ----------------------------------------------------------
> |Address |Module |Unit |Class |Procedure/Method |Line |
> ----------------------------------------------------------
> |Running Thread: ID=4236; Priority=-2; Class=; [Main] |
> |----------------------------------------------------------|
> |008BB207|Toad.exe |OraClasses.pas |TOCIConnection |OraError |2164[68] |
> |75E600EB|KERNELBASE.dll | | |WideCharToMultiByte | |
> |7537170D|kernel32.dll | | |LocalAlloc | |
> |7537111E|kernel32.dll | | |Sleep | |
> |008BF0B1|Toad.exe |OraClasses.pas |TOCIConnection |Release |3596[2] |
> |008CDBBB|Toad.exe |OraClasses.pas |TOCICommand |BindParams |10217[9] |
> |008C6BCC|Toad.exe |OraClasses.pas |TOCICommand |Exec |7284[0] |
> |008CD66E|Toad.exe |OraClasses.pas |TOCICommand |DoExecute |10004[8] |
> |008CD620|Toad.exe |OraClasses.pas |TOCICommand |DoExecute |9996[0] |
> |008CD789|Toad.exe |OraClasses.pas |TOCICommand |Execute |10038[21]|
> |021C1C14|Toad.exe |CRAccess.pas |TCRRecordSet |ExecCommand |2497[1] |
> |021AAA71|Toad.exe |DBAccess.pas |TCustomDADataSet |InternalExecute |5821[1] |
> |1013F558|OraClient11.Dll| | |kpufhndl0 | |
> |1013F54B|OraClient11.Dll| | |kpufhndl | |
> |1013F540|OraClient11.Dll| | |kpufhndl | |
> |10086193|OraClient11.Dll| | |OCIHandleFree | |
> |0FC52E3F|oci.dll | | |OCIHandleFree | |
> |008C08B9|Toad.exe |OraClasses.pas |TOraCursor |FreeCursor |4311[17] |
> |008C0834|Toad.exe |OraClasses.pas |TOraCursor |FreeCursor |4294[0] |
> |008C062D|Toad.exe |OraClasses.pas |TOraCursor |Destroy |4224[1] |
> |007FEE93|Toad.exe |MemData.pas |TSharedObject |Free |7977[7] |
> |007FEE78|Toad.exe |MemData.pas |TSharedObject |Free |7970[0] |
> |008C3E6A|Toad.exe |OraClasses.pas |TOCICommand |Destroy |6122[23] |
> |021C1A59|Toad.exe |CRAccess.pas |TCRRecordSet |FreeCommand |2404[1] |
> |021C1A50|Toad.exe |CRAccess.pas |TCRRecordSet |FreeCommand |2403[0] |
> |021C1A25|Toad.exe |CRAccess.pas |TCRRecordSet |Destroy |2388[1] |
> |021C1A18|Toad.exe |CRAccess.pas |TCRRecordSet |Destroy |2387[0] |
> |008CF5C2|Toad.exe |OraClasses.pas |TOCIRecordSet |Destroy |10913[18]|
> |00801FC6|Toad.exe |MemDS.pas |TMemDataSet |FreeIRecordSet |782[1] |
> |00801FC0|Toad.exe |MemDS.pas |TMemDataSet |FreeIRecordSet |782[1] |
> |00801F5B|Toad.exe |MemDS.pas |TMemDataSet |Destroy |739[5] |
> |00801F38|Toad.exe |MemDS.pas |TMemDataSet |Destroy |734[0] |
> |021A990D|Toad.exe |DBAccess.pas |TCustomDADataSet |Destroy |5269[26] |
> |021A9858|Toad.exe |DBAccess.pas |TCustomDADataSet |Destroy |5243[0] |
> |02173552|Toad.exe |Ora.pas |TOraDataSet |Destroy |6589[10] |
> |0217352C|Toad.exe |Ora.pas |TOraDataSet |Destroy |6579[0] |
> |0096B27E|Toad.exe |OraSmart.pas |TCustomSmartQuery |Destroy |641[1] |
> |020C12E9|Toad.exe |ConnectionObjects.pas |TConnectObject |CheckConnection |7433[23] |
> |020C1210|Toad.exe |ConnectionObjects.pas |TConnectObject |CheckConnection |7410[0] |
> |020BF77A|Toad.exe |ConnectionObjects.pas |TConnectObject |TestConnection |6800[38] |
> |020BF5A0|Toad.exe |ConnectionObjects.pas |TConnectObject |TestConnection |6762[0] |
> |020A6A05|Toad.exe |ConnectionObjects.pas |TConnectionManager |TestConnections |1597[8] |
> |020A69C4|Toad.exe |ConnectionObjects.pas |TConnectionManager |TestConnections |1589[0] |
> |01B78AB1|Toad.exe |mainform.pas |TfrmMain |ActTestConnectionsExecute|3633[1] |
> |75527252|USER32.dll | | |GetPropW | |
> |75527227|USER32.dll | | |GetPropW | |
> |75527885|USER32.dll | | |DispatchMessageW | |
> |7552787B|USER32.dll | | |DispatchMessageW | |
> |022955AE|Toad.exe |Toad.dpr | | |120[86] |
> |75373398|kernel32.dll | | |GetEnvironmentVariableA | |
> |----------------------------------------------------------|
> | |
> |Running Thread: ID=11296; Priority=0; Class=TWorkerThread |
> |----------------------------------------------------------|
> |75E409F9|KERNELBASE.dll | | |WaitForSingleObjectEx | |
> |7537118F|kernel32.dll | | |WaitForSingleObjectEx | |
> |75371151|kernel32.dll | | |WaitForSingleObjectEx | |
> |75371143|kernel32.dll | | |Sleep | |
> |75371136|kernel32.dll | | |Sleep | |
> |009E2FAD|Toad.exe |virtualtrees.pas |TWorkerThread |Execute |5420[3] |
> |75373398|kernel32.dll | | |GetEnvironmentVariableA | |
> |----------------------------------------------------------|
> |Calling Thread: ID=4236; Priority=-2; Class=; [Main] |
> |----------------------------------------------------------|
> |009E2F0C|Toad.exe |virtualtrees.pas |TWorkerThread |Create |5385[3] |
> |009E2EDC|Toad.exe |virtualtrees.pas |TWorkerThread |Create |5382[0] |
> |009E2E72|Toad.exe |virtualtrees.pas | |AddThreadReference |5335[9] |
> |009E2E40|Toad.exe |virtualtrees.pas | |AddThreadReference |5327[1] |
> |009ECD16|Toad.exe |virtualtrees.pas |TBaseVirtualTree |Create |12037[87]|
> |009ECA48|Toad.exe |virtualtrees.pas |TBaseVirtualTree |Create |11950[0] |
> |00A06BDA|Toad.exe |virtualtrees.pas |TCustomVirtualStringTree|Create |30440[1] |
> |00A06BC4|Toad.exe |virtualtrees.pas |TCustomVirtualStringTree|Create |30439[0] |
> |01DB36CB|Toad.exe |CodeInsightCachePopup.pas|TCodeInsightPopup |Create |320[15] |
> |01E0863A|Toad.exe |frmToad.pas |TToadForm |Create |149[3] |
> |01E0861C|Toad.exe |frmToad.pas |TToadForm |Create |146[0] |
> |01DCC69C|Toad.exe |frmTOADMDI.pas |TTOADMDIForm |Create |673[2] |
> |020707FE|Toad.exe |dmCommonActions.pas |TdmCommonActions |DisplayForm |1054[56] |
> |020705B4|Toad.exe |dmCommonActions.pas |TdmCommonActions |DisplayForm |998[0] |
> |0207448D|Toad.exe |dmCommonActions.pas |TdmCommonActions |DisplayEditor |2771[59] |
> |020742B0|Toad.exe |dmCommonActions.pas |TdmCommonActions |DisplayEditor |2712[0] |
> |01BB32A9|Toad.exe |BackupEngine.pas |TBackupEngine |Restore |643[30] |
> |01BB3108|Toad.exe |BackupEngine.pas |TBackupEngine |Restore |613[0] |
> |01B7A6F7|Toad.exe |mainform.pas |TfrmMain |TmMainformShown |4552[32] |
> |77572270|ntdll.dll | | |RtlLeaveCriticalSection | |
> |755362D0|USER32.dll | | |CallNextHookEx | |
> |75530D48|USER32.dll | | |CallWindowProcW | |
> |75530D32|USER32.dll | | |CallWindowProcW | |
> |01B721CD|Toad.exe |mainform.pas | |NewWindowProc |997[12] |
> |75527252|USER32.dll | | |GetPropW | |
> |75527227|USER32.dll | | |GetPropW | |
> |75527885|USER32.dll | | |DispatchMessageW | |
> |7552787B|USER32.dll | | |DispatchMessageW | |
> |022955AE|Toad.exe |Toad.dpr | | |120[86] |
> |75373398|kernel32.dll | | |GetEnvironmentVariableA | |
> ----------------------------------------------------------
>
> Modules Information:
> --------------------
>
> Processes Information:
> ----------------------
>
> Assembler Information:
> ----------------------
>
> Registers:
> ----------
>
> ************************************************************************
> WINDOW USAGE
> ************************************************************************
> TFormToadEditor - 412
> TfrmObjects - 277
> TfrmAnalyze - 131
> TSessionBrowserForm - 74
> TIndexForm - 61
> TFormObjectSearch - 56
> TDBMS_SQLTuneForm - 33
> TfrmTrace - 31
> TfrmLogSwitch - 21
> TDiffHolderForm - 21
> TADDMReportForm - 21
> TfrmOraInit - 18
> TIMonitor - 10
> TRedoLogManagerForm - 6
> TFormSupportBundle - 6
> TDBProbeForm - 5
> TCompareSchemasForm - 4
> TAWRBrowserForm - 4
> TfrmComp1Obj - 3
> TFormExportDDL - 3
> TASMForm - 3
> TfrmExPlan - 3
> TRefreshGroupForm - 2
> TSnapshotForm - 2
> TDBrowserForm - 2
> TfrmRebuildTable - 2
> TDirectoryForm - 2
> TFormSQLOptimizer - 1
> TDataImportForm - 1
> TProjectManagerForm - 1
> TCompareDatabasesForm - 1
> TTableForm - 1
> TTableForm - 1
> TViewForm - 1
> TSegmentAdvisorForm - 1
> TSchemaScriptForm - 1
> TImportWizardForm - 1
> TInstanceManagerForm - 1
> TfrmTopSess - 1
> TExportBrowserForm - 0
> TDataPumpExportForm - 0
> TfrmTableSpaces - 0
> TUndoAdvisorForm - 0
> TThreadedQueryViewerForm - 0
> TDataPumpImportForm - 0
> TFormRefCursorResults - 0
> TReportsForm - 0
> TfrmExtents - 0
> TExplainPlanCompareForm - 0
> TfrmNLSParams - 0
> TDataPumpManagerForm - 0
> TScheduleForm - 0
> TProgramForm - 0
> TChainForm - 0
> TSchedulerJobForm - 0
> TQueueForm - 0
> TfrmServerStats - 0
> TDataCompareForm - 0
> TTablespaceMapForm - 0
> TAuditSQLForm - 0
> TAuditForm - 0
> TIndexMonitoringForm - 0
> TMultiObjectPrivForm - 0
> TWindowForm - 0
> TJobClassForm - 0
> TTaskSchedulerForm - 0
> TWindowGroupForm - 0
> TMDIDescribeForm - 0
> TfrmMain - 0
> TFormServerSideObjects - 0
> TQueryConditionForm - 0
> TSBLegendForm - 0
> TFormExecuteScript - 0
> TQBForm - 0
> TCreateDataForm - 0
> TQuickDescribeForm - 0
> TSearchInFilesForm - 0
> TAlertLogForm - 0
> TCopyTableDataForm - 0
> TF4HolderForm - 0
> TTransformationForm - 0
> TNewCodeHealthCheckForm - 0
> TFlashbackForm - 0
> TDBHealthCheckForm - 0
> TToadOnlineForm - 0
> TContextForm - 0
> TDiskGroupForm - 0
> TDBMSRedefForm - 0
> TToadAdvisorForm - 0
> TFormToadAppDesigner - 0
> TFormGridSaveAs - 0
> TfrmJava2PLSqlUI - 0
> TTraceFileBrowserForm - 0
> TStatsPackBrowserForm - 0
> TFlashbackArchiveForm - 0
> TOSMonitorForm - 0
> TfrmControlFiles - 0
> TfrmDepend - 0
> TSnapshotLogForm - 0
> TfrmSynonyms - 0
> TfrmMakeSeq - 0
> TLibraryForm - 0
> TProfileForm - 0
> TRBSForm - 0
> TTOADFTP - 0
> TNetworkForm - 0
> TScriptManagerForm - 0
> TSQLLoader - 0
> TfrmTblFilter - 0
> TTablespaceForm - 0
> TfrmCreateUser - 0
> TfrmSessionInfo - 0
> TfrmIndRbld - 0
> TfrmDbmsMDI - 0
> TDataSubsetWizardForm - 0
> TfrmUsersList - 0
> TEstimateTabSizeForm - 0
> TEstimateIndSizeForm - 0
> TMasterDetailForm - 0
> TfrmConsDef - 0
> TfrmDbLinks - 0
> TfrmTabDupes - 0
> TtdProfileAnalysisForm - 0
> TSecurityForm - 0
> TFDataModeler - 0
> TfrmImportExport - 0
> TfrmTKProf - 0
> TFormWrap - 0
> TfrmTCViewer - 0
> TfrmTCVCSBrowser - 0
> TfrmChainedRows - 0
> TFormERD - 0
> TfrmFreeDeficit - 0
> TServiceMgrForm - 0
> TFormModRGroup - 0
> TFormModRPlan - 0
> TExportWatchForm - 0
> TDBCreateWizardForm - 0
> TClusterForm - 0
> TFormRPlanSchedule - 0
> TPinnedPackageForm - 0
> TFormCRM - 0
> TSchedulerForm - 0
> TOutputFrm - 0
> TfrmJavaManager - 0
> TWindowsRegistryParmsForm - 0
> TfrmSchemaDoc - 0
> TTNSNamesEditorForm - 0
> TUNIXKernelParmsForm - 0
> TZipArchiveForm - 0
> TfrmLogMiner - 0
> TfrmComp1DBObj - 0
> TExportWizardForm - 0
> TDimensionForm - 0
> TTriggerForm - 0
> TDatabaseScriptForm - 0
>
> Thanks
>
> Wayne
>





Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien de integriteit van het bericht niet veilig gesteld is middels verzending via internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren, geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden wij enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder Atos Nederland B.V. goederen en/of diensten levert zijn met uitsluiting van alle andere voorwaarden de Leveringsvoorwaarden van Atos Nederland B.V. van toepassing. Deze worden u op aanvraag direct kosteloos toegezonden.

This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Nederland B.V. group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. On all offers and agreements under which Atos Nederland B.V. supplies goods and/or services of whatever nature, the Terms of Delivery from Atos Nederland B.V. exclusively apply. The Terms of Delivery shall be promptly submitted to you on your request.

Atos Nederland B.V. / Utrecht
KvK Utrecht 30132762