When to Use Index Organized table? What is Index Organized table? In Heap tables, oracle stores the data in data segment with ROWID. When we create the index, oracle stores the index key value and ROWID in the index segment. So the index key value and rowid are stored in both index & data segments.… Read More Index Organized Tables
1.MAXTRANOPS — Divide large source transactions into smaller on target system. 2.GROUPTRANOPS — Decide number of sql records to be grouped into replicat trnsaction 3.NUMFILES — USe NUMFILES to control the number of memory structures allocated to contain info about source and target tables present in map statement 4.OBEY FILE_NAME — To retrive parameter from… Read More GOLDENGATE PARAMETERS – 1
Golden Gate Install ON SQL SERVER Revised: 5 August 2016 SQL Server instance access (public and dbreader) for AD groups: Foc\administrator SQl Server GG user service account (??gguser) The following steps will be performed Remote and Log on to the GG installation server. Create GGS folder on the specific drive. Expand… Read More Install Goldengate on Sql Server Failover Cluster
Create new folder with name as GG_New for V11.2 Expand the zip Run GGSCI.EXE ,Create SUBDIRS and the EXIT Create OLD_PRM Folder inside GG_New Copy param files from dirprm of OLD_GG Copy param files to dirprm of GG_NEW and OLD_PRM folder present inside GG_NEW Alter the EXTAP AND EXTAP_A replicats ,and remove the old parameter… Read More GoldenGate Upgrade from V11.1 to V11.2
The Steps to Upgrade GoldenGate from verison 12.1 to version 12.2… Read More goldengate upgrade v12.1 to v12.2
[2016-04-23 16:35.58] ~ [kapil.kapil-PC] ➤ ssh -l oracle 192.168.186.131 Last login: Mon Apr 11 13:29:13 2016 from 192.168.186.1 [oracle@kapil ~]$ clear [oracle@kapil ~]$ [oracle@kapil ~]$ [oracle@kapil ~]$ [oracle@kapil ~]$ ps -ef | grep smon oracle 3853 3818 0 14:29 pts/2 00:00:00 grep smon [oracle@kapil ~]$ cd /u01/app/oracle/oradata/ [oracle@kapil oradata]$ ls test1 [oracle@kapil oradata]$ dbca [oracle@kapil… Read More Materialized View Easy Practicals
Online Segment Shrink Based on the recommendations from the segment advisor you can recover space from specific objects using one of the variations of the ALTER TABLE … SHRINK SPACE command. — Enable row movement. ALTER TABLE scott.emp ENABLE ROW MOVEMENT; — Recover space and amend the high water mark (HWM). ALTER TABLE scott.emp SHRINK… Read More Online Segment Shrink ?
Question: I added an index hint in my query, but the hint is being ignored. What is the correct syntax for an index hint and how do I force the index hint to be used in my query? Answer: Oracle index hint syntax is tricky because of the index hint syntax is incorrect it is… Read More The Syntax of index hint ?
sing Index Hints to Tune Oracle Performance By Dan Hotka Hints are CBO directives. If Oracle can use the hint, it will only produce explain plans that contain the hint directive. This article examines index hints. Knowing how to use these hints can help improve performance tuning. About index hints Oracle allows for specific indexes… Read More How the index hint works ?
How the APPEND Hint Affects Performance The APPEND hint tells the optimizer to perform a direct-path insert, which improves the performance of INSERT .. SELECT operations for a number of reasons: Data is appended to the end of the table, rather than attempting to use existing free space within the table. Data is written directly… Read More How the append hint affects Performace ?
kapil Jadhav 