SQL Query to Check Password Expiry Date in Oracle | How to Turn Off?
Database user password expiry date is important to access the database and there is an SQL query to check password expiry date in Oracle. Here I would add some frequent ...
Asiri Gunasena
Read More..
How to Check Database Name in Oracle | 6 Tips
If you want to check database name in Oracle that you connected there are several ways to get it. I added 6 different methods to check it. Sometimes if you ...
Asiri Gunasena
Read More..
Oracle Long Running Queries | Health Check Now
Oracle databases have great ways of taking Oracle long running queries. I hope to add some examples of queries below. I would like to use some Oracle views for performance ...
Asiri Gunasena
Read More..
how to check running queries in Oracle | Performance Tips
If you have a problem with how to check running queries in Oracle? The answer is using System views like V$SESSION, V$SQLTEXT_WITH_NEWLINES, and V$SQL to retrieve information about running queries ...
Asiri Gunasena
Read More..
Oracle INDEX_DESC | How to Change Performance
If you are wondering how to use the Oracle index_desc hint, then the Oracle index_desc hint is used when descending the existing index on a range scan. This hint is ...
Asiri Gunasena
Read More..
Oracle COALESCE vs NVL Performance | What is Good
Once comparing the Oracle COALESCE vs NVL performance most of the searches say those are mostly equal. But I also hope to do a complete analysis with data load for ...
Asiri Gunasena
Read More..
How to Change DISTINCT vs GROUP BY Performance Oracle
Distinct vs Group By performance oracle can be changed due to several conditions. Generally, Both are Distinct and Group By clauses doing similar work. But then why do we have ...
Asiri Gunasena
Read More..
How to Use Average in SQL Oracle: 5 Simple Examples
The average in SQL Oracle function is an aggregate and analytic function taking an average of a set of numeric value lists. The AVG() function is able to average DISTINCT ...
Asiri Gunasena
Read More..
