Difference between Oracle and SQL server in GoldenGate setup. GG Setup on Oracle S/No Task/Feature Oracle Comments 1 Connectivity GGSCI> dblogin userid gger password userpw 2 Determine if change data
Introduction to SQL in Oracle. SQL was invented and developed by IBM in the early 1970’s. SQL stands for Structured Query Language. IBM was able to demonstrate how to
How to verify TDE Keys at OS and Database level ? Verify Encryption is enabled or not SQL> select tablespace_name,status,encrypted from dba_tablespaces; TABLESPACE_NAME STATUS ENC —————————— ——— — SYSTEM
How to run the sqlplus command in the background with one scenario. For all long running adhoc sql scripts , we can run the script in the background. For
Questions to ask application user for better understanding of the Performance Issue. There are is no step by step process to fix the performance issues. But if we have some
Oracle Query Performance issue and solved by accepting sql profile. Overview of the issue Oracle Query from application running was slower than the previous execution. DB version is 12.1.0.2.0
Adding and Dropping Redo log files in Oracle Database. Currently redo log groups are having 50MB size in each group, Task is to add new redo log groups with 250MB
Script to get DDL of the Database Links. To get DDL of all the DB links in the database SELECT ‘alter session set CURRENT_SCHEMA=’||U.NAME||’;’ ||CHR(10)|| ‘CREATE ‘ || DECODE
ORA-12850: Could not allocate slaves on all specified instances : 2 needed , 0(Zero) allocated Cause There is a new feature in 12C called “Automatic Report Capturing Feature”. As
How to reclaim space from the datafile level in Oracle. Description : Below script provides output with alter statements if at least 1MB can be reclaimed from the individual datafiles
