Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recompile invalid packages
that'll be perfstat.stats$sysstat for you then <vbg>. red lorry, yellow
lorry indeed.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3FAB802E.4E53_at_yahoo.com...Received on Fri Nov 07 2003 - 14:33:25 CST
> Niall Litchfield wrote:
> >
> > 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 ???
>
> I've just braces put on my teeth.... stats$sysstat is now a table I
> never mention :-)