Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Author: Amit Bansal

Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions. Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
Amit Bansal

19 September, 2020

How to perform groupby using Python Itertools

Itertools is a powerful module and is part of python standard library. It provides a set of fast and memory efficient functions. You can learn more about them by referring…

Read Full Recipe
415 views 6:53 pm 0 Comments
Using SSL to securely connect to Amazon Redshift Cluster
Amit Bansal

11 September, 2020

Using SSL to securely connect to Amazon Redshift Cluster

Amazon Redshift is fully managed Cloud Datawarehouse from AWS for running analytic workloads. Lot of customers have requirements to encrypt data in transit as part of security guidelines. Redshift provides…

Read Full Recipe
1274 views 1:36 pm 0 Comments
AWS Glue Python shell job timeout with custom Libraries
Amit Bansal

13 June, 2020

AWS Glue Python shell job timeout with custom Libraries

This is short post on Timeout errors faced using custom libraries with AWS Glue Python shell job.  I referred the steps listed in AWS docs to create a custom library…

Read Full Recipe
357 views 1:25 pm 0 Comments
Identifying PostgreSQL Bloat and fixing it without downtime
Amit Bansal

21 April, 2019

Identifying PostgreSQL Bloat and fixing it without downtime

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

Read Full Recipe
837 views 9:30 am 0 Comments
Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command
Amit Bansal

18 March, 2019

Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command

Oracle Goldengate supports Oracle to PostgreSQL migrations by supporting PostgreSQL as a target database, though reverse migration i.e PostgreSQL to Oracle is not supported. One of the key aspect of…

Read Full Recipe
481 views 1:09 pm 0 Comments
Saving AWS RDS and Redshift Billing Costs using Reserved Instances
Amit Bansal

16 March, 2019

Saving AWS RDS and Redshift Billing Costs using Reserved Instances

  In this post, we would understand what are reserved instances, when do you need them and various ways to monitor them in your environment. As more enterprises are embracing…

Read Full Recipe
292 views 10:34 am 0 Comments

Posts navigation

Older posts
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
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • 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” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • Simplified Approach to Resolve ORA-4031
  • LGWR terminating instance due to error 338
  • Allocation Unit and Extents In ASM
  • How To Recover From Corrupted OCR Disk
  • Querying RDS PostgreSQL logs using Amazon Athena
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
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP