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_at_elegant.nl> 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_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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l