Re: ora-600 ..sort extent pool??

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).