---
title: "Prasenjit Mahato (@prasenwins) | Hashnode"
description: "DBA Behind the Scenes. Read the latest articles by Prasenjit Mahato on Hashnode."
url: "https://hashnode.com/@prasenwins"
---

@prasenwins

# Prasenjit Mahato

@prasenwins · Belgium · Joined August 2025

DBA Behind the Scenes

### [Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)](https://oracledbafindings.hashnode.dev/enable-rsa-key-pair-based-authentication-goldengate-to-snowflake-on-premise?utm_source=hashnode&utm_medium=feed)

With Snowflake enforcing the deprecation of legacy password-based authentication, all data integration pipelines must transition to Key-Pair authentication. Prerequisites & Architecture OGG User: Sta

6 min read · [oracledbafindings.hashnode.dev](https://oracledbafindings.hashnode.dev/enable-rsa-key-pair-based-authentication-goldengate-to-snowflake-on-premise?utm_source=hashnode&utm_medium=feed)

[Sep 17](https://hashnode.com/posts/enable-rsa-key-pair-based-authentication-goldengate-to-snowflake-on-premise/6aabe6f6fb83f07f12991794)

### [OEM : migrate monitoring templates](https://oracledbafindings.hashnode.dev/oem-migrate-monitoring-templates?utm_source=hashnode&utm_medium=feed)

Query to find the monitoring templates currently used on old server SELECT TEMPLATE\_NAME,TARGET\_TYPE FROM SYSMAN.MGMT\_TEMPLATES; Old Server : OEM 13.5.0.24 \[oracle@oldserver1 ~\]$ $OMS\_HOME/bin/emcli login -username=sysman Enter password Login succe...

1 min read · [oracledbafindings.hashnode.dev](https://oracledbafindings.hashnode.dev/oem-migrate-monitoring-templates?utm_source=hashnode&utm_medium=feed)

[Jan 16](https://hashnode.com/posts/oem-migrate-monitoring-templates/696ab61f17120a7e039817cb)

### [Automatic maintenance tasks controls the automatic optimizer statistics](https://oracledbafindings.hashnode.dev/automatic-maintenance-tasks-controls-the-automatic-optimizer-s?utm_source=hashnode&utm_medium=feed)

Query to check the current state of jobs in CDB\_AUTOTASK\_CLIENT of the database, auto optimizer stats collection job is disabled in PDBs. SELECT COALESCE(p.name, (SELECT name FROM v$database)) AS DATABASE, CASE WHEN c.con\_id = 1 THE...

4 min read · [oracledbafindings.hashnode.dev](https://oracledbafindings.hashnode.dev/automatic-maintenance-tasks-controls-the-automatic-optimizer-s?utm_source=hashnode&utm_medium=feed)

[Dec 5, 2025](https://hashnode.com/posts/automatic-maintenance-tasks-controls-the-automatic-optimizer-s/6932ae446aca94d9b033cb1e)

### [Datapump - Exclude table AUD$](https://oracledbafindings.hashnode.dev/datapump-exclude-table-aud?utm_source=hashnode&utm_medium=feed)

There was a requirement to exclude the AUD$ table of the SYS schema from the export dump.The AUD$ table is already being collected daily in a separate database and retained for three years for reporting purposes. Excluding it from the export avoids r...

3 min read · [oracledbafindings.hashnode.dev](https://oracledbafindings.hashnode.dev/datapump-exclude-table-aud?utm_source=hashnode&utm_medium=feed)

[Aug 18, 2025](https://hashnode.com/posts/datapump-exclude-table-aud/68a3a15770b0eaee4dc0b8f7)