Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …
Read More »
Tag Archives: oracle
INDEX SCANS IN ORACLE
The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …
Read More »
SQL Profiles and Baselines
Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …
Read More »How to Start Oracle Database Automatically When Linux Server Is Started
In this article, I will share linux scripts with you for staring database automatically when operating system is started. My environment is: Oracle 11.2.0.4 …
Read More »Oracle – Recreate Central Inventory in Clustareware in Linux
In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …
Read More »New Audit Mechanism on Oracle 12c : Unified Auditing
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 »How To Cancel Concurrent Request from Back End
There are 2 Steps for Cancelling Concurrent Request from Back End : Step 1 :- 1. Run the below SQL query. Give the …
Read More »