SAP Note 1741960 - segments are growing rapidly without obvious reason

Composant : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/1741960 (Connexion à SAP Service Marketplace requise)

Mots Clés :
long running delete/update operations, oracle sbp / windows patch collection installed, alter table <table_name> shrink space, level iii space management blocks, upcoming windows patch collection, windows patch collection 20 released, windows patch collection 08 released, filling  unformatted  0%-25%  25%-50%  50%-75%  75%-100%     fullblocks        547219      0      34        5      122      525bytes     4482818048      0   278528    40960    999424  4300800, sbps / windows patch collections, avoid subsequent table   reorganisations

Notes associées :

1696570Oracle SPARC SuperCluster: Patches for 11.2.0.3
1656659 GI 11.2.0: Patches / Patch Collections for 11.2.0.3
1656654Exadata 11.2.0: Patches for 11.2.0.3
1631931Oracle 11.2.0: Patches / Patch collections for 11.2.0.3
1597736GI 11.2.0: Patches / Patch Collections for 11.2.0.2
1591389Exadata 11.2.0: Patches for 11.2.0.2
1503709Oracle 11.2.0: Patches / Patch collections for 11.2.0.2
910389FAQ: Oracle Segment Shrinking