In this article, I will explain the startup and shutdown modes of Oracle database. Oracle Database Startup Modes A closed Oracle database opens in …
Read More »EOMONTH Function in SQL Server(TSQL)
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 …
Read More »ORA-12528: TNS:listener: all appropriate instances are blocking new connections
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 …
Read More »Computed Column in SQL Server
Computed Column is a column generated by a calculation using one or more columns in a table. For example, you have columns A, B …
Read More »Oracle 11g Software and Database Installation
In this article I will explain the software and database installation of Oracle 11g database. You can download Oracle 11g software from this link. …
Read More »ISDATE Function in SQL Server(TSQL)
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 …
Read More »How To Resize Datafiles in Oracle
We ensure that unused space in the datafiles are reclaimed by the ASM disk group with the resize process. This ensures that unused areas …
Read More »How To Install Telnet Client On Windows Server 2012
We use Telnet Client to check if the port we want to use is open when we access a server from another server. In …
Read More »GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME Functions in SQL Server(TSQL)
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 …
Read More »How To Calculate IOPS of an Oracle Database
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 …
Read More »