RE: Re: TOAD hangs when viewing Script of certain Views
Bert Scalzo <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <228D4BD15697E04CAF6CD482362F2ACE102F5D80@ALVMBXW01.prod.quest.corp> |
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]] On Behalf Of DikkieDick Sent: Thursday, December 29, 2011 3:16 AM To: [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 >