Query to get create dba directory statements of dba directories present in the database on October 13, 2024 oracle 11g oracle 12c oracle 19c +
Sql query to drop db links of other users on August 29, 2024 db link drop db link oracle 12c oracle 19c pl/sql +
Query to find the concurrent program Schedule on July 17, 2023 concurrent program Oracle oracle 12c oracle 19c oracle application oracle r12.2 Sql Query +
Query to check the patches applied in current adop patch cycle R12.2 on June 22, 2022 adop patch adpatch Applied patches downtime Hotpatch oracle 12c oracle 19c oracle r12.2 patch cycle patch run time R12.2 Sql Query +
Important Queries for cloning on March 31, 2022 Clone oracle 12c oracle 19c oracle database Oracle EBS Oracle EBS Workflow Sql Query +
Troubleshooting oracle long running request - Performance tuning on August 08, 2021 concurrent program long running Long running request oracle 19c oracle database performance tuning troubleshooting +
Oracle Standby Important queries on May 17, 2021 Disaster recovery DR queries dr query oracle 11g oracle 12c oracle 19c oracle database oracle database dr Sql Query Standby standby query sync +
Bug in oracle database- manipulating the last_ddl in oracle database on February 09, 2021 bug in oracle database database last_ddl time manipulating oracle database Oracle oracle 11g oracle 12c oracle 19c sysdate +
Blockchain table in 19c on February 09, 2021 blockchain blockchain table crypto currency OCI oracle 19c oracle 21c Oracle Cloud oracle database +