Problème : (sur pdtb11 base TCEDU)
ORA-01654: unable to extend index PERFSTAT.STATS$LIBRARYCACHE_PK by 128 in tablespace STATSPACK ORA-06512: at "PERFSTAT.STATSPACK", line 5081 ORA-06512: at "PERFSTAT.STATSPACK", line 105 ORA-06512: at line 1
il faut purger les stats.
Dans une fenêtre sqlplus lancer la purge via sppurge.sql :
pdtb11.ft.grp
ora112/o…
export ORACLE_SID=TCEDU
sqlplus
system/z…..
SQL> @$ORACLE_HOME/rdbms/admin/sppurge.sql
le script liste les snap_id et leur date
…
22517 24 Jul 2019 09:44:32 5 pdtb11.ft.grp
22518 24 Jul 2019 10:04:32 5 pdtb11.ft.grp
22519 24 Jul 2019 10:24:32 5 pdtb11.ft.grp
22520 24 Jul 2019 10:44:32 5 pdtb11.ft.grp
22540 02 Aug 2019 13:09:59 5 pdtb11.ft.grp
Warning
~~~~~~~
sppurge.sql deletes all snapshots ranging between the lower and
upper bound Snapshot Id’s specified, for the database instance
you are connected to. Snapshots identified as Baseline snapshots
which lie within the snapshot range will not be purged.
It is NOT possible to rollback changes once the purge begins.
You may wish to export this data before continuing.
Specify the Lo Snap Id and Hi Snap Id range to purge
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for losnapid: 4001 entrer le premier SNAP_ID à supprimer
Using 4001 for lower bound.
Enter value for hisnapid: 5802 entrer le dernier SNAP_ID à supprimer
Using 5802 for upper bound.
Deleting snapshots 4001 – 5802.
Number of Snapshots purged: 1802
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Purge of specified Snapshot range complete.
SQL> QUIT