We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …
Read More »
We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …
Read More »We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating our database server or normal …
Read More »Creating a new instance using Oracle Database Cloud Service on Oracle Cloud is called database deployment. It is possible to simply create a database and …
Read More »Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking new index, or using the …
Read More »If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory …
Read More »In Mysql servers, the following methods can be used to find where the error log file is. Find where the Error Log is with SELECT …
Read More »In MySQL NDB Cluster databases, when the data memory is full, “The table is full” error occurs in all operations in the tables. To resolve …
Read More »You can use the below functions to convert the timestamp to date and date to timestamp. timestamp to date -> from_unixtime() date to timestamp -> …
Read More »In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend …
Read More »To check connected users in MySQL database and what operations are performed, we can use mysql cli or we can obtain same information through queries. …
Read More »