Hi!
NOCACHE LOBs cause direct path writes as well...
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 30, 2003 5:59 PM
> IIRC, 'direct path write' represents writes to temporary segments.
>
>
> --- Tim Onions <[EMAIL PR
I saw the responses you've got but my response was delayed by the mailing
list for an unknown reason. That is why I stopped responding. You're in
good hands.
On 10/30/2003 04:59:26 PM, Tim Onions wrote:
> Mladen
>
> As my db_files parameter is set to 1024 then I take it that p1=1026 refers
> to te
Mladen
As my db_files parameter is set to 1024 then I take it that p1=1026 refers
to temp file #2 confirming what everybody is telling me its sorting to disk.
Thanks for your input, I now understand what it is I should be looking at.
T¬
--
Please see the official ORACLE-L FAQ: http://www.orafaq
s of list ORACLE-L
>Subject: Re: 10046 level 8 trace - help required with 'direct path
>
>
>Hi, Tim,
>
>Assuming you don't have more than 1000 files, what's your
>db_files set to and
>what's select file#, name from v$tempfile? If you do have more
>th
mine
> and do not reflect those of my employer or customers **
>
> >-Original Message-
> >From: Yong Huang [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, October 30, 2003 9:10 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Re: 10046 level 8 tra
So, when you look for the segment_type,segment_name,owner in dba_extents,
what do you see for file_id=1026 and block_id's as listed in p2?
On 10/30/2003 09:44:25 AM, Tim Onions wrote:
> Gurus
>
> I've applied many of the things I've learnt from this list over the years
> and today I tried a 10046
r customers **
>
> >-Original Message-
> >From: Yong Huang [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, October 30, 2003 9:10 AM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Re: 10046 level 8 trace - help required with 'direct path
> >
Sent: Thursday, October 30, 2003 9:10 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: 10046 level 8 trace - help required with 'direct path
>
>
>Hi, Tim,
>
>Assuming you don't have more than 1000 files, what's your
>db_files set to and
>what's
-Original Message-
>From: Yong Huang [mailto:[EMAIL PROTECTED]
>Sent: Thursday, October 30, 2003 9:10 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: 10046 level 8 trace - help required with 'direct path
>
>
>Hi, Tim,
>
>Assuming you don't have m
employer or customers **
>-Original Message-
>From: Yong Huang [mailto:[EMAIL PROTECTED]
>Sent: Thursday, October 30, 2003 9:10 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: 10046 level 8 trace - help required with 'direct path
>
>
>Hi, Tim,
>
&g
Hi, Gopal,
Now I know where you are! I just joined this list. I left here two years
because of too much spam (off-topic messages).
I know that number is db_files + tempfile#. But if he indeed has 1026
datafiles, p1 *will* be file# in v$datafile.
Yong
--- K Gopalakrishnan <[EMAIL PROTECTED]> wro
Yong:
They are temp files. The file# for the temp files start with db_files+1.
Because of this, there may be chances your pl will have 1000+ though you
have only hand ful of datafiles.
KG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursda
Hi, Tim,
Assuming you don't have more than 1000 files, what's your db_files set to and
what's select file#, name from v$tempfile? If you do have more than 1026 files,
select file#, name from v$datafile.
Also show us select * from v$sort_usage if you can run that DELETE again.
XCTEND rlbk=0: your
Looks sort spillage to disk due to the where clause.
Andy Rivenes
[EMAIL PROTECTED]
At 06:44 AM 10/30/2003 -0800, Tim Onions wrote:
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046 trace for the first time on a reported "slow"
transaction.
IIRC, 'direct path write' represents writes to temporary segments.
--- Tim Onions <[EMAIL PROTECTED]> wrote:
> OK - so I'd not got round to reading a recent previous post on the
> same
> issue, seems tim= is in hundredths of seconds for 8i. So I got that
> bit of
> the answer. Still pondering on
OK - so I'd not got round to reading a recent previous post on the same
issue, seems tim= is in hundredths of seconds for 8i. So I got that bit of
the answer. Still pondering on those 'direct path write' waits though.
_
Tim Onions
Head of Oracle Development
Speech M
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046 trace for the first time on a reported "slow"
transaction. From what I can tell the biggest offender is a wait seemingly
associated with rollback (see below) called 'direct path write'. Is thi
17 matches
Mail list logo
