Sorry, can you run it through tkprof so we can see the more human readable
output.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Tony Rees" <antonie.rees_at_btinternet.com> wrote in message
news:bbnpgt$hf4$1$8302bc10_at_news.demon.co.uk...
> Here is the trace file as requested
>
> *** 2003-06-05 17:01:33.203
> =====================
> PARSING IN CURSOR #1 len=35 dep=0 uid=19 oct=42 lid=19 tim=3742898
> hv=2767092717 ad='20c97ff8'
> alter session set sql_trace = true
> END OF STMT
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3742898
> *** 2003-06-05 17:02:56.109
> =====================
> PARSING IN CURSOR #1 len=115 dep=0 uid=19 oct=3 lid=19 tim=3751189
> hv=350871421 ad='20c8db88'
> select objid,x_detail_number, x_form_index, x_form_id from
table_x_audit_hdr
> where x_detail_number = 'RMA-61214-1'
> END OF STMT
> PARSE #1:c=2,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=3751190
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3751190
> FETCH #1:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=3751190
> FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=4,tim=3751190
> STAT #1 id=1 cnt=1 pid=0 pos=0 obj=20706 op='TABLE ACCESS BY INDEX ROWID
> TABLE_X_AUDIT_HDR '
> STAT #1 id=2 cnt=2 pid=1 pos=1 obj=20721 op='INDEX RANGE SCAN '
> =====================
> PARSING IN CURSOR #1 len=36 dep=0 uid=19 oct=42 lid=19 tim=3756379
> hv=2583722623 ad='20c8eeac'
> alter session set sql_trace = false
> END OF STMT
> PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3756379
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3756379
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
> news:WgIDa.51803$DV.73842_at_rwcrnsc52.ops.asp.att.net...
> > What is the explain plan and the tk prof output? Also analyzing isn't
> going
> > to do much if you insist on putting in a rule hint. Are you using bind
> > variables? If not do so.
> > Jim
> >
> > --
> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> > with family. Remove the negative part, keep the minus sign. You can
> figure
> > it out.
> > "Tony Rees" <antonie.rees_at_btinternet.com> wrote in message
> > news:bbn8ip$o1$1$8300dec7_at_news.demon.co.uk...
> > >
> > > Dear Gurus,
> > >
> > > I have in the last couple of months been working on a project to trap
> all
> > > techniciam test data onto an Oracle 817 database. I am using an AMDOCS
> > > formerly Clarify application. Here is the problem I am now facing:-
> > >
> > > When doing a simple select from a table it is taking ages to return
the
> > data
> > > back. Here is the statement
> > >
> > > select /*+rule*/
> > > * from table_x_audit_hdr where x_detail_number = 'RMA-61214-1'
> > >
> > > I have created relevant indexes and analysed both tables and indexes
and
> > by
> > > looking at the plan for the above statement it is deffinately using
the
> > > indexes which have been refreshed. There are only 1200 records in the
> > above
> > > table so this statement should be working really quickly.
> > >
> > > The Table that I had to create has just over 600 fields in it !!!. My
> > DBA's
> > > in the States (I am in the UK) have said that I should redesign the
> > > application and try to get the size of the table right down which i
have
> > > come up with a plan that will take 6 weeks to redevelop that will
bring
> > the
> > > size of the table down to just over a 100 records.
> > >
> > > If I do a similar select from another table with only 100 fields in it
> but
> > > with 116256 rows of data the select statement is coming back really
> > quickly
> > > ie
> > >
> > > select /*+rule*/
> > > * from table_demand)dtl where detail_number = 'RMA-61214-1'
> > >
> > > Are there any memory parameters I should be looking at to get this to
> work
> > > quicker or would I be better in taking my DBA's advise and
redeveloping
> > the
> > > whole app to have only 100 fields in it ?????? Or is there some other
> > thing
> > > I can not think of to fix this.
> > >
> > > Any help and advise would be great as I have been trying to come up
with
> a
> > > resolve to this for weeeks now
> > >
> > > regards
> > >
> > > Frustrated developer
> > >
> > > Tony
> > >
> > >
> >
> >
>
>
Received on Thu Jun 05 2003 - 19:34:05 CDT
