Month: October 2020
How to check table or segments size in a schema in Oracle
To check the size of table or segments in a schema in Oracle In an Oracle database, a segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. To be precise, segments contain the real data and they usually remain in the owner’s default tablespace […]
419 Total Views, 3 Views Today
How to Compile Invalid Public Synonyms
Steps to compile invalid public synonyms In my environment after doing an application upgrade some of the public synonyms get invalid. Below is the query to check invalid public synonyms or if you want to check the invalid objects in the database. Click here for sample output. Invalid object in database Below is SQL command […]
465 Total Views, 14 Views Today
How to Find Date after Upgrade or Downgrade in Oracle
Find Date after Upgrade or Downgrade in Oracle Today, my one DBA friend asked about how to validate the database upgraded or downgraded from which version along with what was the date. So, I thought it better to publish which helps my DBA friends. Below is an SQL command to validate in the database about […]
596 Total Views, 6 Views Today
How to check size of a schema in Oracle
Check Schema size in Oracle A schema in an Oracle database is defined as a collection of database objects and is owned by a database user. The schema name shares the same name as the user due to which both the terms are sometimes used interchangeably though they are not the same. The below query […]
1,053 Total Views, 8 Views Today
Oracle Critical Database Patch IDs for October 2020
Oracle Critical Database Patch IDs for October 2020 Patch Release by Oracle An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and in third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary […]
2,475 Total Views, 3 Views Today
ORA-01102: Cannot Mount Database in EXCLUSIVE mode
ORA-01102: Cannot Mount Database in EXCLUSIVE mode When we are doing database refresh from Prod to Dev (lower environment), At that time we put the cluster database parameter to false. This parameter is spfile file specific, so we need to bounce the database. After the refresh completed successfully, we are trying to start the node, […]
1,297 Total Views, 5 Views Today
How to Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS in Oracle
Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS SQL command for standalone database. Click here to get sample output. SQL command for RAC database. Click here to get sample output. Click here for “How to increase Processes, Sessions and Transactions Initialization Parameters” Hope so you like this SCRIPT!Please share your valuable feedback/comments/subscribe and […]
606 Total Views, 3 Views Today
How to Validate Applied Patch in Oracle
Validate Applied Patches in Oracle 12c Onward Whenever we do patch apply before / after, need to validate all applied patches in Oracle home & databases. Below are commands to validate patches in Oracle. Command to validate applied patches on Oracle home. Click here to get sample output. SQL Command to validate applied patches in […]
441 Total Views, 2 Views Today
How to Check when Database was Last Cloned or Open Resetlog Mode in Oracle.
How to Check when Database was Last Cloned or open Resetlog Mode in Oracle. If we want to find when was my database cloned last time or when you open your database in reset log mode. Here is the demonstration. Below is the query to find rest log date and time of the database. SQL […]
390 Total Views, 1 Views Today
Step by Step Installation of Oracle Client
Step by Step installation of Oracle Client As most of us already know oracle client is installed on the application server to execute SQL command or compile script related to the application. Below is the step by step installation of Oracle client on UNIX. Step1: Created users and group Below we are creating groups and […]
1,059 Total Views, 3 Views Today
Recent Comments