Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Can view$ be pinned ?
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-lReceived on Thu Dec 02 2004 - 02:07:42 CST
![]() |
![]() |