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_at_yahoo.dk> 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