Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction
Here I am presenting the Oracle tutorials on Various Oracle products
These articles will be really help in understanding the oracle products and getting started on Oracle system
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 …
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 »
Constraints on a table in Oracle can be found using the below viewsuser_constraints: It provides information about constraints owned by the current user.all_constraints: shows information about constraints accessible to the current user, including those owned by other users.dba_constraints: provides information about all constraints in the database and requires DBA privileges.User_cons_columns: it provides information about columns …
How to check all constraints on a table in Oracle Read More »
INTRODUCTION TO FNDLOAD CONFIGURATION FILE The contents of the configuration file are at the heart of the loader operation since they specify the structure of the data and the access methods to use to move the data between the data file and a database. A configuration file has the form: configuration_file ::= item { item …
