dbms_redefinition Archives - AskDba.org Weblog

Identifying PostgreSQL Bloat and fixing it without downtime

Post author:Amit Bansal
Post published:21 April, 2019
Post category:PostgreSQL
Post comments:0 Comments

MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it was some time ago,…

12c:Specifying lock timeout for finish_redef_table

Post author:Amit Bansal
Post published:3 July, 2013
Post category:12c
Post comments:0 Comments

Oracle 12c database has introduced enhancement to DBMS_REDEFINITION for specifying a a lock timeout (in seconds) which will allow FINISH_REDEF_TABLE to acquire an exclusive lock for swapping the source and interim tables.If…