Auto Added by WPeMatico
Lets see the steps. 1. Download the goldengate software for the appropriate os platform. Download the goldengate 12c software from edelivery. 2. unzip the V46695-01.zip and execute runInstaller [both SOURCE & TARGET ] [oracle@presplaySRV210 sf_stuff]$ unzip V46695-01.zip [oracle@presplaySRV210 sf_stuff]$ cd fbo_ggs_Linux_x64_shiphome [oracle@presplaySRV210 fbo_ggs_Linux_x64_shiphome]$ ls -ltr total 0 drwxr-xr-x. 5 oracle oracle 66 Aug 7 2014…
4 types of data migration are the process of transferring data from one area to another, one system to another, or one application to another. Generally, this is the result of introducing a new system or location for the data. However, data migration is never as easy as it may sound. According to The Bloor Group, more…
Oracle database version 12.2.0.1 is recently released. I searched the database software for Solaris platform, Found it in oracle edelivery. I downloaded the software from edelivery and did an installation and upgrade on a test box. Here we will first Install 12.2. ORACLE_HOME and then upgrade the database TESTDB ( which is on 12.1.0.2…
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile. Diagnostic and Tuning license is required to use this feature In this below tutorial we will explain how to run sql tuning advisor…
Here are the top level directories in your Linux system, with a brief explanation of the purpose of each: /: The top level directory in your system. It’s called the root directory, because it’s the root of the system: all the rest of the directory structure emanates from it like branches from the root of…
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is enable? — DB_CACHE_ADVICE should be ON SQL> show parameter db_cache_advice NAME TYPE VALUE ———————————— ——————————– —————— db_cache_advice string ON — STATISTICS_LEVEL should be TYPICAL/ALL. SQL>…