Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …
Read More »ORACLE
How To Log More Detailed Information in Oracle Listener Trace?
If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …
Read More »Upgrade Oracle Opatch Version
OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …
Read More »How To Fetch Explain Plan
Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …
Read More »How to Unlock an Expired Oracle User Whose Password is Unknown
In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …
Read More »Oracle Password Expired Error
In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …
Read More »Update Table Without Update Permission On 11gr2
I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …
Read More »How To Connect To Oracle On Linux and Solution Of The Error:” error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory”
In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …
Read More »Improve Your SQL Statements Easily
Let’s assume that the sql_id of the query that we will improve is “bjyanqt9q718f”. First of all, we run the following procedure and create …
Read More »INITRANS benefit in tables and indexes with high I/O
If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be …
Read More »