January, 2024 - Ennicode

Index Unusable Oracle | How to Find and Fix it

Oracle databases can have invalid indexes that are not usable. Such index unusable oracle state is UNUSABLE. Oracle DBA_INDEXES view returns all the indexes that are available in the database. ...

Asiri Gunasena

January 29, 2024

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

January 22, 2024

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

January 15, 2024

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

January 8, 2024

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

January 1, 2024

Month: January 2024

Index Unusable Oracle | How to Find and Fix it

Oracle databases can have invalid indexes that are not usable. Such index unusable oracle state is UNUSABLE. Oracle DBA_INDEXES view returns all the indexes that are available in the database. ...

Asiri Gunasena

January 29, 2024

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

January 22, 2024

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

January 15, 2024

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

January 8, 2024

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

January 1, 2024

Services

Resources

Contact