Toad World® Forums

Problem executing sql in tuning lab


#1

I tried to tune a fairly complex statement in tuning lab. The statement runs in about 3 seconds in Toad. Tuning lab creates plenty of alternatives. I tried selecting just a few alternatives and execute selected but they never finish. So then I try to execute just the original statement in Tuning Lab, it never finishes. I copied the statement from optimizer back into Toad and tried it just to double check. It runs in about 3 seconds. I try a simple statement in tuning lab and that works ok.

I am starting to think that something is broken on my machine. Does Tuning Lab use JRE?–because I know that is messed up on my machine because I’m having a problem running Oracle forms. Any suggestions? I am trying to evaluate this product for my department and not having much luck.


#2

Hi,

Do you mind giving me the SQL you have problem? I can have a look if you can give me the SQL to check. You can either attached it here or if you want to keep it private you can email it to me directly at alex.luk@quest.com.

Also, there is a Support Bundle function in the product that will allow you to send us trace information when you encountered problem. To do so, follow the steps here:

  1. Launch the product
  2. Click Help | Support Bundle, a new tab page will be displayed
  3. Perform the usual task to repeat the problem
  4. Once the problem is repeated, tab to the Support Bundle page
  5. Click on Save and Close

If you can also send me the Support Bundle, I will also check it for you.

Thanks,
Alex


#3

I’ve copied the sql and the view behind it below. My officemate is going to try installing the optimizer and see if it works ok on his machine.

SELECT DISTINCT (tbrdepo_pidm)
,SYSDATE
FROM saturn.spbpers
,saturn.spriden
,baninst1.tovdep1
,taismgr.tbrdepo
WHERE spbpers_dead_ind IS NULL
AND ( spriden_last_name NOT LIKE ‘DNU%’
OR spriden_last_name NOT LIKE ‘dnu%’
)
AND spbpers_pidm = spriden_pidm
AND spbpers_pidm = tbrdepo_pidm
AND tbrdepo_pidm = tovdep1_pidm_key
AND tbrdepo_detail_code_deposit = tovdep1_deposit_detl_code_key
AND tovdep1_deposit_term_code_key = tbrdepo_term_code
AND tbrdepo_detail_code_deposit LIKE ‘D%’
AND tbrdepo_term_code = ‘200920’
AND tovdep1_deposit_balance > 0

CREATE OR REPLACE FORCE VIEW tovdep1 (tovdep1_pidm_key
,tovdep1_deposit_detl_code_key
,tovdep1_deposit_detl_desc
,tovdep1_deposit_term_code_key
,tovdep1_deposit_trans_num_key
,tovdep1_accounting_percent_key
,tovdep1_id
,tovdep1_ssn
,tovdep1_last_name
,tovdep1_first_name
,tovdep1_middle_name
,tovdep1_middle_initial
,tovdep1_name_prefix
,tovdep1_name_suffix
,tovdep1_fund_code
,tovdep1_acct_code
,tovdep1_coas_code
,tovdep1_dcat_code
,tovdep1_payment_detail_code
,tovdep1_deposit_balance
,tovdep1_auto_release_ind
,tovdep1_acctg_feed_status
,tovdep1_post_cashier
,tovdep1_deposit_entry_date
,tovdep1_deposit_receipt_num
,tovdep1_min_remain_deposit_amt
,tovdep1_deposit_expire_date
,tovdep1_deposit_release_date
,tovdep1_deposit_effective_date
,tovdep1_deposit_activity_date
,tovdep1_cashier_session_num
,tovdep1_cashier_end_date
,tovdep1_foreign_curr_code
,tovdep1_deposit_trans_date
,tovdep1_foreign_curr_amt
,tovdep1_acctg_feed_date
,tovdep1_acctg_feed_doc_code
)
AS
SELECT tbrdepo_pidm
,tbrdepo_detail_code_deposit
,tbrdepo_desc
,tbrdepo_term_code
,tbrdepo_tran_number
,NVL (tbracct_percent, 100)
,spriden_id
,spbpers_ssn
,spriden_last_name
,spriden_first_name
,spriden_mi
,SUBSTR (spriden_mi, 1, 1)
,spbpers_name_prefix
,spbpers_name_suffix
,tbracct_a_fund_code
,tbracct_a_acct_code
,tbracct_a_coas_code
,tbbdetc_dcat_code
,tbrdepo_detail_code_payment
,NVL ( (NVL (tbracct_percent, 100) / 100)
* ( tbrdepo_amount
- f_accd_amount (tbrdepo_pidm, tbrdepo_tran_number)
)
,0
)
,tbrdepo_auto_release_ind
,tbrdepo_acct_feed_ind
,tbrdepo_user
,tbrdepo_entry_date
,tbrdepo_receipt_number
,tbrdepo_min_amount
,tbrdepo_expiration_date
,tbrdepo_release_date
,tbrdepo_effective_date
,tbrdepo_activity_date
,tbrdepo_session_number
,tbrdepo_cshr_end_date
,tbrdepo_curr_code
,tbrdepo_trans_date
,tbrdepo_foreign_amount
,tbrdepo_feed_date
,tbrdepo_feed_doc_code
FROM spbpers, tbbdetc, tbracct, spriden, tbrdepo, tbbeact
WHERE spriden_change_ind IS NULL
AND spbpers_pidm(+) = tbrdepo_pidm
AND spriden_pidm = tbrdepo_pidm
AND tbbdetc_detail_code = tbrdepo_detail_code_deposit
AND tbracct_detail_code(+) = tbrdepo_detail_code_deposit
AND tbbdetc_detail_code = tbbeact_detail_code
AND tbbeact_eff_date = tbracct_detc_eff_date
AND tbbeact_eff_date
AND tbbeact_nchg_date > SYSDATE
AND (tbbeact_term_date > SYSDATE OR tbbeact_term_date IS NULL);


#4

My officemate installed the optimizer and tried the statement in tuning lab, selecting the original and the first 2 alternates to run. The original ran in about 4 seconds, the others are still running…? at least the progress bar is still active-- over 45 minutes later. Support bundle copied below:


Application Information


Support Bundle for Quest SQL Optimizer for Oracle 7.3.0.678
Quest SQL Optimizer for Oracle, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest SQL Optimizer for Oracle.exe
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraVerticalGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6
Quest.Tuning.Oracle.Scanner, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.Inspector, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.SQLab, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.OutlineManager, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.CrossIdx, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.Queue, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.PVT, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraTreeList.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
ActiproSoftware.Shared.Net20, Version=1.0.80.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.BonusSkins.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a

Support Bundle for AxInterop.QExplain2 2.0.0.0
AxInterop.QExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\AxInterop.QExplain2.dll
Referenced assemblies:
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Interop.QExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for ICSharpCode.SharpZipLib 0.84.0.0
ICSharpCode.SharpZipLib, Version=0.84.0.0, Culture=neutral, PublicKeyToken=1b03e6acf1164f73
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\ICSharpCode.SharpZipLib.dll
Referenced assemblies:
mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.ConnPool 1.0.0.0
Interop.ConnPool, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.ConnPool.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.OptQEng 1.0.0.0
Interop.OptQEng, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.OptQEng.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.QExplain2 2.0.0.0
Interop.QExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QExplain2.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for Interop.QPRB 1.0.0.0
Interop.QPRB, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QPRB.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.QPTkProfSetupPI 1.0.0.0
Interop.QPTkProfSetupPI, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QPTkProfSetupPI.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.QTInsp 1.0.0.0
Interop.QTInsp, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QTInsp.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.QTPVT 1.0.0.0
Interop.QTPVT, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QTPVT.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Interop.QTScan 1.0.0.0
Interop.QTScan, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Interop.QTScan.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Quest.Tuning.Common 7.3.0.678
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Common.dll
Referenced assemblies:
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Raize.CodeSiteLogging, Version=3.0.1.34, Culture=neutral, PublicKeyToken=5979856d688ff136
AxInterop.QExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraPrinting.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6
DevExpress.XtraTreeList.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ICSharpCode.SharpZipLib, Version=0.84.0.0, Culture=neutral, PublicKeyToken=1b03e6acf1164f73
DevExpress.Data.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4

Support Bundle for Quest.Tuning.MessageBox 7.3.0.678
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.MessageBox.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4

Support Bundle for Quest.Tuning.Oracle.Common 7.3.0.678
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Common.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Interop.QExplain2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
DevExpress.XtraTreeList.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Interop.QPTkProfSetupPI, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
DevExpress.Data.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
QAITBoulder, Version=3.0.1000.0, Culture=neutral, PublicKeyToken=c862883b2ae69822

Support Bundle for Quest.Tuning.Oracle.ConnectionPoolWrapper 7.3.0.678
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.ConnectionPoolWrapper.dll
Referenced assemblies:
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Interop.ConnPool, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec23701
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for Quest.Tuning.Oracle.CrossIdx 7.3.0.678
Quest.Tuning.Oracle.CrossIdx, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.CrossIdx.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.CrossIdx.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for Quest.Tuning.Oracle.CrossIdx.Engine 7.3.0.678
Quest.Tuning.Oracle.CrossIdx.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.CrossIdx.Engine.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Interop.QPRB, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Quest.Tuning.Oracle.Inspector 7.3.0.678
Quest.Tuning.Oracle.Inspector, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Inspector.dll
Referenced assemblies:
DevExpress.XtraReports.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec23701
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraScheduler.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6
DevExpress.XtraPrinting.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.Data.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
Quest.Tuning.Oracle.Queue, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
ActiproSoftware.Shared.Net20, Version=1.0.80.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.Inspector.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null

Support Bundle for Quest.Tuning.Oracle.Inspector.Engine 7.3.0.678
Quest.Tuning.Oracle.Inspector.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Inspector.Engine.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Interop.QTInsp, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Support Bundle for Quest.Tuning.Oracle.OutlineManager 7.3.0.678
Quest.Tuning.Oracle.OutlineManager, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.OutlineManager.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Quest.Tuning.Oracle.OutlineManager.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for Quest.Tuning.Oracle.OutlineManager.Engine 7.3.0.678
Quest.Tuning.Oracle.OutlineManager.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.OutlineManager.Engine.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Interop.QPRB, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Quest.Tuning.Oracle.PVT 7.3.0.678
Quest.Tuning.Oracle.PVT, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.PVT.dll
Referenced assemblies:
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.PVT.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null

Support Bundle for Quest.Tuning.Oracle.PVT.Engine 7.3.0.678
Quest.Tuning.Oracle.PVT.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.PVT.Engine.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Interop.QTPVT, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Quest.Tuning.Oracle.Queue 7.3.0.678
Quest.Tuning.Oracle.Queue, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Queue.dll
Referenced assemblies:
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraReports.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec23701
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
DevExpress.Data.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
ActiproSoftware.Shared.Net20, Version=1.0.80.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9
DevExpress.XtraCharts.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraPrinting.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.Queue.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null

Support Bundle for Quest.Tuning.Oracle.Queue.Engine 7.3.0.678
Quest.Tuning.Oracle.Queue.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Queue.Engine.dll
Referenced assemblies:
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Interop.OptQEng, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Support Bundle for Quest.Tuning.Oracle.Scanner 7.3.0.678
Quest.Tuning.Oracle.Scanner, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Scanner.dll
Referenced assemblies:
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraReports.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
Quest.Tuning.Oracle.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
CoreLab.Oracle, Version=3.50.12.0, Culture=neutral, PublicKeyToken=09af7300eec23701
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraBars.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraTreeList.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.70.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6
DevExpress.XtraGrid.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
ActiproSoftware.SyntaxEditor.Net20, Version=3.1.210.0, Culture=neutral, PublicKeyToken=0ecd8d0e8818ec9b
DevExpress.Data.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
DevExpress.XtraNavBar.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Quest.Tuning.Oracle.ConnectionPoolWrapper, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Quest.Tuning.MessageBox, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
ActiproSoftware.Shared.Net20, Version=1.0.80.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9
Quest.Tuning.Oracle.Scanner.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.XtraPrinting.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Support Bundle for Quest.Tuning.Oracle.Scanner.Engine 7.3.0.678
Quest.Tuning.Oracle.Scanner.Engine, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.Scanner.Engine.dll
Referenced assemblies:
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Interop.QTScan, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Support Bundle for Quest.Tuning.Oracle.SQLab 7.3.0.678
Quest.Tuning.Oracle.SQLab, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
Location:
C:\Program Files\Quest Optimizer\Quest SQL Optimizer for Oracle Trial\Quest.Tuning.Oracle.SQLab.dll
Referenced assemblies:
Quest.Tuning.Preferences, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Quest.Tuning.Common, Version=7.3.0.678, Culture=neutral, PublicKeyToken=null
DevExpress.Utils.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
DevExpress.XtraEditors.v6.1, Version=6.1.4.0, Culture=neutral, PublicKeyToken=79868b8147b5eae4
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken


#5

Hi Wendy,

Thanks for sending me the information. I have also received your email. I will take it offline from here and I will send you more information soon.

If you have other questions, please feel free to post other messsages here. And when we found the cause or solution of your problem, I will also come back to update this thread.

Thanks,
Alex