We can use the Oracle ASM configuration assistant (asmca) tool via the GUI, or from the command line. In other words, we can run …

  I received this error when I right-click on the database and click Properties. Property Size is not available for Database. This property may not …

You can find the last day of a month using EOMONTH function. In addition, you can use a second parameter that add a specific number …

When trying to connect to an open intance via the listener, you may receive the error “ORA-12528: TNS: listener: all appropriate instances are blocking new …

  Computed Column is a column generated by a calculation using one or more columns in a table. For example, you have columns A, B …

You can check the expression is a valid date, time or datetime value using ISDATE Function. This function’s return type is int. Before using this …

  We ensure that unused space in the datafiles are reclaimed by the ASM disk group with the resize process. This ensures that unused areas …

  We use Telnet Client to check if the port we want to use is open when we access a server from another server. In …

  I will explain GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME functions in this article. GETDATE Function in SQL Server(TSQL): We can obtain current database timestamp as …

IOPS (Input/Output Operations Per Second) is a common performance metric used to compare computer storage devices. IOPS in Oracle databases is the total number of …