10g introduction
- From: "Eric Buddelmeijer" <Eric.Buddelmeijer@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2004 09:50:58 +0100
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
Other related posts:
