Gather Database Stats Gather Dictionary Stats Gather FIX OBJECTS STATS Gather Schema Stats Gather Table Stats […]
Oracle Gather Stats
Category: Oracle
Looking for Locking / Blocking Sessions in ORACLE
There are many ways to find locking /blocking sessions in Oracle, this is what I normally use. If Blocker is identified, in certain case you many need to kill the blocker session with below command: […]
Step by step instruction to setup an Oracle Active Standby Instance using RMAN
This instruction is created for Oracle on Windows, it also applies to Unix/Linux installations. The difference will be mainly the folder path locations. Master Instance: ProdServer:1521/DB1 Target Active Standby Instance: StandbyServer:1521/DB1STANDBY (new installation) Preparation: Run below query to check if ARCHIVING LOG, FORCE LOGGING is enabled on the Primary database, if not enable them. On […]