Top Reviews

Oracle Unveils AI-Voice for the Enterprise Oracle introduces natural voice conversations to Digital Assistant and enhances deep learning semantic parser to handle complex linguistic constructs

Oracle today announced availability of its AI-trained voice with Oracle Digital Assistant. Now, enterprise customers can use voice commands to communicate with their enterprise applications to drive desired actions and outcomes, enriching the user experience with conversational AI, simplifying interactions and improving productivity.  “Enterprises are demanding an AI-powered voice assistant that understands their specific vocabulary and enables…

Read more

Performance Recommendations in Azure Database for PostgreSQL – Single Server

Applies to: Azure Database for PostgreSQL – Single Server versions 9.6, 10, 11 The Performance Recommendations feature analyses your databases to create customized suggestions for improved performance. To produce the recommendations, the analysis looks at various database characteristics including schema. Enable Query Store on your server to fully utilize the Performance Recommendations feature. After implementing any performance recommendation,…

Read more

PostgreSQL 11 Streaming Replication/Hot Standby

To create PostgreSQL replication first we must install PostgreSQL on  Primary and  Standby server. On Primary and Standby: [root@localhost ]# yum -y install epel-release [root@localhost ]# yum -y install bash-completion [root@localhost ]# yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm [root@localhost ]# yum install postgresql11-server [root@localhost ]# yum install postgresql11-contrib On Primary: [root@localhost ]# /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ……

Read more

Scenario 1 – Restore control file from backup after loss of all control files

Condition: All copies of the control file have been deleted The data is in the order of files and online redo logs Our control file has backups Database archive works in log mode First we look at where our control files are located SQL> select name from v$controlfile; NAME ——————————————————————————– /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/oradata/DB11G/control02.ctl   We then…

Read more

Scenario 2 – Loss of all control files

Condition: All control files have been deleted After backup of the control file, the newly created data file was deleted The control file has a binary backup . To test this situation, we first get the binary backup of the control file and then delete all the control files: SQL> alter database backup controlfile to…

Read more