Home » Page 6

Incremental Statistics Gathering

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 »

basic unix commands pdf

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 …

basic unix commands pdf Read More »

How to change Oracle WebLogic User Password in R12.2

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 »

How to check all constraints on a table in Oracle

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 »

Scroll to Top