Difference between clustering and mirroring - oracle

Difference between clustering and mirroring

Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds and connects based on availability. The user is completely ignorant of the fact that there are more than one database servers. It demands high cost due to infrastructure needs. Clustering is hence done on server level.

Mirroring means, one has many configured databases on the same server. Mirrors are basically copies of the original database. Mirroring is hence done on database level.
Difference between paging and fragmentation - oracle
Difference between paging and fragmentation - Paging is a concept occurring in memory, whereas, Fragmentation occurs on disk level...
Can you explain how to insert an image in table in oracle?
How to insert an image in table? - Insert image into a table: Create the following table: create table pics_table (bfile_id number...
How to find out second largest value in the table? - oracle
Second largest value in the table - SELECT * FROM EMP WHERE SAL IN (SELECT MAX(SAL) FROM EMP...
Post your comment