RE: Latch Free Problem - Need Help

What's the select statement, what is the partition key and what are your indices?

If the partition key is not the first element in the index, or if you do not reference the partition key, you'd get this behavior.

-----Original Message-----
From: Sandy Druar [mailto:sdruar_at_eckerd.com] Sent: Wednesday, August 30, 2000 1:11 PM To: Multiple recipients of list ORACLE-L Subject: Latch Free Problem - Need Help

Hi List,

We are running this job which is talking over 24 hours to process. This job usually takes 1 hour to process with running parallel 4. But for some reason the select is not using the index and this table has 43 partitions. The following is the explain plan through top session.

----Select Statement

|-->Sort (group by)

            |-->Hash Join
                  |-->Partition (Concatenated)
                        |--> Table Access (Full)
                  |--> Table Access (Full)

I did a select on v$session_wait and noticed that all four sids had a latch free for several hours. What can I do to fix this problem?

Any help would be appreciated.

Thanks
Sandy Druar
Oracle DBA
sdruar_at_eckerd.com

-- 
Author: Sandy Druar
  INET: sdruar_at_eckerd.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).