| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-600 ..sort extent pool??
Thankyou very much jon.
>From: "Jon Walthour" <jonw_at_fuse.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: ora-600 ..sort extent pool??
>Date: Sat, 04 Aug 2001 14:40:18 -0800
>
>Raghu:
>
>What I have found suggests that you are having latch contention on the SORT
>EXTENT POOL.
>
>The "510" indicates that a call was made to free a latch that is unowned.
>The second parameter is the address for that latch. The third argument is
>the type of child latch that the kernel was trying to free.
>
>Oracle processes doing sorting that require access to a sort segment in a
>temporary tablespace are coordinated by a SHARED POOL structure called the
>SORT EXTENT POOL. This structure contains a description of all of the
>active
>sort segments and their extents in the sort segment. Access to this
>structure is controlled by the SORT EXTENT POOL latch. Your problem could
>be
>due to latch contention on this latch. You can view the statistics on this
>latch by joining v$latch and v$latchname on latch#.
>
>To reduce contention on this latch, increase the extent size by changing
>the
>NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in
>which you are sorting.
>
>Jon Walthour
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Saturday, August 04, 2001 4:55 PM
>
>
> >
> > Hi Friends,
> >
> > When Iam rebuilding my index and clearing TEMP tablespace
>frequently..that
> > time I got this error..Any suggestions??
> >
> > ORA-00600: internal error code, arguments: [510], [1073758876], [sort
>extent
> > poo
> > l], [], [], [], [], []
> >
> > Thanks
> > Raghu.
> >
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Raghu Kota
> > INET: raghukota_at_hotmail.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).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jon Walthour
> INET: jonw_at_fuse.net
>
>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: Raghu Kota INET: raghukota_at_hotmail.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).Received on Sat Aug 04 2001 - 17:59:32 CDT
 |
 |