SCRIPTS

How to Find Current SCN in Oracle 0 (0)

December 26, 2022

How to Find Current SCN in Oracle In this acrticle, we will demonstrate different ways to find current SCN in Oracle. Follow the below SQLs to find SCN in Oracle….

Loading

📌
0💬 read more

Oracle Database Appliance Odacli & Odaadmcli Command reference 0 (0)

September 21, 2022

Oracle Database Appliance Odacli & Odaadmcli Command reference In this blog, we will demonstrate several different usages of odacli, odaadmcli & virsh commands along with some commands output that can…

Loading

📌
0💬 read more

How to Find Database Properties in Oracle 0 (0)

May 6, 2022

How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch…

Loading

📌
0💬 read more

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

October 7, 2021

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database…

Loading

📌
0💬 read more

How to Enable & Disable Block Change Tracking (BCT) in Database Oracle 5 (1)

September 29, 2021

How to Enable & Disable Block Change Tracking in Database Oracle In this article, we will demonstrate How to Enable & Disable Block Change Tracking in Database Oracle. Block change…

Loading

📌
0💬 read more

RMAN Incremental Level 0 Database Backup Scripts in Oracle 1 (1)

September 28, 2021

RMAN Incremental Level 0 Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental Level 0 (L0) database backup which includes backup of…

Loading

📌
2💬 read more

How to Find all Physicals Files in Multitenant Architecture CDB and PDB DATABASE in Oracle 5 (1)

September 21, 2021

How to Find all Physicals Files in Multinanent Architecture CDB and PDB DATABASE in Oracle Below is the command, how to find all physical files in Oracle in one short…

Loading

📌
0💬 read more

How to Find ROLE Creation Date in Oracle 5 (1)

August 12, 2021

How to Find Role Creation Date in Oracle In this article, we will prepare an SQL command for How to Find ROLE Creation Date in Oracle. View DBA_ROLES doesn’t have…

Loading

📌
0💬 read more

Validate Applied Patches in Database Oracle 19c 5 (1)

August 10, 2021

Validate Applied Patches in Database Oracle 19c In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using…

Loading

📌
0💬 read more

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

June 3, 2021

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application…

Loading

📌
4💬 read more
1 … 5
Next »