stats$sysstat anyone.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3FAA31BD.95D_at_yahoo.com...
> Howard J. Rogers wrote:
> >
> > "Joel Garry" <joel-garry_at_home.com> wrote in message
> > news:91884734.0311051518.36dd5fe_at_posting.google.com...
> > > Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message
> > news:<3FA922E9.FC06AA50_at_remove_spam.peasland.com>...
> > > > In addition to the other fine answers, also look at
> > > > ORACLE_HOME/rdbms/admin/utlirp.sql to recompile all invalid objects.
> > >
> > > The utlip.sql script that that script calls is so illuminating! In
> > > 8i, it shows how to deal with ORA-1555, in 9i, it shows how to deal
> > > with... blowing rollback segments! (I can understand why, the script
> > > might be run under non-undo conditions, it just sounds funny amid the
> > > undo hype). rownum < 5000, indeed.
> > >
> > > And why do they do a commit before a drop table? Could it be they
> > > can't count on DDL doing a commit? :-O
> > >
> > > jg
> >
> > Whilst we're bitchin' about Oracle's scripts, has anyone looked at the
> > monstrosity that is the 'backup to trace' these days in 9i??
> >
> > Thoughtful of them to provide two versions, with just one extra word and
two
> > less letters in the 'resetlogs' versus 'noresetlogs' version, no??
(Yeah, I
> > know it's configurable which version you get, but why in God's name
pander
> > to those who can't work out the difference in the first place??).
> >
> > Worse. All the 'comments' characters are stil "#"... which we loved in
> > server manager, but which throws errors in SQL Plus. Nice of them to
> > remember they abolished server manager in 9i, no? I mean, didn't the
lights
> > go on: here they are busy coding a totally unnecessary version of the
script
> > to be produced, but someone forgot to join the dots and twig that "#"
should
> > have been replaced by "--".
> >
> > What's even worser than that, though. Very uniquely, too. The 9i script
> > includes extra commands for dealing with Data Guard issues (standby
> > logfiles, performance level etc)... and guess what?? They remembered to
> > comment those lines with '--'. So now we have a bastardised script that
gets
> > half its comment characters wrong, and the other half right.
> >
> > Must have been a wet Wednesday afternoon or something.
> >
> > Sorry. Pet hate rant over.
> > Regards
> > HJR
>
> I'm still bitter since they introduced:
>
> dbms_obfuscation_toolkit
>
> Was there a competition to find the longest, hardest to type package
> name ???
Received on Fri Nov 07 2003 - 04:43:25 CST
