▼

Connect MySQL database and read content of table using N8N

›
Requirement: Connect MySQL database and read content of table using N8N Pre-requisites: n8n tools is installed mysql database is installed a...

Connect oracle database with n8n

›
Requirement: In automation tool n8n, we want a node to connect with oracle database Pre-requisites: Install the NPM package Package name : ...

Create LLM Chatbot using Gradio, response in same screen from multiple models

›
Python code , that takes the input from user and from backend it connects with OPENAI_ChatGPT and Google Gemini Modes.  As a response it pri...

Default location for Ollama models in Mac

›
Question: Where is GenAI ollama models are stored in Mac OS when we run ollama run model name Answer: Default Locations: on macOS: ~/.ollama...

Change remote trail location RMTTRAIL in pump in Goldengate

›
  Summary:   This section explains the method to change REMOTE TRAIL location used in PUMP process in goldengate. Description: This blog is ...

Add new extract in Goldengate

›
Summary: Add new Extract process in GoldenGate Description: This blog is for adding a new extract in goldengate considering few assumptions...

DB Growth report - Oracle

›
Database growth report - Average per day : For capacity analysis and abnormalities of data load, it is mandatory to manage co...

Oracle - Explain plan cost -- What is it and how optimizer calculated

›
Oracle - Explain plan cost -- What is it and how optimizer calculates it In most of the Oracle DBA performance interviews and blogs, i ...

Enable SSL Ambari server

›
This blogs shares the steps involved for enable SSL for Ambari-server using KeyStore and Private keys. For more details click below ---...

Install Apache hadoop V1 Pseudo mode on CentOS6.5

›
Purpose: We have CentOS 6.5 on which we have to install Hadoop 1.2.1 with Java JDK-8.

Install Apace Ambari-Server on Linux Centos 6.5

›
Purpose:  This blog explains the Ambari Server in Installation on CentOS.

Drop the SQL PLAN BASELINE

›
Drop the SQL_BASELINES This post explains to Drop the SQL plan baselines of the SQL. set lines 200 pages 2000 column sql_handle for a5...

Fetch the SQL BASELINE evolve Report without actually change the ACCEPTED flag

›
In this blog we will explain the details of how to fetch the SQL BASELINE Report. first of the the method we use for SQL PLAN BASELINE is...

Explain plan for SQL_BASELINES using DBMS package in ORACLE

›
Explain plan for SQL_BASELINES This post explains to find out the explain plan used by the SQL plan baselines of the SQL. set lines 200...

Recover data of table from FLASHBACK

›
In this post , we are going to explain how can you recover the data of a table from the past timestamp with FLASHBACK on