With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued …
Read More »How To Change AWR Retention and Interval Values
If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the …
Read More »What is Query Store in SQL Server
The Query Store is a feature that introduced in SQL Server 2016. In order to understand the Query Store, it is necessary to understand the …
Read More »Java.Lang.OutOfMemoryError
OutOfMemoryError error may be received because of inadequate memory when running addnode.sh or during Oracle database installation. addnode.sh is terminated as follows when the error …
Read More »Database Engine Tuning Advisor(DTA) in SQL Server
Database Engine Tuning Advisor (DTA) examines how queries are running in the database and provides us with suggestions. It has its own interface. You can …
Read More »ORA-00603 ORA-03106 Errors in DB Link Connections in Oracle 12.2 Databases
When connecting to Oracle 12.2 databases from different databases with db link, reco process terminates unexpectedly. This problem is caused by bug 27544973. In order …
Read More »How To Uninstall SQL Server Service Pack or Cumulative Update
With SQL Server 2008, we can now easily uninstall Service Packs and Cumulative Updates from Control Panel, Programs and Features. Especially in case of a …
Read More »Drop Indexes Online Without ORA-0054 Error
Prior to the Oracle 12c version, droping an index was an offline process that put a lock on the original table in exclusive mode. Exclusive …
Read More »BULK INSERT in SQL Server
With BULK INSERT you can upload text, csv data files to the database in any format. Users must have insert privileges in the database and …
Read More »How To Check All Session Information in Oracle
We often need to get information about existing sessions in databases. We can find the below details with the help of the following query. Which …
Read More »