Installation of PostgreSQL 11.4 On Windows Platform In this article , we will see how to download and install PostgreSQL 11.4 on Windows platform. STEP 1 : As a first step we need to download the PostgreSQL by using the below link. https://www.postgresql.org/ Click on… Read More
Dear Readers, In this article we will see Introduction to Oracle RAC Environment. What is Cluster ? A cluster in computer science is a set of computing nodes that work together and can be loosely viewed as a single system. In other words A cluster consists of… Read More
Dear Readers, In this article, we will see the following Moving Online Data files in Oracle 12c. In order to rename, move and relocate a datafile up to 11g, we had to put a tablespace or database completely offline. As we can see here drawback… Read More
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More
Dear Readers, In this article we will see Key structures in Cassandra. Node Node is the basic infrastructure component of Cassandra. Where we can store data in a cluster. Cassandra is a Masterless architecture so all nodes in a cluster having same priority. Datacenter… Read More
Enable Instant File Initialization You may want to consider enabling Instant File Initialization (via SE_MANAGE_VOLUME_NAME a.k.a. “Perform volume maintenance tasks”) for your SQL Server startup/service account. This option allows for much faster data file allocations (CREATE AND ALTER FILE) but DOES NOT WORK FOR LOG FILE… Read More
