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 »Can not Copy and Paste to Remote Desktop
Sometimes you cannot copy your scripts or files to the database server. If you don’t know the solution, it can be a very frustrating. …
Read More »DAY, MONTH and YEAR Functions in SQL Server(TSQL)
We can find the day using DAY function, month using MONTH function and year using YEAR function from a date. It takes the date() …
Read More »Why Exadata Disks in “CLOSED” or “IGNORED” Status(v$asm_disk)
Some of the disks may be in CLOSED and IGNORED status when “v$asm_disk” is queried after a broken disk on the Exadata storage is …
Read More »What is SQL Server Synonym and How To Use It
Synonym is to give alias (an alternative name) to some objects on a database basis. The synonym can be created for following objects. Table View …
Read More »How To Convert Gregorian Date to Hijri Date or Hijri Date to Gregorian Date
A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in …
Read More »DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS Function in SQL Server(TSQL)
We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …
Read More »How To Change Owner of Database in SQL Server(ALTER AUTHORIZATION)
When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …
Read More »Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors
When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob …
Read More »Queries that cause a “cursor: mutex S” wait event
The “Cursor Mutex S” wait event occurs when two different sessions try to make hard or soft parsing on the same query. As a …
Read More »