My Oracle Support Banner

Database Extract 7.x and 8.x Performance Troubleshooting (Doc ID 477174.1)

Last updated on OCTOBER 02, 2023

Applies to:

Siebel Remote - Version 7.0.4 [14068] and later
Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.
Area(s):Remote/Replication/Anywhere
Release(s):V7 (Enterprise), V8
Database(s):DB2, Microsoft, Oracle
App Server OS(s):AIX, Solaris, Windows, HP-UX
Latest release tested against:V7 (Enterprise)
Keywords:Database, extract, performance, RDBMS, Oracle, DB2, MS SQL SERVER

This document was previously published as Siebel Troubleshooting Steps 15.



Purpose

Database Extract Performance.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Poorly performing queries
 Database fragmentation issues
 Network connectivity and intermittent system issues
 Tips to improve performance of the Database Extract task
 ODBC Array Size parameter for Oracle databases
 Database Extract Maximum Data File Size parameter
 Perform the Database Extract to CDROM
 Parallel Database Extract Task in Siebel 7

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.