Re: April 2010 CPU
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Thu, 29 Apr 2010 15:51:11 +0100
Good and likely extremely relevant question.
It's Patch Bundle 25 for 11.1.0.7 on Windows (Patches 9392331 and 9392335
for 32 and 64 bit respectively).
The preinstall instructions state:
5. For customers using Statspack:
It is recommended that you export the primary statspack schema as a backup
before instaling this patch, either using your own export parameters or
those provided in spuexp.par
Disable the programs that use Statspack
Run @spdrop and @sbdrop to drop both the primary and standby statspack
schemas
This customer hasn't gone down the PSU route yet.
On Thu, Apr 29, 2010 at 3:06 PM, <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
> Which version? I don't see anything about STATSPACK in 11.2.0.1, 11.1.0.7
> or 10.2.0.4 CPU readme's...
> I just did 11.2.0.1 PSU #1 and 11.1.0.7 PSU #3, and i didn't have to do
> anything with STATSPACK.
> Lyall
>
>
> -----Original Message-----
> From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
> To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
> Sent: Thu, Apr 29, 2010 9:57 am
> Subject: April 2010 CPU
>
>
> Anyone know why the instructions for this require the recreation of the
> STATSPACK repository? We have a client who would quite like to keep a record
> of historical performance information and also be protected against current
> security risks! It also looks like export/import of the repository is
> allowed so I'm unclear as to what the rationale might be.
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
