Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Can view$ be pinned ?

Can view$ be pinned ?

From: Frank B Hansen <frank4oraclel_at_yahoo.dk>
Date: Thu, 2 Dec 2004 09:12:15 +0100 (CET)
Message-ID: <20041202081215.17424.qmail@web86901.mail.ukl.yahoo.com>


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
Received on Thu Dec 02 2004 - 02:07:42 CST

Original text of this message

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