Introducing Oracle Net Services Oracle Net services are often used to enable network connections for applications or different clients to connect to databases. Allows connection …
Read More »dbtut
How To Change Instance Settings in SQL Server
In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties. You will …
Read More »Multitenant Database in Oracle
What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It consists of a container database, …
Read More »Version Store Space Usage in Tempdb(sys.dm_tran_version_store_space_usage)
With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space due to row versioning in …
Read More »“library cache lock, gc cr request and gc buffer busy acquire” Wait Events After Upgrade to Oracle 12.2
When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …
Read More »SELECT INTO On Filegroup
Tables created with SELECT INTO prior to SQL Server 2017 could not be created on a filegroup other than the PRIMARY filegroup. Now we can …
Read More »ORA-08102: index key not found
During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …
Read More »Automatic Tuning in SQL Server
What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database feature that identifies potential performance …
Read More »ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present]
Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …
Read More »Resumable Indexes in SQL Server
What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In …
Read More »