Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »ORACLE
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 »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 »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 »Increasing the performance of global cache service(LMSn) in Oracle
The global cache service (LMSn) processes copy consistent copies of blocks in the buffer cache to the requesting instance’s foregound process. LMS also performs …
Read More »Configure Automatic Memory Management in Oracle
To configure Automatic Memory Management(AMM) in databases that do not use AMM, it is necessary to change the required parameters and restart the database. When …
Read More »Find Privileges Granted to a User in Oracle
It is possible to find the privileges granted to a user with the data dictionary views. The main views that can be used are …
Read More »How To Reset an Oracle Database Parameter
We can set a parameter in the Oracle database to its default value. The reset process is only performed in the spfile. The parameter …
Read More »ORA-600 [ktspfhsp-9]
During the insert operation to the tables, ORA-600 [ktspfhsp-9] error is received due to various bugs and corruption in the segments of the table. …
Read More »