1)Get ACL details in the database.
2)How to Find the optimal undo retention size in the database.
3)Find who locked your account.
4)Find active transactions in db.
5)Archive generation per hour.
6)Find duplicate rows in the table.
8)Generate resize datafile script.
10)Scn to Timestamp and Timestamp to Scn.
11)Get Database incarnation information in the database.
12)How to get CPU memory info in the server.
14)Get DDL of all tablespaces.
15)How to purge AWR old snapshot details in database.
16)Generate Bulk AWR reports in the database.
17)How to find current redo log size in database.
19)Get database link details in the database.
20)How to Modify window_size/ window baseline size.
21)Get DDL of privileges granted to user.
22)Get timezone information in the database.
23)How to View / Modify AWR retention period.
24)Check the Character set info of the database.
25)Check Installed RDBMS components.
26)How to Get Alert log location in db.
27)Get installed SQL patches in the database.
29)Get sql query to html format.
30)Row count of all the tables of a schema.
31)Disable or enable all triggers of schema.
32)Get the size of the database.
33)How to clean up orphaned data pump jobs.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8