Because the segment space management of the tablespace of the AUD$ and FGA_LOG$ tables is not automatic, a “gc buffer busy acquire” wait event can …
Read More »
Because the segment space management of the tablespace of the AUD$ and FGA_LOG$ tables is not automatic, a “gc buffer busy acquire” wait event can …
Read More »With SQL Server 2016, we are now able to use parallelism in the query using INSERT INTO… SELECT with WITH (TABLOCK). In order for the …
Read More »The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …
Read More »What is Live Query Statistics Live Query Statistics is a feature that we can use with SQL Server 2016 Management Studio. But we can use …
Read More »When you want to disable the diagsnap feature that introduced with Oracle 12c Grid Infrastructure, ologgerd causes an error like “LoggerD –> Error connecting with …
Read More »What is a temporal table in SQL Server? We can store the history of inserts, updates and deletes by using temporal tables. Previously, we could …
Read More »In opatch operations, if the corresponding home is not included in the ORACLE_HOME parameter, all opatch related commands cause 134 errors. To avoid this error, …
Read More »We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. …
Read More »SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression …
Read More »We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …
Read More »