Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value. If both the spfile and …
Read More »dbtut
SET LANGUAGE and @@LANGUAGE Function in SQL Server(TSQL)
We can set a session’s language With SET LANGUAGE Command. This command affects the system datetime format and system messages. If you want to …
Read More »The Extended Events session named “x” could not be found. Make sure the session exist and is started.
One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how …
Read More »SUM Function in SQL Server(TSQL)
We use SUM Function to calculate the sum of values in a column. SUM is a aggregated function and generally we use it with …
Read More »ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage …
Read More »“Database ‘x’ cannot be opened due to inaccessible files or insufficient memory or disk space” and “Initializing/Recovery Pending”
There may be several reasons for this error. A friend of mine said that when he received this error, the database files were deleted. …
Read More »STRING_AGG Function in SQL Server(TSQL)
We can concatenate string columns with STRING_AGG function. STRING_AGG function requires 2 argument. Thats why we must put seperater between values. Let’s make examples …
Read More »ORA-08104 error received during index rebuild process
During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it …
Read More »How To Move Msdtc Disk To Another Storage
To move the MSDTC disk to another storage, we need to remove MSDTC from the cluster and then re-add to the cluster. To remove …
Read More »Hybrid Columnar Compression
Hybrid Columnar Compression (HCC) introduced with Oracle Database 11g Release 2. HCC is a feature that can be used with Exadata storage, Pillar Axiom …
Read More »