Types of jobs and their resolutions .odf files : -odf files are there to create tables, indexes and views etc.-If encountered locking, identify the session that holds the lock and kill the session. Do not skip the job because of locking. Sometimes odf failed to drop the index. then you can manually drop the index …
Troubleshooting adpatch/adop failed job 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 …
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 »
We have touched upon many unix commands before in the previous article. Here are some more commands with downloadable basic unix commands pdf mv – move files(s) /dirs Options: – -f mv will move the file(s) without prompting even if it is writing over an existing target. -i mv will prompt for confirmation whenever …
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 …
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 »
