Re: Can view$ be pinned ?

How do you know you have a performance problem?

Are key transactions/processes running too slowly?

Are users complaining?

Sure, that it is a lot of parses for views, but how much time
did it take, and is it seriosly impacting your system?

Jared



On Thu, 2 Dec 2004 09:12:15 +0100 (CET), Frank B Hansen
<frank4oraclel@xxxxxxxx> wrote:
> Hi List
> 
> I do have a performance problem...   The following stats are summed up over 
> 10 days.
> 
> #Parse = #Executions !!  (not good)
> 
> SQL text                       Execs    Rows proc Parse calls % impact
> ---------------------------------------- -------- --------- ----------- 
> --------
> Query 1                               854391    854391      854391    12.14
> Query 2                              1303493   1303491    1303493    18.52
> Query 3                             3926789   3926775     3926789    55.79
> 
> Query 1: SELECT SYSDATE FROM DUAL
> 
> Query 2: update seq$ set increment$=:2,minvalue=:...
> 
> Query 3: select text from view$ where rowid=:1
> 
> Any suggestions how to get the number of parses down ?  Can objects owned by 
> SYS be pinned or is that the wrong idea ?
> 
> Thanks, Frank
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: