XMLImporter and FndXdfCmp are the implement utilities in Oracle E business Suite for implementing new OAF pages and new schema definition and changes XMLImporter is used for new OAF pages and personilization in the oracle database while FndXdfCmp is used for new schema definition and changes Here are the steps on how to use XMLImporter and …
how to use XMLImporter and FndXdfCmp in Oracle EBS Read More »
With 11gR2, Oracle has introduced Edition-based redefinition to help in online modification. R12.2 Online Patching also uses the same feature to achieve Online patching.in R12.2 Editions are synced between the OS filesystem and database Two Edition Definitions Runtime: Used by Online Users, Never changed by a PatchPatch: Used by the Patching Tools, Changes do not …
Automatic statistics collection is a new feature starting 10g. Oracle has done a lot of changes to it starting with 11g. In this article, we will see How to check automatic statistics collection in Oracle, How to enable automatic statistics collection in Oracle What is automatic statistics collection? Automatic statistics jobs automatically gather Missing and …
How to check automatic statistics collection in Oracle in 11g Read More »
Password version in Oracle is a new column in DBA_USERS starting 11g. The PASSWORD_VERSIONS column shows the list of password versions that exist for the account. 10G refers to the earlier case-insensitive Oracle password DES-based version 11G refers to the SHA-1 version, and 12C refers to the SHA-2-based SHA-512 version. It is defined as below …
We can create a stat table in Oracle that can be used to store statistics of the schema, tables, and indexes. In this post we will see how to create and drop the stat table in Oracle, and what are the uses of it. what is the structure of the table? How to create stat …
As we know that DBMS_STATS takes a backup of the statistics every time dbms_stats is run on the table. So we can restore the statistics from the backup. In this article, we will see, How to restore optimizer statistics in Oracle, How to check the retention of the statistics How far back in time we …
How to restore optimizer statistics in Oracle Read More »
