PostgreSQL 10 has very good new features. In my opinion, mainly new features are Logical Replication, Improved Parallel Query, Scram Authentication, Declarative Partitioning. Logical Replication : PostgreSQL has had physical replication that often called streaming replication since version 9.0, but this requires replicating the entire database, cannot tolerate writes in any form on the standby…
Find And Delete Files Greater Than Given Size on Linux
If you want to delete files which are greater than given size on Linux, you can use below examples by changing as your need. Delete Files Delete files which are size more than 2 MB. and type is jgp. [root@testserver ~]# find /tmp/ -type f -size +2M -name “*.jpg” -exec rm -rf {} \; Delete…
Oracle 11g R2 Resize Redo Log Size on Data Guard and Primary Database
Sometimes, you may need to change redo log size to perform optimum size for performance. If you want to change redo log size of both standby side and primary side, you can use below commands. Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in…
Oracle 11g R2 Open Data Guard Read Write Mode With Flashback Technology And Revert Restore Point
You can use flashback technology on standby side. If you want to make application test on database, you can use data guard as read write mode temporarily with flashback technology. You can create a restore point on standby side then you can do any transaction on standby side to test or any other purpose. After…
Oracle 11g R2 Data Guard Manual Switchover Steps
You can use the same steps to switchover for single data guard or multiple data guard configuration. Switchover operation will convert primary side to data guard and data guard to primary side. You have to control listeners whether it is running before switchover steps. Switchover Steps Primary Side SQL> alter system archive log current; SQL>…
Oracle 11g R2 Multi Real Time Apply Data Guard Configuration Steps
Oracle 11g R2 database supports multi standby database structure up to 30 standby databases. We can use remote destinations for real time apply standby structures with todays network technologies. If your remote destination network is not good, you can use archivelog apply for remote destination with some delay. System informations are like below. System Informations…
Oracle 11g R2 Cascade Standby Data Guard Installation and Configuration Steps
Oracle 11g R2 database supports cascade standby database structure. If you are using RAC on primary side, your database version has to be least 11.2.0.2 to support cascade standby structure. You can use to reduce the load on your primary database with using cascade standby database structure. Primary database redo is written to the standby…
Oracle 12c R2 Downloadable Now
You can download Oracle 12c R2 database now. Only Linux x64 and Solaris Operation Systems supported for now. You can download with below link; http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also you can find new features about of Oracle 12c R2 with below links; https://docs.oracle.com/database/122/ https://blogs.oracle.com/sql/entry/12_things_developers_will_love
Configure Default full-text language Parameter Server Configuration in SQL Server 2016
You can change default full-text language server configuration option in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL. default full-text language option specifies a default language value for full-text indexes. Linguistic analysis is performed on all data that is full-text indexed and is dependent on the language of the data. The default value of…
Round Up A Number By Protecting 2 Decimal in Oracle
I will show how to round up a number by protecting 2 decimal. When I use round or ceil function, I can not have correct result. I want to round a number upwards with calculate 2 decimal. I want result like below examples. 1.2445 > 1.25 1.21 > 1.21 1.521 > 1.53 1.1 > 1.1…