Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can view$ be pinned ?
Frank,
IMHO it is a bad idea to try, in whichever way, to improve on the way SYS objects work. If Oracle cannot properly take care of its own data, then the situation is hopeless. I would rather say that the thing to check is the deepreason behind those calls.
Regards,
Stephane Faroult
RoughSea Ltd
http://www.roughsea.com
On Thu, 2 Dec 2004 09:12 , Frank B Hansen <frank4oraclel_at_yahoo.dk> sent:
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: 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[1]
![]() |
![]() |