Hi,
Can anyone tell me the difference between Oracle OCI stage and Oracle Enterprise Stage. Are they one and the same or is there any difference.
Thanks in Advance,
Sridhar.
Difference between Oracle OCI and Enterprise Stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's a lot of difference, which even a cursory reading of the manuals would reveal.
Is this an interview question?
Essentially, the Oracle OCI stage is used in server jobs and has no innate parallelism, whereas the Oracle Enterprise stage is used in parallel jobs and can handle parallel execution, if the Oracle connection permits. SELECT from a non-partitioned Oracle table is always sequential using this stage type.
Is this an interview question?
Essentially, the Oracle OCI stage is used in server jobs and has no innate parallelism, whereas the Oracle Enterprise stage is used in parallel jobs and can handle parallel execution, if the Oracle connection permits. SELECT from a non-partitioned Oracle table is always sequential using this stage type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.