RE: 10g introduction

I humbly stand corrected, awaiting my appropriate punishment. (Not too much, I hope.)

-----Oorspronkelijk bericht-----
Van: Jared Still [mailto:jkstill_at_gmail.com] Verzonden: donderdag 2 december 2004 15:13 Aan: eric.buddelmeijer_at_elegant.nl
CC: oracle-l_at_freelists.org
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_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