VDB template for Delphix

 ---

version: 1

type: OracleVDB

timeflowPointParameters:

  type: OracleTimeflowPointSemantic

  container: <SOURCE_CONTAINER_NAME>

parameters:

  dSource:

    type: OracleDataNode

    container: <SOURCE_CONTAINER_NAME>

    config:

      type: OracleSIConfig

      logsyncEnabled: true

      stageEnabled: false

      recoveryModel: ARCHIVELOG

      controlFileAutoBackup: false

      openResetLogs: false

      backupRedundancy: 1

      rmanChannels: 4

      rmanParallelism: 4

      onlineRedoLogGroups: 8

      onlineRedoLogSize: 100M

      memoryTarget: 6G

      sgaTarget: 2G

      pgaAggregationTarget: 2G

      sharedPoolSize: 512M

      largePoolSize: 256M

      javaPoolSize: 256M

      streamsPoolSize: 0M

      dbWriterProcesses: 4

      logBuffer: 10M

      dbFiles: 128

      dbFileMultiblockReadCount: 16

      maxSharedServers: 8

      parallelMaxServers: 4

      undoManagement: AUTO

      undoTablespace: UNDOTBS1

      undoRetention: 14400

      sessions: 200

      processes: 200

      openCursors: 400

      optimizerMode: ALL_ROWS

      optimizerIndexCostAdj: 100

      optimizerIndexCaching: 0

      optimizerDynamicSampling: 2

      optimizerDynamicSamplingLevel: 2

      parallelDegreeLimit: 16

      parallelForceLocal: false

      parallelDegreePolicy: MANUAL

      parallelMinPercent: 0

      parallelMinServers: 0

      parallelServerTarget: 8

      parallelServerAdaptive: false

      parallelServersTargetPercent: 0

      optimizerUseSqlPlanBaselines: false

      optimizerCaptureSqlPlanBaselines: false

      optimizerUseStoredOutlines: false

      optimizerCreateDefaultStoredOutlines: false

      optimizerAdaptivePlans: false

      optimizerAdaptiveStatistics: false

      optimizerAdaptiveHints: false

      optimizerAdaptiveFeatures: false

      optimizerEnableIndexUsage: true

      optimizerEnableIndexCombine: true

      optimizerEnableNestedLoopJoin: true

      optimizerEnableHashJoin: true

      optimizerEnableSortMergeJoin: true

      optimizerStarTransformation: false

      optimizerBitmapAnd: true

      optimizerDynamicSampingAuto: 2

      optimizerDynamicSampingLevel: 2

      optimizerSecureFile: true

      optimizerRowLevelSecurity: false

      optimizerGatherStatsJob: true

      optimizerUsePendingStatistics: true

      optimizerUseHistograms: true

      optimizerHistogramsSampleSize: 16

      optimizerHistogramsRetention: 31

      optimizerHistogramsCursorInvalidation: false

      optimizerExtendedStats: false

      optimizerAdaptiveCursorSharing: false

      optimizerBindPeekUserBinds: false

      optimizerStarTransformationOptimizer: false

      optimizerBitmapFeedback: false

      optimizerRowToColumnEnabled: false

      optimizerPartialIndex: false

      optimizerAggregateFeedback: false

      optimizerEnableIndexJoin: true

      optimizerHashJoinEnabled: true

      optimizerSortMergeJoinEnabled: true

      optimizerNestedLoopJoinEnabled: true

     


Comments

Post a Comment

Popular posts from this blog

Java Practice Questions MCQ

1. What is the output? class point1 { static void a (int x, int y) { this.x=x; //non-static variable this cannot be referenced from a static context this.y=y; System.out.println(x+ “,”+y); } } class point { public static void main (String[] args) { point1 pp=new point1(); pp.a(4,3); } } a. 4 ,3 b. 3 ,4 c. Compile Error d. None of the above ------------------------------------------------------------------------------------------------------- 2. Local variables cannot be declared as final.(True / False) .... False ----------------------------------------------------------------------------------------------------- 3. What is the output? class A { A(int x, int y) { this.x=x; this.y=y; } A() { this(2,3); } public static void main(String[] args) { A a1 = new A(); System.out.println(“x=”+a1.x+”,y=”+a1.y); // cannot find symbol x and y } } a. x=2 y=3 b. x=-1
Read more

HackerRank Introduction Challenges - Java

HackerRank Introduction Challenges - Java Welcome to Java! Problem Statement Welcome to the world of Java! Just print "Hello World." and "Hello Java." in two separate lines to complete this challenge. The code stub in the editor already creates the main function and solution class. All you have to do is copy and paste the following lines inside the main function. System.out.println("Hello World."); System.out.println("Hello Java."); Sample Output Hello World. Hello Java. Download Code Here Java Stdin and Stdout 1 Problem Statement In most of the Hackerrank challenges, you need to read input from stdin (standard input) and write your output in stdout (standard output). One way to take input from stdin is to use Scanner class and reading from System.in. You can write your output to stdout simply using System.out.printf function. In this problem you need to read 3 integers from stdin and print them
Read more

SQL

I have put in my best efforts to ensure the task's completion meets the expected standards and aligns with the desired outcomes. I have also attached any relevant documents, reports, or deliverables associated with the task for your convenience. Should you require any further information or clarification regarding the completed task, please do not hesitate to reach out to me. I am available to discuss any aspects in more detail or provide additional support as needed. Thank you for entrusting me with this task. I look forward to your feedback and guidance on the next steps or any revisions required. SELECT (SELECT COUNT(*) FROM USER_TABLES) AS table_count, (SELECT COUNT(*) FROM USER_VIEWS) AS view_count, (SELECT COUNT(*) FROM USER_INDEXES) AS index_count FROM DUAL; SELECT      (SELECT COUNT(*) FROM USER_TABLES) AS table_count,     (SELECT COUNT(*) FROM USER_VIEWS) AS view_count,     (SELECT COUNT(*) FROM USER_INDEXES) AS index_count,     (SELECT COUNT(*) FROM USER_TABL
Read more