As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …
Read More »
As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …
Read More »In case of a damage of the flash modules(fmod) on flash cards on Exadata cellnodes, the flash cache will not function normally and there will …
Read More »You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you …
Read More »You can perform the hard disk replacement on Exadata cellnodes by performing the following checks and steps. Hard Disks on the cell node are automatically …
Read More »The Remote Diagnostic Agent (RDA) is a tool provided by Oracle that collects data about your database environment and reports it as a web page. …
Read More »In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …
Read More »Description: As we know, we can’t create a function-based index on MySQL, not like PostgreSQL (https://www.postgresql.org/docs/current/indexes-expressional.html). Usually, we should avoid using functions in the where …
Read More »You may receive this error when you want to chage an instance level parameter by using sp_configure in SQL Server. I would recommend reading the …
Read More »Changes in DBCA in Oracle 12c There were some changes in dbca tool in 12c. Now we can create container and pluggable database with DBCA. …
Read More »Security is the biggest concern nowadays particularly for those who manage critical applications.Every database must have …
Read More »