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
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
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
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 equipoise benefits used interchangeably though they are not the same. The
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” We always encourage the technical person to visit section SCRIPTS to get
Validate Applied Patches in Oracle 12c Whenever we do patch apply before/after, need to validate all applied patches in Oracle home & databases. Below is the command to validate patches in Oracle 12c. Command to validate applied patches on Oracle home. Click here to get sample output. SQL Command to validate applied patches in Oracle
How to Validate Invalid Objects in Oracle Whenever we perform such activities like database upgrade, refresh, clone, migration etc. We require to capture invalid objects before /after activities. Below are SQLs to find invalid objects. SQL to find invalid object types which are owned by the owner. Click here to get sample output. SQL to
How to Check Temp Tablespace Usage in Oracle Below is SQL query to find out temporary tablespace utilization of the database. Mountain climber | Exercise Videos & Guides | Bodybuilding.com monster steroids.net Dymatize Elite Casein at Bodybuilding.com: Best Prices for Elite Casein | Bodybuilding.com which includes Tablespace name(Temp tablespace), Total size, Used size, and Free
Sometimes we need to fetch ASM diskgroup utilization of the database in Oracle. Below is the SQL query to find ASM diskgroup size in a database which includes Name, Total_GB, Free_GB, Used_GB and Free_percentage of the disk. SQL query to fetch ASM diksgroup size. Click here to get sample output. Click here to know about
