Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Category: Oracle

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 10 Page 11 Page 12 … Page 20 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle 19c Data Guard Configuration Step by Step
  • How to Read an AWR Report in Oracle
  • Top 7 Oracle Wait Events Explained

Recent Posts

  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects
  • Oracle to PostgreSQL Migration Cost: A Realistic Breakdown
  • Why Companies Are Leaving Oracle for PostgreSQL (And How to Do It Safely)

Categories

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

Unmissable posts

  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle Exadata vs ExaCC vs ExaCS
  • Why Companies Are Leaving Oracle for PostgreSQL (And How to Do It Safely)
  • How to Read an AWR Report in Oracle
  • Oracle 19c RMAN Duplicate Database From Backup
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • 5 Oracle to PostgreSQL Migration Projects That Failed (And Why)
  • Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects
  • Oracle to PostgreSQL Migration Cost: A Realistic Breakdown
  • Why Companies Are Leaving Oracle for PostgreSQL (And How to Do It Safely)

Categories

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

EN
EN
ES FR

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