SAP Note 869521 - Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE

Composant : Oracle -

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

Mots Clés :
worst-case scenario terminations, long-term tm locks, rebuild / create attempts <level> times, alter index rebuild online, rebuild online / create online, create index online starts, table-wide tm enqueue, scheduling rebuild online, index remains fragmented, tm enqueue permanently

Notes associées :

883346Performance problems in realignment framework
712098RSORAISQ: Index Storage Quality Management
682926Composite SAP note: Problems with "create/rebuild index"
618868FAQ: Oracle performance
521264Hang situations
334224Important notes for creating indexes