What is Oracle Database cloning: A database clone is a complete and separate copy of a database system that includes the business data, the DBMS software, and any other application tiers that make up the environment. The cloning can be done on the same host or a separate host. What is the need for Database …
How to perform Oracle Database cloning Read More »
Often we set some parameters at the session level and run some commands. Now DBA may want to know what has been set in that session. In this post, we will check out How to list parameter set at the session level in Oracle How to list parameter set at session level using oradebug Using …
How to list parameter set at session level in Oracle Read More »
We often experience performance issues because of the inaccurate statistics for the objects involved and we want to know what the difference is between the statistics of good time and bad time With 12c, we can use the DBMS_STATS procedure to find the difference between the statistics How to compare statistics using history for a …
How to compare statistics using history for a table in Oracle Read More »
In previous Oracle E-Business Suite releases, the Application services were categorized into service groups according to the type of service provided. In Oracle E-Business Suite Release 12.2, this concept has been extended by the introduction of additional services and service groups. Here are the changes in Service Group R12.2 Enabling or disabling a service group …
In the previous article, we discussed changing the WebLogic password of EBS WebLogic Domain R12.2 if it is known. Changing the Oracle WebLogic password in R12.2 In this article, we will see the steps required to change the Admin Password which is lost or forgotten in an EBS WebLogic Domain in R12.2 EBS WebLogic Domain uses …
What are materialized views in Oracle? Privileges required to create materialized view User must have CREATE MATERIALIZED VIEW to create materialized view General Syntax CREATE MATERIALIZED VIEW BUILD [IMMEDIATE | DEFERRED] REFRESH [FAST | COMPLETE | FORCE ] ON [COMMIT | DEMAND ] [[ENABLE | DISABLE] QUERY REWRITE] [ON PREBUILT TABLE] AS ; Explanation of each term …
what is materialized views in oracle? Read More »
