Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_id
dmv3
71
3
dmv3.asset_id
dmv3
71
3
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step16">16
<IMG height=16 alt=border=0
src="" width=16 align=top>
SELECT
STATEMENT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step15">15
<IMG height=16 alt=""
src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step3">3
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) <Aname=planStep1>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step1">1
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) <Aname=planStep9>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step9">9
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step7">7
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (GMASTER) <Aname=planStep5>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step5">5
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (GMASTER) <Aname=planStep11>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step11">11
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (UNIQUE SCAN), AST_PK (GMASTER)
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Solaris%20Plan.html#step13">13
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_AST_FK_I (GMASTER)
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step15">15
<IMG height=16 alt=border=0
src="" width=16 align=top>
SELECT
STATEMENT
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step14">14
<IMG height=16 alt=""
src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step3">3
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (QUARKDMS) <Aname=planStep1>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step1">1
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (QUARKDMS) <Aname=planStep10>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step10">10
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step7">7
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top>
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> TABLE ACCESS (BY INDEX ROWID), MAM_ASSET_ATTR_DOMAIN_VALUES (QUARKDMS) <Aname=planStep5>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step5">5
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_DOMVAL_FK_I (QUARKDMS) <Aname=planStep9>
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step9">9
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (UNIQUE SCAN), AST_PK (QUARKDMS)
<A
href="file:///C:/Documents%20and%20Settings/mbajaj/My%20Documents/Windows%20Plan.html#step12">12
<IMG height="100%" alt=""
src="" width=16 border=0><IMG height="100%" alt="" src="" width=16 border=0><IMG height=16 alt="" src="" width=16 align=top border=0><IMG height=16 alt=border=0 src="" width=16 align=top> INDEX (RANGE SCAN), ATRVALDOM_AST_FK_I (QUARKDMS)
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<sql.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blueLineL.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<sort.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<empty.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<redLineL.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<nestedLoop.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<greyLineT.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<greyLine1.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blackLineT.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<mergeCartesian.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blackLine1.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blueLineT.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<view.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blueLine1.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<greyLineL.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<tableAccess.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<blackLineL.GIF>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<index.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<sortJoin.gif>>The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <<hashJoin.gif>> Received on Wed Jun 11 2003 - 10:52:19 CDT
![]() |
![]() |