Can view$ be pinned ?
- From: Frank B Hansen <frank4oraclel@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Dec 2004 09:12:15 +0100 (CET)
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
Other related posts:
