I humbly stand corrected, awaiting my appropriate punishment. (Not too much, I hope.) -----Oorspronkelijk bericht----- Van: Jared Still [mailto:jkstill@xxxxxxxxx] Verzonden: donderdag 2 december 2004 15:13 Aan: eric.buddelmeijer@xxxxxxxxxx CC: oracle-l@xxxxxxxxxxxxx Onderwerp: Re: 10g introduction Eric, If you are going to reply to another message to start a whole new thread, you could at least delete the quoted message from your text. Better yet, just start a new message from scratch. Jared On Thu, 2 Dec 2004 09:50:58 +0100, Eric Buddelmeijer <eric.buddelmeijer@xxxxxxxxxx> wrote: > 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > Namens Frank B Hansen > Verzonden: donderdag 2 december 2004 9:12 > Aan: oracle-l@xxxxxxxxxxxxx > 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 > > -- > //www.freelists.org/webpage/oracle-l > > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l