What is Temporary Undo?
Temp tables are widely used for preparing intermediate results. Modifying these tables is much faster than regular tables. The performance...
October 11, 2024
DATABASES
2024
resmgr:cpu quantum wait event
The “resmgr:cpu quantum” wait event is seen when the session is waiting for some CPU resources to be allocated. This...
October 11, 2024
How to setup database link from Oracle to SQL Server database using Heterogeneous Services ?
You can review the following document to access tables in the MSSQL database using the DBLINK architecture over the Oracle...
October 9, 2024
CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time
In Grid versions 12.2.0.1 and later, although the time is the same in all nodes, the following error is seen...
October 8, 2024
How to bring up Oracle Exadata infiniband switch ports when they are down due to AutomaticHighErrorRate?
When the number of errors on Oracle Exadata infiniband switch ports reaches the specified threshold values, it is automatically brought...
October 8, 2024
Users which have Create any procedure and Execute any procedure privilege can assign themselves the DBA role.
In Oracle databases prior to 12c, users which have create any procedure and execute any procedure privileges could assign themselves the dba role. This...
October 8, 2024
How to rename an existing user on mysql server ?
It is possible to change the name of an existing user on the MySql server later. To do this, you can...
September 27, 2024
Temporary tables in Mysql databases
Temp tables can be very useful for holding temporary data. Temporary tables option is available in MySQL versions 3.23 and...
September 25, 2024
What is Supplemental Logging?
Redo log files are often used for instance recovery and media recovery. The data required for such operations is automatically...
September 25, 2024
