Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance Problems Solaris Vs Windows
Have you run "analyze table
...compute statitics;" on these tables on Solaris?
Guang
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<FONT
face=Tahoma>-----Original Message-----From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Munish BajajSent:
Wednesday, June 11, 2003 12:35 PMTo: Multiple recipients of list
ORACLE-LSubject: Performance Problems Solaris Vs
Windows
Hi Gurus,
I'm facing a weird problem. I'm running a
same query on windows as well as on Solaris both having Oracle 8.0.5 database
using CBO optimizer. The Query runs fine on Windows (takes 20-30 Secs) while
the same hangs on Solaris and takes 4-6 hrs to return the results. Both the
databases have approx same number of rows and indexes.
The Query is :
SELECT COUNT(*) FROM
mam_assets a, mam_asset_attr_domain_values dmv65549
WHERE a."ID" = dmv65549.asset_id AND a."ID"
IN (SELECT
dmv3.asset_idFROM mam_asset_attr_domain_values
dmv3
71
3
dmv3.asset_idFROM mam_asset_attr_domain_values
dmv3
71
3
<TABLE bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=634>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step16">16
<IMG align=top alt=border=0
height=16 src="" width=16> SELECT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step15">15
<IMG align=top alt="" border=0
height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step14">14
<IMG alt="" border=0
height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> NESTED
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step12">12
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> NESTED
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step10">10
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> MERGE JOIN
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step4">4
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> VIEW<A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step3">3
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step2">2name=planStep1>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step1">1name=planStep9>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step9">9
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step8">8
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> VIEW<A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step7">7
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step6">6name=planStep5>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step5">5name=planStep11>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step11">11
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (UNIQUE SCAN), AST_PK (GMASTER)
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step13">13
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_AST_FK_I (GMASTER)
<TABLE bgColor=#f7f7e7 border=0 cellPadding=0 cellSpacing=0 cols=3 width=634>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step15">15
<IMG align=top alt=border=0
height=16 src="" width=16> SELECT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step14">14
<IMG align=top alt="" border=0
height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step13">13
<IMG alt="" border=0
height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> NESTED
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step11">11
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> HASH
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step4">4
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> VIEW<A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step3">3
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step2">2name=planStep1>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (QUARKDMS) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step1">1name=planStep10>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (QUARKDMS) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step10">10
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> NESTED
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step8">8
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> VIEW<A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step7">7
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> SORT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step6">6name=planStep5>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (QUARKDMS) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step5">5name=planStep9>
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (QUARKDMS) <A
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step9">9
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (UNIQUE SCAN), AST_PK (QUARKDMS)
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step12">12
<IMG alt="" border=0
height="100%" src="" width=16><IMG alt="" border=0 height="100%" src="" width=16><IMG align=top alt="" border=0 height=16 src="" width=16><IMG align=top alt=border=0 height=16 src="" width=16> INDEX (RANGE SCAN), ATRVALDOM_AST_FK_I (QUARKDMS)
![]() |
![]() |