Re: exec STATSPACK.SNAP renders ORA-03113

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<be5jqv40gpvmtjm0c2ev1drabtsnit1o7t_at_4ax.com>...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote:
>
> >But is there enough space in the statspack tables?? Do they have maxextents
> >set, for example? And does the perfstat user have a quota on TOOLS?
>
> The perfstat user has quota unlimited on TOOLS. TOOLS has autoextend
> on. As for the tables, they were setup by the package. I can't believe
> that the storage parameters set for the tables are so poor that such
> difficulties appear after a couple of days of sampling activity.
>
> >I honestly haven't encountered this problem, so I don't know precisely what
> >the issue, but space (ie, MAXEXTENTS or quota issues) was my first thought.
>
> Since the schema was completely removed and recreated the space was
> released, but snapshot creation still fails.
>
> >My second thought was that the 8.1.7.3 and .4 patchsets have been out a
> >while now, so why not patch your database upwards with those? Eliminates one
> >possible source of the error.
>
> I will check space issues. But I admit I feel a little helpless.
>
> I am not so optimistic about the effect of blindly applying patchesets
> of patches of any kind without a positive evidence that it will fix
> the problem.
>
> Thanks
> Rick Denoire

Rick,

spend a little time here:

http://otn.oracle.com/deploy/security/alerts.htm

and then read some more over on metalink.

There is absolutely no excuse for running unpatched software, even on your laptop.

HJR was too kind.

test the 8.1.7.4.x patchset, plus any one-off patchsets mentioned in the security alerts that are recommended for your particular platform.

If you were to file an iTAR, what do you think that the odds would be that the support analyst would not recommend applying the most recent patchset?

how funny would it be to find out that statspack had nothing to do with it, but someone running loadphp with a long username wash crashing your instance?

the reason that the patchsets are there, is that people that actually use the software report bugs (which takes alot of work) and eventually get fixes out through Oracle's release cycle.

benefit from their efforts.

Pd Received on Thu Nov 06 2003 - 00:46:52 CST