Top Reviews

How to Find Out the size of your Oracle Database

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…

Read more

How to Install and Use MongoDB on Linux Mint

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…

Read more

How to Install Oracle Goldengate 12c on Linux 7 OS

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…

Read more

How to Perform a Successful Data Migration

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…

Read more

How To Run SQL Tuning Advisor For A Sql_id

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…

Read more

How to Shrink Temp Tablespace and Reclaim Unused Space in Oracle

In this article, we will discuss about temporary tablespace usage and shrinking tempfiles to reclaim unused space from the TEMP tablespace in Oracle. Temporary tablespaces are used for database sorting and joining operations and for storing global temporary tables. It may grow in size over a period of time and thus either we need to…

Read more