Ora-28001 the Password has Expired. How to Fix? 5 Solutions
If you are an Oracle database user you may face ora-28001 the password has expired problem. This means your password has expired already. So, you must fix this issue to
If you are an Oracle database user you may face ora-28001 the password has expired problem. This means your password has expired already. So, you must fix this issue to
Oracle table size does not fix it constantly changes with DML operation. There is not only one query to check the table size in Oracle. Some factors change the actual
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.
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
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
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
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
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
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
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
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |