0 Comments

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 464 total views,  3 views today

0 Comments

How to check ASM diskgroup Size. 0 (0)

Sometime we need to fetch ASM diskgroup utilization of database. Below is the sql query to find ASM diskgroup size in database which includes Name,Total_GB,Free_GB,Used_GB and Free_percentage of disk. Sql query to fetch ASM diksgroup size. Click here to get sample output . Reference: How to add disk into ASM diskgroup. click here Hope so […]

 185 total views

Spread the love

0 Comments

How to check tablespace size. 5 (2)

Below sql query is used to find total tablespace size of your database. which includes Tablespace name used size in MB, free size in MB and Total size in MB Sql command which fetch tablesapce size in GB Click here to get sample output Hope so you like this script, please share your valuable feedback […]

 137 total views

Spread the love