SCRIPTS

How to check table or segments size in a schema in Oracle 5 (2)

October 30, 2020

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…

Loading

📌
0💬 read more

How to Compile Invalid Public Synonyms 4 (1)

October 28, 2020

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…

Loading

📌
0💬 read more

How to Find Date after Upgrade or Downgrade in Oracle 5 (1)

October 27, 2020

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…

Loading

📌
0💬 read more

How to check size of a schema in Oracle 4 (3)

October 26, 2020

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…

Loading

📌
4💬 read more

How to Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS in Oracle 0 (0)

October 20, 2020

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…

Loading

📌
0💬 read more

How to Validate Applied Patch in Oracle 12c 0 (0)

October 19, 2020

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…

Loading

📌
0💬 read more

How to Check when Database was Last Cloned or Open Resetlog Mode in Oracle 4 (1)

October 17, 2020

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…

Loading

📌
0💬 read more

How to Validate Invalid Objects in Oracle 5 (2)

October 14, 2020

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…

Loading

📌
0💬 read more

How to Check Temp Tablespace Usage in Oracle 0 (0)

October 13, 2020

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…

Loading

📌
0💬 read more

How to check ASM diskgroup Size in Oracle 4.8 (4)

October 10, 2020

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,…

Loading

📌
4💬 read more
« Previous
1 2 3 4 5
Next »