Probl\u00e8me : (sur pdtb11 base TCEDU)<\/p>\n
ORA-01654: unable to extend index PERFSTAT.STATS$LIBRARYCACHE_PK by 128 in\r\ntablespace STATSPACK\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 5081\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 105\r\nORA-06512: at line 1<\/pre>\nil faut purger les stats.<\/p>\n
Dans une fen\u00eatre sqlplus lancer la purge via sppurge.sql :<\/p>\n
pdtb11.ft.grp
\nora112\/o…<\/p>\nexport ORACLE_SID=TCEDU
\nsqlplus
\nsystem\/z…..<\/p>\nSQL> @$ORACLE_HOME\/rdbms\/admin\/sppurge.sql<\/strong><\/p>\n
le script liste les snap_id et leur date<\/em><\/span><\/p>\n
…<\/span>
\n22517 24 Jul 2019 09:44:32 5 pdtb11.ft.grp<\/span>
\n22518 24 Jul 2019 10:04:32 5 pdtb11.ft.grp<\/span>
\n22519 24 Jul 2019 10:24:32 5 pdtb11.ft.grp<\/span>
\n22520 24 Jul 2019 10:44:32 5 pdtb11.ft.grp<\/span>
\n22540 02 Aug 2019 13:09:59 5 pdtb11.ft.grp<\/span>
\nWarning<\/span>
\n~~~~~~~<\/span>
\nsppurge.sql deletes all snapshots ranging between the lower and<\/span>
\nupper bound Snapshot Id’s specified, for the database instance<\/span>
\nyou are connected to. Snapshots identified as Baseline snapshots<\/span>
\nwhich lie within the snapshot range will not be purged.<\/span><\/p>\nIt is NOT possible to rollback changes once the purge begins.<\/span>
\nYou may wish to export this data before continuing.<\/span><\/p>\nSpecify the Lo Snap Id and Hi Snap Id range to purge<\/span>
\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/span>
\nEnter value for losnapid: 4001\u00a0\u00a0entrer le premier SNAP_ID \u00e0 supprimer<\/em><\/span><\/span>
\nUsing 4001 for lower bound.<\/span><\/p>\nEnter value for hisnapid: 5802\u00a0entrer le dernier SNAP_ID \u00e0 supprimer<\/span><\/em><\/span>
\nUsing 5802 for upper bound.<\/span><\/p>\nDeleting snapshots 4001 – 5802.<\/span><\/p>\n
Number of Snapshots purged: 1802<\/span>
\n~~~~~~~~~~~~~~~~~~~~~~~~~~~<\/span><\/p>\nPurge of specified Snapshot range complete.<\/span><\/p>\n
SQL> QUIT<\/span><\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Probl\u00e8me : (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\u00eatre 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 … Continuer la lecture de « STATSPACK »<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2223"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2223"}],"version-history":[{"count":2,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"predecessor-version":[{"id":2227,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2223\/revisions\/2227"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}