[vc_row][vc_column][vc_custom_heading text=”Top Reviews” font_container=”tag:h2|text_align:left|color:%23000000″ use_theme_fonts=”yes”]
Below are the steps for adding a new table to the existing extract and replicat. In this example, we will add PRESPLAY.SAL table to existing replication. 1.stop extract and pump process [ SOURCE] GGSCI > info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING…
Oracle database Size depends on the volume of data stored on disk or ASM. You can check size of Oracle database from query mentioned below. As an Oracle DBA this is one of the important task to analyze the growth of the database. In detail, here you will get to know the actual size of the…
In the world of database solution, MongoDB is a relative newcomer. However, it has quickly gained enormous popularity because of the features it offers. MongoDB is a general-purpose, cross-platform, document-based database solution that falls under the NoSQL classification. It doesn’t follow the rules of traditional relational databases (for example, MySQL). Instead, it uses JSON-like documents…
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…
Raymond Kurzweil, a futurist and author of The Singularity is Near, the growth of progress is exponential. I.e. we’ll see 20,000 years of progress in the 21st century rather than 100 years of progress. Kurzweil also suggests that by the year 2020, the growth of integrated circuits will slow, and “another paradigm” will replace that and carry the…
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…
