This post is to create Promotion (trial) account for Oracle public Cloud. 1. Open below link in Web Browser. Enter Valid Email Address https://myservices.us.oraclecloud.com/mycloud/signup?language=en&sourceType=:ow:o:h:feb:TESTA 2. Click on Next Button. Which…
Read MoreIn this post, We will share – What is Terraform, How to install it, and How to Create EC2 instance via Terraform. What is Terraform Terraform is a tool for…
Read MorePlease follow the below for database clone through RMAN using standby database. 1) Step 1: ——————- a) Cancel the recovery in CTL DR on dbprod01. b) Open the database in read only mode.…
Read MorePlease follow the below steps to update the timezone to 26 for 12.2 database. conn / as sysdba purge dba_recyclebin; EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO(‘upg_tzv’) ; alter session set “_with_subquery”=materialize; alter session set…
Read MorePlease run the below query and get the explain plan for which baselines created for an SQL ID. col sql_text for a60 wrap set verify off set pagesize 999 set…
Read More-- STEPS: -- -- Disable constraints -- Disable triggers -- Copy -- Enable constraints -- Enable triggers SET SERVEROUTPUT ON PROMPT Enter the table's name you want to copy DEFINE…
Read Moreprompt -- Drop and create temporary table to hold stats... drop table my_index_stats / create table my_index_stats ( index_name varchar2(30), height number(8), del_lf_rows number(8), distinct_keys number(8), rows_per_key number(10,2), blks_gets_per_access number(10,2)…
Read More