SAP Note 1121838 - SELECT on partition hangs if a shrink compact is running

Composant : BW ORACLE - Oracle

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

Mots Clés :
alter table <table_name> shrink space compacta running select statement, ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 10, ziphp-ux itanium 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris x86-64 /oracle/oracle 64-bit/oracle 10, ziplinux ibmpower 64-bit /oracle/oracle 64-bit/oracle 10, ziphp tru64 /oracle/oracle 64-bit/oracle 10, ziplinux itanium 64 /oracle/oracle 64-bit/oracle 10, ziplinux 32-bit /oracle/oracle 32-bit/oracle 10, ziplinux x86-64 /oracle/oracle 64-bit/oracle 10

Notes associées :

910389FAQ: Oracle Segment Shrinking
871096Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2
619188FAQ: Oracle wait events