RE: 10g introduction

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
> 
> --
> 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

Other related posts: