Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

dbms_redefinition

Home » dbms_redefinition
Identifying PostgreSQL Bloat and fixing it without downtime

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,…

Continue Reading Identifying PostgreSQL Bloat and fixing it without downtime

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…

Continue Reading 12c:Specifying lock timeout for finish_redef_table

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments

  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
  • Natarajan Gounder on Creating ASM devices on AIX

Trending

  • GATHER_STATS_JOB - Is it enabled?
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • MGMTDB: Grid Infrastructure Management Repository
  • Resolving Shutdown Immediate Hang Situations
  • 12.1.0.2 PDB fails to come out of restricted mode
  • Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
  • How To Configure Exadata Database Machine in Enterprise Manager Cloud Control 13c (OEM13c)

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers

Copyright - OceanWP Theme by Nick