What is Virtual Index in Oracle ? A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. Many time sql tuning advisor recommends you creating new index and you want to test the new index. In this case It can take good amount of time […]
How to use Virtual Index in Oracle Database Read More »
How to check logs in adop The adop log files are located on the non-editioned file system (fs_ne), under: s_ne_base/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log For example, if s_ne_base was /u00/app/TECHGO/fs_ne, the session ID was 10, and the <CONTEXT_NAME> was techgo_server, the path to the adop log files from 1th May 2016 would resemble this: /u00/app/TECHGO/fs_ne/EBSapps/log/adop/10/apply_20160501_101121/techgo_server Each cycle of adop
adopscanlog log analyzer utility in R12.2 Read More »
How Incremental statistics works Incremental global statistics work by storing a synopsis for each partition in the table. A synopsis is a statistical metadata for that partition and the columns in the partition. Each synopsis is stored in the SYSAUX tablespace. Global statistics are then generated by aggregating the partition level statistics and the synopses
Incremental Statistics Gathering Read More »
Microsoft Excel is used by almost everybody. Here are some of the cool Excel features that everybody should be aware Excel has a powerful list of functions to solve various problems and tasks. You can use sum, concatenate, average, if. The list goes on 2) Auto Filter This is one of the best functions to use
7 easy and powerful feature of Microsoft excel you may not know about Read More »
How to change the weblogic password post-TXK 7 The below command is available only if TXK 7 is applied. 1. Shut down all application tier services except the Admin Server. On the primary node, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdminOn all secondary nodes, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh 2. Change the Oracle WebLogic Server Administration User
How to change Oracle WebLogic User Password in R12.2 Read More »
What is Table Monitoring in Oracle Table monitoring is checking for how many updates, deletes, and inserts happened in the tables so that we can find out if the statistics are stale or good for the table. It is a very useful functionality in gathering stats for the tables in Oracle How to Set the
Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL Read More »
