10g introduction

Hi all,

We are in the process of developing a new application with 'all new' technology. Formerly a shop with HP-UX, ingres and abf, we are now moving to Sun-Solaris, Oracle and java. We already have some oracle databases running on solaris, one of them being a 300GB datawarehouse on oracle 9.2.0.5. I am starting an issue with project management to introduce 10g. They do not want risks during the development process (planned to last about a year). And they had a bad experience with the development tool which did not perform as expected (and as promissed by the supplier). Leading to the selection of other development tools and much frustration. The suggestion was they needed references to 'well known' production sites that are using 10g before even considering to introduce a new 'risk' as 10g might be. Application will have about 200+ tables and be 100GB approximately. Money related application, so security will be an issue as well.
Could any of you provide us with these references? Or links?

Thanks ,
Eric.

-----Oorspronkelijk bericht-----

Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Namens Frank B Hansen
Verzonden: donderdag 2 december 2004 9:12 Aan: oracle-l_at_freelists.org
Onderwerp: 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-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 02 2004 - 02:47:00 CST