Re: Can view$ be pinned ?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: frank4oraclel@xxxxxxxx
- Date: Thu, 2 Dec 2004 14:23:45 +0000
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
