RE: Trace Evaluation

Ed

Respective Table is NOT partitioned

ACID is the UNIQUE Key on the Table . There are NO Constraints whatsoever

Thanks Indeed .

Vivek

> -----Original Message-----
> From: Shevtsov, Eduard [SMTP:EShevtsov_at_flagship.ru]
> Sent: Monday, June 25, 2001 7:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Trace Evaluation
>
> Hi,
>
> Do you think you could decrease number of executions ?
>
> 4 blocks per fetch => probably index's blevel = 2
>
> Is partitioning available for you? You may partition the table on
> acid column (I guess it's primary key).
> So you get local partitioned index on acid with smaller partitions
>
> Regards,
> Ed
>
>
> >
> >
> > Is there Any Scope for Improvement in the Following ?
> >
> > select acct_crncy_code into :b0
> > from
> > GAM where acid=:b1
> >
> >
> > call count cpu elapsed disk query
> current
> > rows
> > ------- ------ -------- ---------- ---------- ----------
> ----------
> > ----------
> > Parse 1 0.00 0.00 0 0
> 0
> > 0
> > Execute 73710 3.49 4.60 0 0
> 0
> > 0
> > Fetch 73710 4.93 4.82 0 294840
> 0
> > 73710
> > ------- ------ -------- ---------- ---------- ----------
> ----------
> > ----------
> > total 147421 8.42 9.42 0 294840
> 0
> > 73710
> >
> > Misses in library cache during parse: 0
> > Optimizer goal: CHOOSE
> > Parsing user id: 20 (TBAGEN)
> >
> > Rows Execution Plan
> > ------- ---------------------------------------------------
> > 0 SELECT STATEMENT GOAL: CHOOSE
> > 0 TABLE ACCESS (BY INDEX ROWID) OF
> 'GENERAL_ACCT_MAST_TABLE'
> > 0 INDEX (UNIQUE SCAN) OF
> > 'IDX_GENERAL_ACCT_MAST_TABLE' (UNIQUE)
> >
> > *************************************************************
> > ***********
> > ********
> >
> > NOTE - IDX_GENERAL_ACCT_MAST_TABLE is Defined on Field ACID
> > of GAM Table
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).