RE: DBA_EXTENTS problem

From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Thu, 09 May 2002 10:36:17 -0800
Message-ID: <F001.0045D1B2.20020509103617@fatcity.com>

The Optimizer_mode is already set to CHOOSE. Any other ideas? Thanks,
--Babu

-----Original Message-----
Sent: Thursday, May 09, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L

Babu,

We had a similiar problem, and setting optimizer_mode = choose in our session solved it. Something to do with optimizer and DD access. Give that a try. I had the same problem with DBA_INDEXES and that fixed it.

hth,

Jack

• Janardhana Babu Donga <jbdonga_at_ucdavis.edu> wrote:
  > Dear List,
  >
  > When I query dba_extents , Iam getting response
  > after half an hour to 40
  > minutes, but when I query any other dictionary view
  > it is spontaneous.
  > Everything else is fine in the database and there
  > are no problems, except
  > the above problem. Iam not getting any clue how to
  > fix this. Iam thinking of
  > running catalog.sql and catproc.sql as a last
  > resort. Iam not sure it would
  > fix the problem. Please let me know if there is any
  > other way to fix this
  > problem.
  >
  > Thanks,
  > Babu
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Janardhana Babu Donga
  > INET: jbdonga_at_ucdavis.edu
  >
  > 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).
  

  ---

Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: jack_silvey_at_yahoo.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: Janardhana Babu Donga
  INET: jbdonga_at_ucdavis.edu

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 Thu May 09 2002 - 13:36:17 CDT