Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

Posts

Posted on October 11, 2022September 17, 2023

How to Create an Oracle Guaranteed Restore Point on Data Guard

green pine tree leaves

When you are doing an important change to your Oracle database, you need to be able to go back to the point you were before the change in case something goes wrong.

There is no better way to go back in time than with a guaranteed restore point.

Continue reading “How to Create an Oracle Guaranteed Restore Point on Data Guard”
Posted on October 9, 2022October 9, 2022

How to Get the sql_id of a Query in Oracle

a person sitting on wooden planks across the lake scenery

You might need to get the sql_id of a Query in Oracle to troubleshoot some performance problem or just to check some stats.

This is the simplest way to do it.

Continue reading “How to Get the sql_id of a Query in Oracle”

Posts pagination

Previous page Page 1 … Page 23 Page 24 Page 25 … Page 42 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • PostgreSQL Monitoring: How to Keep Your Database Healthy
  • How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium

Recent Posts

  • PostgreSQL repmgr with Keepalived Adding a Floating VIP
  • PostgreSQL repmgr Setup Replication with Automatic Failover
  • PostgreSQL 18 Backup & Recovery Lab on Ubuntu 24.04 — pg_dump, pg_basebackup and pgBackRest
  • How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium
  • How to Install ora2pg on Ubuntu and Run a Migration Assessment Report

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Oracle to PostgreSQL
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress