DRS, Oracle OCI and Oracle Enterprsie
Moderators: chulett, rschirm, roy
DRS, Oracle OCI and Oracle Enterprsie
Hi All,
DRS, Oracle OCI and Oracle Enterprise supports partitioning feature. We are going to use Oracle 10g DB for source and target. In existing system DRS stage is used with Server jobs. We are migrating to DS EE for performance enhancement. Data will range from 100 KB to 2 GB per source. Many such job having 2 GB source file jobs may run concurrently to load data into DB tables.
I know that DRS is primarily required if there is a possibility of changing the DB in future.
Which stage will better suite here?
Thanks in advance.
-Aquilis
DRS, Oracle OCI and Oracle Enterprise supports partitioning feature. We are going to use Oracle 10g DB for source and target. In existing system DRS stage is used with Server jobs. We are migrating to DS EE for performance enhancement. Data will range from 100 KB to 2 GB per source. Many such job having 2 GB source file jobs may run concurrently to load data into DB tables.
I know that DRS is primarily required if there is a possibility of changing the DB in future.
Which stage will better suite here?
Thanks in advance.
-Aquilis
Aquilis
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi
Oracle enterprise stage is better but has 1 problem it require access to some dba related tables which due to security reason its very difficult to convince client or dba.
Sanjay
Oracle enterprise stage is better but has 1 problem it require access to some dba related tables which due to security reason its very difficult to convince client or dba.
Sanjay
chulett wrote:I guess that's one way to get your post count up quickly.![]()
The Oracle Enterprise stage is the only one native to the Parallel engine.
I read the whole documentation for Oracle OCI and oracle ENterprise
and odbc connector and odbc enterprise...
just some options differences here and there....!
Can any one please give me cut throat defintions about these stating the differences b/w oracle enterprise and oracle oci, odbc connector and odbc enterprise stage?
and odbc connector and odbc enterprise...
just some options differences here and there....!
Can any one please give me cut throat defintions about these stating the differences b/w oracle enterprise and oracle oci, odbc connector and odbc enterprise stage?