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 »dbtut
“Arithmetic overflow error converting expression to data type int.” Error When Using SUM Function
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 »Replacing a Damaged Hard Disk on Exadata
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 »What is Remote Diagnostic Agent (RDA)
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 »Ad hoc update to system catalogs is not supported
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 »Oracle 12c DBCA Changes and Create Container Database with DBCA
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 »Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)
In this article, I will describe a few of the most known types and solutions of this error. Possible Errors Transaction Log is Full Due …
Read More »Oracle Reserverd Words
Some words in the Oracle database are reserved for specific use or fully. In this way, it is intended to eliminate possible typographical errors in …
Read More »What is Indexed View in SQL Server and How To Create an Indexed View
We create Indexed Views by adding indexes to views. For detailed information about the View concept, I would recommend you read my article “What is …
Read More »What is View in SQL Server and How To Create a View
We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no …
Read More »