you haven't gathered system statistics
"Telemachus" <telemachus_at_ulysseswillreturn.net> schrieb im Newsbeitrag
news:%ghW8.643$zX3.562_at_news.indigo.ie...
> feel a lot more confident with 9.2
>
> Should have read <ALL> the new documentation though,
> the gather_system_statistics I only discovered when using
> utlxpls - that's a welcome recode BTW (of utlxpls)
>
>
> looks like the explain tool vendors are going to have to catch up !
>
> "Note : CPU Costing is off " - hello ? what's this !
>
> Congrats for all the DBA usability features.
>
> <plus all the stuff that guy below said >
>
> "basrad_at_oraspec.ind" <daekw_at_yahoo.com> wrote in message
> news:ag7eae$efv$04$2_at_news.t-online.com...
> > Hi,
> >
> > we are doing developement on 9.2 / Solaris 8 / Veritas DBE
> > and might switch into production in 2 month.
> >
> > I have worked with 9 for 6 month now and I am very satisfied with 9.2.
> >
> > I use a lot of the new features,
> > the full range of management features like LMT for all tablespaces,
> > automatic undo management, automatic pga management, spfiles ...
> > new stuff for CBO (system statistics ... ) and it looks well compared to
3
> > years bugfixing 8.1
> >
> > I had a setup with AQ and java and was really suprised it worked without
> > any modifications on 9.2
> >
> > CBO is also much better, in earlier versions I was used to write
> everything
> > as a join, know NOT IN and IN are often the better choice.
> >
> > also DISM on solaris 8 works well, dynamic reconfiguration of
> > SGA no problem, and without relinking 3.5 GB of sga on 32-bit
> > Solaris possible !!
> >
> > also no problems with external tables=> very good !,
> > dbms_metadata is a little buggy,
> > we use all stuff like multitable insert, list partioning
> > very rare ora - 600, the base seems to be very stable,
> > all kind of advisory-views, segment-statistics are very fine
> >
> > I have only problems with my favorite view v$session_event ??? it
> > shows very few wait events compared with older versions
> >
> > I plan to do something with the new stream functionality, is this a
> > good idea ??
> >
> > so who made expierences with 9.2 , who knows about some
> > pitfalls oder hidden problems ??
> >
> > 9.2 is very good compared with 8.1, and 8.1 was a major improvment
> > compared to 8 and 7.
> >
> > So congratulation for the superb work of Oracle development.
> >
> >
> >
> >
> >
> >
> >
> >
>
>
Received on Mon Jul 08 2002 - 14:17:08 CDT
