Re: extremely high "consistent gets" count on query of all_constraints view

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 28 Apr 2006 23:54:30 GMT
Message-Id: <pan.2006.04.28.23.54.29.856428@sbcglobal.net>

On Fri, 28 Apr 2006 14:03:34 -0700, mike wrote:

> Why would a query of all_constraints cause 7 million consistent gets
> and take nearly two minutes ?

That is for us to guess and for you to find out. Enable the event 10046, level 12 and do the TKPROF, with SYS=YES WAITS=YES SORT=(EXEELA,FCHELA) Don't forget to tell us what's going on.

-- 
http://www.mgogala.com

Received on Fri Apr 28 2006 - 18:54:30 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: what sort of dba can you get for 100K nowdays"
Previous message: Mladen Gogala: "Re: Table stats in 10.2"
In reply to: mike: "extremely high "consistent gets" count on query of all_constraints view"
Next in thread: sjaffarhussain_at_gmail.com: "Re: extremely high "consistent gets" count on query of all_constraints view"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US